Hacker News Reader

zapovon Call Me Maybe: MongoDB Stale Reads

The parent post correctly pointed out that including Postgres in that list is misleading at least.

zapovon Json vs. simplejson vs. ujson

No it's not.

http://hperadin.github.io/jvm-serializers-report/report.html

zapovon Modern SQL in PostgreSQL

This particular query does a nested loop on the detail table, but basically yes. Only one iteration.

zapovon Modern SQL in PostgreSQL

https://github.com/ngs-doo/revenj/blob/master/tutorials/reve...

SELECT p, array_agg(SELECT c FROM "MasterDetail"."Child_entity" c WHERE c."parentID" = p."ID") as c FROM "MasterDetail"."Parent_entity" p

zapovon Modern SQL in PostgreSQL

Postgres/Oracle supports such constructs.

And Revenj has been using it for years: https://github.com/ngs-doo/revenj

And yes, Revenj now comes with an offline compiler ;)

zapovon Automatic REST API for Any Postgres Database

You can avoid this in Postgres which supports objects and collections.

So... no. O/R impedence doesn't apply to an ORDBMS

zapovon PostgreSQL 9.4 Released

While that's a fair criticism (to have compiler offline), dsl-platform can be licensed for an offline use.

It's not like Revenj needs dsl-platform, but rather that dsl-platform integrates into Revenj.

So to make it blunt, would you try/use Revenj if it had part of dsl-platform compilers available for offline use?

zapovon PostgreSQL 9.4 Released

> At this point I'm convinced only MS know how to write LINQ providers that won't fall over the moment you try to do something useful with them.

I would argue Revenj + Postgres provide much better developer experience. But as you said, it's not written by Microsoft so that attitude doesn't help it out.

I'm 100% sure Microsoft can't write LINQ provider which actually understands Postgres and can use it to the fullest (as Revenj can).

zapovon PostgreSQL vs. MS SQL

If you are interested in Postgres way of doing multiple result sets you can check out my post on it https://blog.dsl-platform.com/multiple-result-sets-alternati...

zapovon ToroDB – Document-oriented JSON database on top of PostgreSQL

You might find Revenj (https://github.com/ngs-doo/revenj) interesting too. It maps DSL schema to various Postgres objects and offer 1:1 mapping between view in the DB and incoming/outgoing Json.

zapovon Toward a better programming

As someone who is trying to improve the situation (https://dsl-platform.com) it's strange getting feedback from other developers. While we are obviously not very good at marketing, when you talk to other developers about programming done on a higher level of abstraction usual responses are:

* I'm not interested in your framework (even if it's not a framework) * so you've built another ORM just like many before you (even if there is no ORM inside it) * not interested in your language, I can get most of what I need writing comments in php (even if it's not remotely the same)

It takes a lot of time to transfer some of the ideas and benefits to the other side and no, you can't do it in a one minute pitch that average developer can relate to.

zapovon RethinkDB 1.12: simplified map/reduce, ARM port, new caching infrastructure

This is not true. Both Oracle and Postgres are ORDBMS and you can work with objects/nested collections and all kind of non-relational constructs.

zapovon PostgreSQL: Jsonb has committed

Not really an ORM but highly integrated with Postgres: https://github.com/ngs-doo/revenj

zapovon F1: A Distributed SQL Database That Scales

We are using Oracle object types in plain SQL, so no, they are not PL/SQL exclusive. But yeah, you can do a lot less with them outside of PL/SQL.

zapovon F1: A Distributed SQL Database That Scales

Both Oracle and Postgres have objects and collections. This allows you to build hierarchical structures. Postgres unfortunately doesn't allow for recursive structures ;(

If you are interested in how to do it take a look here: https://blog.dsl-platform.com/postgres-bridge-between-worlds...

zapovon The Future of Programming

Can you expand on what's wrong with declarative design? I'm not talking about UML, but modeling specifically.

Since I've been doing it for quite a few years I guess I know a thing or two about MDA/MDE. And it's not about disdain for writing code.

zapovon Google+ spamming people every 2 weeks to put up a profile photo

I was in another country recently and Google decided that because I've used laptop on an airport that two of my accounts must have been hacked.

I have Thunderbird running on another computer and Claws tried to download my mail while on airport.

So thanks Google, I guess I will have to stop using those accounts, because I don't like sharing my phone number ;(

zapovon JSON vs hstore

Ok, I admit my comment is a little overboard.

Comparing Mysql migration to Postgres is not really helping this discussion. Postgres has transaction DDL with many schema change operations being O(1).

Most of the time your data has structure. Only parts of it are usually semi-structured. And yeah, I had this problem too, until I automated it and don't have it anymore. So I guess I'm a little annoyed when I see that schema change automation didn't really took off and people accepted JSON as a storage medium.

zapovon JSON vs hstore

I'm really failing to understand obsession with unstructured types in Postgres? Why can't you just use native types for hierarchical structures?

Is it really that hard for people to maintain database changes?

zapovon PostgreSQL 9.3 Beta 1 Released

Well, I'm arguing that flexible schema is better than no schema. And in practice schemaless is only about schema defined outside of database. It's a solution to the wrong problem.

zapovon PostgreSQL 9.3 Beta 1 Released

Postgres supports native nested structures. Well, as long as your structures are not circular. JSON everywhere is really a bad choice for most data structures. It's like having no structure at all.

zapovon PostgreSQL 9.3 Beta 1 Released

Postgres type system is so much better than any other RDBMS that it's a shame NoSQL guys didn't spend more time building on top of it. While their optimizer could use some work here and there it's improving all the time.

We are doing some pretty obscure stuff to it and it's serving us well. Oracle on the other hand requires so much attention and special handling with it's type system, that if there were an alternative, I wouldn't even bother with it.

zapovon Most data isn’t “big,” and businesses are wasting money pretending it is

Time/flexibility problem can be solved (but it's hard). Take a look at DSL Platform (shameless plug) if you are interested in building on top of database, while having very flexible model.

zapovon CSS Architecture

Naming in hard. It's one of the two most difficult things in programming: naming, cache invalidation and one off errors.

zapovon DSL Platform - Domain-Driven Design based MDA

Lead dev here.

I know that NoSQL on top of SQL is something many aspire to. This is my brainchild, so if you've got any technical questions, I'll gladly answer them.