zapov

9 ms·

31.
by zapov 11y ago
I read your post as FUD regarding Postgres. That article has various issues, for example, calling Postgres commit protocol as a special case of two phase commit is not really correct. Postgres has 2pc: http://www.postgresql.org&#
32.
by zapov 11y ago
The parent post correctly pointed out that including Postgres in that list is misleading at least.
33.
by zapov 12y ago
No it's not. http://hperadin.github.io/jvm-serializers-report/report.html
34.
by zapov 12y ago
This particular query does a nested loop on the detail table, but basically yes. Only one iteration.
35.
by zapov 12y ago
https://github.com/ngs-doo/revenj/blob/master/tutorials/reve... SELECT p, array_agg(SELECT c FROM "MasterDetail"."Child_entity" c WHERE c."pa
36.
by zapov 12y ago
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 ;)
37.
by zapov 12y ago
You can avoid this in Postgres which supports objects and collections. So... no. O/R impedence doesn't apply to an ORDBMS
38.
by zapov 12y ago
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 yo
39.
by zapov 12y ago
> 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 y
40.
by zapov 12y ago
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...
41.
by zapov 12y ago
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.
42.
by zapov 13y ago
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 pr
43.
by zapov 13y ago
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.
44.
by zapov 13y ago
Not really an ORM but highly integrated with Postgres: https://github.com/ngs-doo/revenj
45.
by zapov 13y ago
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.
46.
by zapov 13y ago
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:&#
47.
by zapov 13y ago
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
48.
by zapov 13y ago
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
49.
by zapov 13y ago
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
50.
by zapov 13y ago
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?
51.
by zapov 13y ago
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.
52.
by zapov 13y ago
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.
53.
by zapov 13y ago
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 p
54.
by zapov 13y ago
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.
55.
by zapov 13y ago
Naming in hard. It's one of the two most difficult things in programming: naming, cache invalidation and one off errors.
56.
by zapov 13y ago
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.
57.
Ask HN: Would you find this kind of reporting useful?
1 points by zapov 15y ago|0 comments