Terrible choices: MySQL - The terrible pitfalls I've gotten myself into while using MySQL
Terrible choices: MySQL 28 December 2014 (updated 25 September 2017) I've used MySQL for a while now, and there were lots of surprising things I needed to cater for. This is from a Django and MySQL 5.5 perspective [*]. Later on you'll see the horrible things I did to work around. It was a terrible experience, as I've also used PostgreSQL ... Feel free to add your own experiences in the comments se
pgloader - migrate MySQL to PostgresQL
pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today! Introduction pgloader has two modes of operation. It can either load data from files, such as CSV or Fixed-File Format; or migrate a whole database to Postg
How To Dockerize A Golang Webapp With Postgres DB - Fabio Berger
How to Dockerize a Golang Webapp With Postgres DB Dec 19th, 2014 I’ve been playing around with Docker recently and have decided to use it in the deployment of a Golang Negroni + Postgres webapp I’ve been working on. In order to ensure future scalability and to comply with best practices, this meant spinning up two docker containers, one for the app and another for the database and linking the two.
What I think of jsonb
Unsurprisingly, there has been a lot of interest in the jsonb type, which made it into the upcoming 9.4 release of Postgres. I was initially a reviewer of jsonb, although since I spent weeks polishing the code, I was ultimately credited as a co-author. Jsonb is a new datatype for Postgres. It is distinct from the older json datatype in that its internal representation is binary, and in that it is
Why JSON in PostgreSQL is Awesome
Recently a commenter on Hacker News questioned the usefulness of the JSON data type in PostgreSQL. At the time I posted a brief response, but I have decided to take the time to write up a more detailed explanation here as I believe the JSON data type provides a significant benefit to developers. Too long; didn’t read: The JSON data type is useful for storing multi-level object graphs. It provides
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
Discovering the Computer Science Behind Postgres Indexes - Pat Shaughnessy
PostgreSQL + WAL-E + Cloudfiles = Awesome -
The Web is Slow Because of Database Queries in Loops
PostgreSQL: Don't use CHAR or VARCHAR | Hacker News
http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-nginx-and-postgresql.html
Bruce Momjian
Custom Sort Order on Postgresql