You wanted to use those fancy Postgres features so you wrote raw SQL. Some time and a few more features go by and now your app is littered with SQL strings. Keep the power and lose the mess by building composable query objects that leverage Arel, the query builder under the hood of ActiveRecord.
This presentation starts with the basics you need to know as an app developer about interacting with your PostgreSQL database. Then, it digs into how you can start to analyze performance. You will learn what you need to know for a small application, then the things you should be cautious of as you start to …
PostegreSQL is a plain old SQL database, very powerful and very consistent. In some case, project needs an ACID database, but schemaless.. With JSON support, PostegreSQL is a very interesting tool to provide ACID and some very interesting function (time management, localisation function and data types…) and the schemaless NoSQL point of view with JSON …
As is the case for many websites and applications, when the size of its users reach a certain point, critical changes to the architecture must be made. This presentation discusses how Lanyrd addressed this problem, when they decided to move from MySQL to PostgreSQL, and from AWS to Softlayer.
Now that Oracle owns MySQL, it’s clear that it’s not going anywhere fast. What’s a developer to do? Flee to the arms of NoSQL? Are you going to have to learn Erlang just to query your data? Forget all of that. Postgres is the answer to your database needs. It’s mature and powerful, and the …
Your fledgling social network for hedgehogs is starting to gain traction, but now new feature requests are pouring in. How you can you meet the demands of an ambitious product team within your existing stack? There’s no time to waste, so we will look at how to leverage the venerable Postgres workhorse.