Databases
-
Software Development
Extending PostgreSQL: Complex Number Data Type
A few years ago I discussed creating user-defined types using PL/java. (Introduction to PostgreSQL PL/Java, part 4: User Defined Types)…
Read More » -
Software Development
Unleash the power of storing JSON in Postgres
An article by Sarah Mei titled “Why you should never use MongoDB” discusses the issues you’ll run into if you…
Read More » -
Software Development
The Evolution of Database Schemas using SQL + NoSQL
Part two of the two part series: Rethinking Database Design with Apache Drill In part one of this series, Drilling into…
Read More » -
Software Development
MySQL vs. MongoDB: Choosing a Data Management Solution
Table Of Contents 1. Introduction 2. The dominance of RDBM systems 3. A new era of NoSQL movement 4. Tables…
Read More » -
Software Development
Blue-Green Deployment With a Single Database
A blue-green deployment is a way to have incremental updates to your production stack without downtime and without any complexity…
Read More » -
Software Development
Discovering the Computer Science Behind Postgres Indexes
This is the last in a series of Postgres posts that Pat Shaughnessy wrote based on his presentation at the…
Read More » -
Software Development
Rethinking database schema with RDF and Ontology
When I joined the industry 10 years ago, my first project used relational database. After that, my next project also…
Read More » -
Enterprise Java
Do Not Make This Mistake When Developing an SPI
Most of your code is private, internal, proprietary, and will never be exposed to public. If that’s the case, you…
Read More » -
Software Development
PostgreSQL’s Best-Kept Secret, and how to Use it with jOOQ
PostgreSQL has a lot of secret data types. In recent times, PostgreSQL’s JSON and JSONB support was hyped as being…
Read More »