Hacker News Reader

Comment by gizdan | Hacker News Reader

And the other day there was a project that allowed to use MS SQL wire protocol on PostgreSQL, so my question is:

Are we just gonna implement everything on top of PostreSQL?

> Are we just gonna implement everything on top of PostreSQL?

On top of PostgreSQL? Which project keeps incorporating other database paradigms at a good clip, and includes a Foreign Data Wrapper feature?

Yeah, looks like it.

It makes me quite happy. I love working in Postgres' dialect and would happily port applications from other dialects to postgres chunk by chunk as stuff broke.

Solid, boring tech as foundations for abstractions is a logical approach to system architecture.

It's PostreSQL all the way down.

Apart from the fact that this project is a spin-off of a MariaDB NoSQL example app.

EDIT: I was wrong about this.

I think you confuse an example with the proxy itself: https://github.com/MangoDB-io/MangoDB

Oh, I see, you are right. Misunderstanding on my part.

Anxiously awaiting the first FPS engine built out of sprocs and views.

here's a start https://observablehq.com/@pallada-92/sql-3d-engine

yes

Yes, PostreSQL is like the javascript of databases.

Expect without all the data type issues and Postgresql having a sane design, Postgresql be a pleasure to use and having the courtesy of staying out of my browser.... Please don't tell me that someone compiled Postgresql to WASM.

> Please don't tell me that someone compiled Postgresql to WASM.

I don't believe that nobody has ever done this... And google delivers: https://github.com/wasmerio/wasmer-postgres

Unfortunately, that is WASM on postgres, not postgres on WASM: https://medium.com/wasmer/announcing-the-first-postgres-exte...

you might want to sit down for this one, but we're pretty close (sqlite):

https://jlongster.com/future-sql-web

SQLite, on top of IndexedDB, on top of SQLite... the circle of life!

MySQL is clearly the javascript of databases. PostgreSQL is the Rust of databases.

Agrees, MySQL is full of crap while Postgres kept too few craps. But the majority of the internet (especially in China) is built on top of a crap database, just like most of the websites nowadays are powered by crappy scriping languages (JS, Python, PHP). Whoever got it quick (and dirty most of the case) wins the market.

That's where Worse is better idiom [1], again, unfortunately shines: The world is not built on top of elegancy, but by brutality (in the same sense as brtualism architecture, not bloodlust) and rapidness.

[1]: https://www.jwz.org/doc/worse-is-better.html

Incidentally, RethinkDB in their postmortem[0] said MongoDB beat them by following Worse is Better.

[0]: https://web.archive.org/web/20170119021049/http://www.defsta...

Reply on news.ycombinator.com