gwen-shapira

5 ms·

1.
PiLSMer: A data-free key-value store(norwood.github.io)
2 points by gwen-shapira 4mo ago|0 comments
2.
by gwen-shapira 7mo ago
Congrats on the launch! You may be under-selling LittleHorse a bit (here and even in the README). Few things I find cool about it: - How easy it makes writing human-in-loop workflows (or these days, agent-in-loop). Everyone wants human-in-l
3.
The Art of SQL Query Optimization(jnidzwetzki.github.io)
2 points by gwen-shapira 1y ago|0 comments
4.
What Happens When You Drop a Column in Postgres(thenile.dev)
6 points by gwen-shapira 1y ago|1 comments
5.
by gwen-shapira 1y ago
When you run ALTER TABLE test DROP COLUMN c Postgres doesn't actually go and remove the column from every row in the table. This can lead to counter intuitive behaviors like running into the 1600 column limit with a table that appears
6.
Show HN: Nile-Auth – open-source auth designed for multi-tenant apps(github.com)
5 points by gwen-shapira 2y ago|0 comments
7.
by gwen-shapira 2y ago
This is a great question. At this point, all transactions go through a single transaction coordinator that uses 2PC to coordinate all transactions. This makes many aspects of coordination fast, reliable and simple. It works well because OLT
8.
by gwen-shapira 2y ago
We are planning to open source it soon. Last few cleanups :)
9.
Pg_karnak: Transactional schema migration across tenant databases(thenile.dev)
29 points by gwen-shapira 2y ago|5 comments
10.
Pgvector 0.8.0 released (early look at new features)(thenile.dev)
3 points by gwen-shapira 2y ago|0 comments
11.
Debunking Few Pgvector Myths(thenile.dev)
1 points by gwen-shapira 2y ago|0 comments
12.
by gwen-shapira 2y ago
We are still solving problems for all multi-tenant applications. But AI companies, that tend to scale faster, also seem to benefit the most. So we wanted to make this clear.
13.
by gwen-shapira 2y ago
(co-founder of Nile here) You are right, it is hard to cover everything in one blog... But the gist is that schemas and all the objects in them have few significant drawbacks: 1. Catalog overhead. Each schema has all the objects. PG Catalog
14.
Everything a developer needs to know about Generative AI for SaaS(thenile.dev)
4 points by gwen-shapira 2y ago|1 comments
15.
by gwen-shapira 2y ago
I wrote a short guide to popular AI concepts, because I got a bit tired that reading a tweet requires a PhD. This is also the first part of a mini blog series about my adventures building AI Code Assistant with OpenAI, LangChain and pg_vect
16.
Craft – Our dedication and love for the invisible work(doc.cc)
1 points by gwen-shapira 3y ago|0 comments
17.
by gwen-shapira 3y ago
It should read "code" instead of "pre". I'm pushing a fix right now.
18.
by gwen-shapira 3y ago
The OP mentioned that SQLServer does lock (but then, it doesn't use SSI - just SI). The recommendation in PG docs to use a combination of SERIALIZABLE and READ ONLY transactions seems like a good one for read-heavy systems.
19.
by gwen-shapira 3y ago
Possibly. I tried hard to have some memorable examples. But I'll be honest: Every time I got review comments (or re-reviewed myself), it took a bit of time for my brain to warm up again into "transaction mode". The big lesson
20.
by gwen-shapira 3y ago
It is mentioned in the doc, but can be easy to mis-understand: "If a pattern of reads and writes among concurrent serializable transactions would create a situation which could not have occurred for any serial (one-at-a-time) execution
21.
by gwen-shapira 3y ago
In case you are wondering why we don't have templates for your favorite language or framework - we are not yet done. We are planning to keep adding many more. You can also request or vote, so we can prioritize with the community: http
22.
by gwen-shapira 3y ago
hey :) I also like Rails acts_as_tenant. We searched far and wide for something similar for JS ecosystem and so far, didn't find anything. We build our JS SDK by wrapping Knex (nice query builder, not quite an ORM) and injecting our
23.
by gwen-shapira 3y ago
Indeed! How did you guess?
24.
by gwen-shapira 3y ago
We don't have per-tenant schema right now, but we have started designing multi-version experience and it doesn't seem too far from here. Nile is different from DB per tenant in a single PG cluster in that it is much lower overhead
25.
by gwen-shapira 3y ago
Our goal is to make it transparent. The architecture includes proxy layer that handles routing and maintains the connections, so we believe broken connections are avoidable.
26.
by gwen-shapira 3y ago
Exactly that! Notion, Figma, Loom, Slack, Discord, Sentry have all been an inspiration toward the problem we are trying to solve.
27.
by gwen-shapira 3y ago
Technically true, since we did all that with Postgres :)
28.
by gwen-shapira 3y ago
Serverless isn't just hidden and priced in - it is supposed to scale automatically with your use. AWS Lambda lets you think about "invocations" and not CPU and you trust that the CPU will show up when needed. At Nile we hope
29.
by gwen-shapira 3y ago
We don't have an official example yet, but I expect it will work. So far every JS framework that uses https://node-postgres.com works great and so no reason to think Drizzle wouldn't.
30.
by gwen-shapira 3y ago
Noted :) I was checking out Xorm last night. It looks awesome!

More ›