yrashk

7 ms·

31.
by yrashk 3y ago
Actually, some of the feedback that we received from fairly close to the source, was that Postgres as an application platform of a sort was the original vision for it. But I can see how this work can be perceived through your lense.
32.
by yrashk 3y ago
It's not currently spelled out in the readme, but our approach does lend for straightforward shipping of complete systems (data + code) to the edge because it's effectively just a replication of the database. We're working on
33.
by yrashk 3y ago
We don't really use connections but a pool of workers to process requests. Having http server tightly coupled with the database server makes for a responsive combo. We are still blocking workers, but prototyping improvements that will
34.
by yrashk 3y ago
I am aware of kdb, J and others in the space! Love their brevity and ingenuity. As you rightly point out, the idea behind Omnigres is to make a lot of these concepts available broadly.
35.
by yrashk 3y ago
Thank you for your kind words! The original dream was indeed a "one box" approach, even when they scale horizontally and to the edge. Perhaps a more accurate depiction of this is a "unified interface".
36.
by yrashk 3y ago
The current approach employed by Omnigres users is good old sessions (since latency to the database is non-existent) and omni_txn's transactional variables ( https://docs.omnigres.org/omni_txn/variables/ ) to s
37.
by yrashk 3y ago
Author here. Thanks for the feedback! The intention we have is to take what's right with the colocation approach and take the learnings of what was wrong with those before (such as the above or Illustra). Essentially, we're aiming
38.
by yrashk 3y ago
1. pgTAP is an extension, pg_yregress is not (although there are plans to make it available as such as well) 2. Allows for organizing and structuring nested tests (providing organizational clarity) 3. Binary encoding testing (useful for new
39.
by yrashk 3y ago
This is incredibly useful and it'd be great to add this helper to pg_yregress to improve the experience for IntelliJ users!
40.
by yrashk 3y ago
This is not "better than TAP" but rather better than implementing tests as captures of psql outputs as done in pg_regress. Besides that, there are other features that are harder or impossible to test in pg_regress, like binary enc
41.
Show HN: Pg_yregress, Structured Testing for Postgres(github.com)
56 points by yrashk 3y ago|17 comments
42.
Ask HN: What's your experience with stored procedures-heavy systems?
4 points by yrashk 3y ago|3 comments
43.
by yrashk 3y ago
Great project that helps creating better DX for Postgres! At Omnigres [1] we also use libpg_query for programmatic query manipulations as libpg_query has a deparser and that allows one to manipulate AST and output the text representation ba
44.
by yrashk 3y ago
I agree that SQL and flavors of PL/SQL have a 1980s vibe attached to them (well, they were born in those times!), but even small adjustments can make them feel better: for example, dropping the TYPING IN CAPS tradition. Queries like `s
45.
by yrashk 3y ago
Being able to implement a lot of business logic in SQL and pl/pgsql is another of the reasons I started developing Omnigres [1]. My initial motivation was to have something almost self-contained, just one thing to deploy infrastructure
46.
by yrashk 3y ago
Omnigres author here. While it's definitely possible (and perhaps even advisable) to build many application in sql (especially if your traditional backend is mostly just slinging sql queries), Omnigres by no means limits users to that.
47.
Make Postgres an Application Server, Gamified(yrashk.com)
1 points by yrashk 4y ago|1 comments
48.
by yrashk 4y ago
Have you ever wondered if Postgres can be a fully self-sufficient platform for your application? Learn how to make it become an application server and win some prizes, too!
49.
by yrashk 4y ago
Running your own version isn't that much work but I said the same thing about EKS and here I am paying my AWS bill ::shrug::
50.
Show HN: HackerIntro Resume Search(hackerintro.com)
8 points by yrashk 5y ago|0 comments
51.
I Never Expected to Start This(yrashk.medium.com)
2 points by yrashk 5y ago|0 comments
52.
Show HN: HackerIntro(hackerintro.com)
2 points by yrashk 5y ago|0 comments
53.
by yrashk 5y ago
Vanitate?
54.
Show HN: Gopkg, vanity package hosting for Go(gopkg.co)
6 points by yrashk 5y ago|5 comments
55.
by yrashk 6y ago
Love the level and amount of documentation/tutorials provided by the author! Also, wondering when and if the source code of Circle itself will be available.
56.
by yrashk 6y ago
You can't really have no privacy and freedom. Isn't that obvious?
57.
by yrashk 7y ago
I'm preparing a synchronous queue for the browsers. It's a queue that allows to send byte arrays between threads (workers) and it is based on SharedArrayBuffer and Atomics (subject to availability, currently works fine in Chrome,
58.
FOSS Project Spotlight: SIT (Serverless Information Tracker)(linuxjournal.com)
5 points by yrashk 8y ago|0 comments
59.
by yrashk 8y ago
I went through this thought process with SIT[1] -- it started out with issue tracking hard-coded into it but it has been later extracted into a separate model and the data & process models are being refined to make them much more generi
60.
Fighting the Server Conspiracy(medium.com)
2 points by yrashk 8y ago|0 comments

More ›