Omnigres: Postgres as a Platform

Post by sixbrx » Mon, Oct 16, 2023, 12:32 PM UTC

dmitry-vsl wrote: post #52

ezekiel68 wrote: post #48

At some point during the dot-com era, Microsoft toyed with adding an HTTP server to its SQL Server product to enable similar development paradigms. My recollection is that this was a disaster on several fronts, not the least of which was that successfully breaching the HTTP server gave an attacker direct access to the database. This (and other considerations) make a good case for the kind of separation-of-concerns wh…

There was a similar tool developed by Oracle called mod_plsql, which served as an Apache web server module. As far as I remember, it allowed you to configure a mapping from a URL to a stored procedure. These stored procedures could receive HTTP request parameters and return HTML content. I've always felt that this approach is the right way to build applications. Application servers seemed like an unnecessary layer to…

Post by yrashk » Mon, Oct 16, 2023, 1:27 PM UTC

jarpineh wrote: post #59

Couple of questions (with notes): Yes, I'd really like to write code next to the db with more suitable (for task) languages like Python. But at the moment SQL alone is supported..? Could one connect with Jupyter notebook somehow and have a REPL like experience with Omnigres instance? Also, this [1] seems intriguing. How do containers connect to the db? What would the performance differences to the "internal" approach…

Post by yrashk » Mon, Oct 16, 2023, 1:30 PM UTC

lovasoa wrote: post #60

Twisell wrote: post #40

Earlier quoted context omitted.

Please elaborate because that sentence make barely no sense for modern SQL engine such as PostgreSQL. A good ressource to start exploring would be this site with compare features between vendors: https://modern-sql.com/

I think they were talking about syntax like INSERT INTO t(a,b,c) VALUES (1,2,3) I agree that something like INSERT INTO t VALUES a=1, b=2, c=3 would be much more readable.

Post by yrashk » Mon, Oct 16, 2023, 1:38 PM UTC

fulafel wrote: post #55

returningfory2 wrote: post #51

Earlier quoted context omitted.

> Comparing those numbers with a similar api built using fastapi and asyncpg, there was if i remember correctly at least 4x to 5x throughput increase. I wonder to what extent this improvement comes from not using Python, as opposed to using this alternative solution? For example after Python to Go migrations it’s common to see this kind of speed up I believe.

They might have used Python still - the Omnigres page lists Python support, and PG has had PL/Python for a long time.

Post by yrashk » Mon, Oct 16, 2023, 2:30 PM UTC

cpursley wrote: post #58

This is the sort of thing that gets me really excited. What’s the migration story? Migrations are what always trip me up, especially when there’s dependent logic.