Using serial or integer IDs as a primary key isn’t always the best choice due to data leakage and scaling issues, so unique IDs may be preferred. Here’s an alternative to UUIDs that’s a bit cleaner visually.
Rolling out and managing a database can bring new challenges for an organization. Outside help can optimize results to achieve a maximum return on investment. Learn five key questions to ask about evaluating and selecting service providers to support new Postgres deployments.
Indexes are key to improving performance of queries against your database. This great intro gives you a nice overview, and a little hands on, of the principles behind them.
Having a clearly defined schema is always optimal, but sometimes a schema isn’t initially so obvious to define. JSONB can give you a lot of flexibility when you need to iterate quickly.
If psql isn’t quite your flavor when it comes to a client interface for Postgres, Datazenit might work for you. It’s a clean web-based client for interacting with your database and the 1.0 release packs a number of nice features.
PGCon is just around the corner and the list of talks is in. While not the prettiest visual presentation the content of the talks themselves looks to be top notch.
Come work with us as we rethink the tech stack for financial services. We need folks who are experts in database systems and are eager to make a big impact.
Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today.
