8 ms·

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

by gizdan 5y ago

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?

handrous 5y ago
> 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.
- munk-a 5y ago
  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.
iKnowKungFoo 5y ago
It's PostreSQL all the way down.
- ofrzeta 5y ago
  Apart from the fact that this project is a spin-off of a MariaDB NoSQL example app. EDIT: I was wrong about this.
  - aleksi 5y ago
    I think you confuse an example with the proxy itself: https://github.com/MangoDB-io/MangoDB https://github.com/MangoDB-io/MangoDB
    - ofrzeta 5y ago
      Oh, I see, you are right. Misunderstanding on my part.
brian_herman 5y ago
Yes, PostreSQL is like the javascript of databases.
- mrweasel 5y ago
  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.
  - munk-a 5y ago
    > 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 https://github.com/wasmerio/wasmer-postgres
    - gnfargbl 5y ago
      Unfortunately, that is WASM on postgres, not postgres on WASM: https://medium.com/wasmer/announcing-the-first-postgres-extension-to-run-webassembly-561af2cfcb1 https://medium.com/wasmer/announcing-the-first-postgres-exte...
  - tkzed49 5y ago
    you might want to sit down for this one, but we're pretty close (sqlite): https://jlongster.com/future-sql-web https://jlongster.com/future-sql-web
    - andai 5y ago
      SQLite, on top of IndexedDB, on top of SQLite... the circle of life!
- spullara 5y ago
  MySQL is clearly the javascript of databases. PostgreSQL is the Rust of databases.
toomuchtodo 5y ago
Solid, boring tech as foundations for abstractions is a logical approach to system architecture.
rubyist5eva 5y ago
yes
_jal 5y ago
Anxiously awaiting the first FPS engine built out of sprocs and views.
- gfody 5y ago
  here's a start https://observablehq.com/@pallada-92/sql-3d-engine https://observablehq.com/@pallada-92/sql-3d-engine

by gizdan 5y ago

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?

handrous 5y ago

> 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.

munk-a 5y ago
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.

iKnowKungFoo 5y ago

It's PostreSQL all the way down.

ofrzeta 5y ago
Apart from the fact that this project is a spin-off of a MariaDB NoSQL example app. EDIT: I was wrong about this.
- aleksi 5y ago
  I think you confuse an example with the proxy itself: https://github.com/MangoDB-io/MangoDB https://github.com/MangoDB-io/MangoDB
  - ofrzeta 5y ago
    Oh, I see, you are right. Misunderstanding on my part.

brian_herman 5y ago

Yes, PostreSQL is like the javascript of databases.

mrweasel 5y ago
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.
- munk-a 5y ago
  > 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 https://github.com/wasmerio/wasmer-postgres
  - gnfargbl 5y ago
    Unfortunately, that is WASM on postgres, not postgres on WASM: https://medium.com/wasmer/announcing-the-first-postgres-extension-to-run-webassembly-561af2cfcb1 https://medium.com/wasmer/announcing-the-first-postgres-exte...
- tkzed49 5y ago
  you might want to sit down for this one, but we're pretty close (sqlite): https://jlongster.com/future-sql-web https://jlongster.com/future-sql-web
  - andai 5y ago
    SQLite, on top of IndexedDB, on top of SQLite... the circle of life!
spullara 5y ago
MySQL is clearly the javascript of databases. PostgreSQL is the Rust of databases.

toomuchtodo 5y ago

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

rubyist5eva 5y ago

yes

_jal 5y ago

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

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