What am I missing in database programming 2015
There is a lot movement in database systems, a lot of them are quite innovative and novel. Most of them are so-called NOSQL databases trying to solve Big Data problems or are just for analytics. I think the misuse of MongoDB for primary data shows there is something missing - structured DBS as primary storage.
I use PostgreSQL whenever I can. But for any of my applications it didnt scale much. I mean after few tables the repetition was enormous. Its perfect relational database system, or just right abstraction for SQL: domain types, good procedural support, JSON for structured data fetching, check constraint, sensible defaults...
What I really want for most of my apps is a database system that is as reliable (consistent from CAP) as any relational DBS, but is made to store structured data. You could store structures, that has attributes which can be are another structures. The supported types could be just the ones that are now in PostgreSQL. It could even store it underneath as relational tables, the implementation doesn’t matter.
That way I would store only relational data into relational tables, everything else would be nested, but typed and safe. I believe there is nothing like that out there.