ibrar74

8 ms·

1.
MCP Transport: Architecture, Boundaries, and Failure Modes(pgedge.com)
1 points by ibrar74 8mo ago|0 comments
2.
by ibrar74 9mo ago
I wrote this after shipping multiple RAG systems that broke in production. This post focuses on architecture choices, failure modes, and tradeoffs. No prompt tricks. No hype. Feedback from people running RAG in production is welcome.
3.
RAG Architectures AI Builders Should Understand(github.com)
3 points by ibrar74 9mo ago|1 comments
4.
by ibrar74 9mo ago
I am one of the authors. This post explains how we implemented vector search directly inside PostgreSQL, including index design, query execution, and operational tradeoffs. The goal is to keep embeddings and search close to the data instead
5.
Vector Search Inside PostgreSQL Without an External Database(github.com)
1 points by ibrar74 9mo ago|1 comments
6.
by ibrar74 9mo ago
This post explains why we still run AI workloads close to the database in some production setups. The focus is on data gravity, latency, compliance, and operational cost, not on rejecting the cloud outright. Cloud works well for many teams,
7.
Why On-Prem Databases Still Matter for AI Workloads(github.com)
3 points by ibrar74 9mo ago|1 comments
8.
by ibrar74 9mo ago
NeuronDB runs vector storage, similarity search, and RAG primitives directly inside PostgreSQL. The goal focuses on keeping embeddings, metadata, and query planning in one system. The repository includes a PostgreSQL extension, vector index
9.
Show HN: NeuronDB – Embeddings and vector search for PostgreSQL(github.com)
4 points by ibrar74 9mo ago|1 comments
10.
by ibrar74 9mo ago
This article does a good job separating model capability from system behavior. One point worth emphasizing is that most real failures come from the surrounding system, not the model itself. Tokenization choices, context truncation, retrieva
11.
How LLMs Work: Top Executive-Level Questions(sloanreview.mit.edu)
3 points by ibrar74 9mo ago|1 comments
12.
Understanding and Reducing PostgreSQL Replication Lag(pgedge.com)
2 points by ibrar74 2y ago|0 comments
13.
Setting Up Failover Slots in PostgreSQL-17(pgedge.com)
1 points by ibrar74 2y ago|0 comments
14.
Achieving High Availability in PostgreSQL Strategies Tools and Best Practices(pgedge.com)
2 points by ibrar74 2y ago|0 comments
15.
Using PgEdge to Achieve Ultra-High Availability for PostgreSQL(pgedge.com)
1 points by ibrar74 3y ago|0 comments
16.
The Significance of Multi-Master PostgreSQL(pgedge.com)
3 points by ibrar74 3y ago|0 comments
17.
Turn PostgreSQL into Graph DBMS(github.com)
10 points by ibrar74 4y ago|0 comments
18.
Improve PostgreSQL Query Performance Insights with Pg_stat_monitor(percona.com)
4 points by ibrar74 5y ago|1 comments
19.
What time-weighted averages are and why you should care(blog.timescale.com)
173 points by ibrar74 5y ago|26 comments
20.
PostgreSQL Database Security: Authentication(twitter.com)
5 points by ibrar74 6y ago|0 comments
21.
PostgreSQL 13 New Feature: dropdb –force(twitter.com)
2 points by ibrar74 6y ago|0 comments
22.
PostgreSQL_fdw Authentication Changes in PostgreSQL 13(twitter.com)
3 points by ibrar74 6y ago|0 comments
23.
Index Improvements in PostgreSQL 13(twitter.com)
2 points by ibrar74 6y ago|0 comments
24.
Migrating to PostgreSQL Version 13: Incompatibilities You Should Be Aware Of(twitter.com)
5 points by ibrar74 6y ago|0 comments
25.
Multi-Master Replication Solutions for PostgreSQL(twitter.com)
2 points by ibrar74 6y ago|0 comments
26.
Common PostgreSQL Errors(percona.com)
4 points by ibrar74 6y ago|0 comments
27.
by ibrar74 7y ago
It is valid syntax, you are comparing an "x" with "no value" and result will be "no value"
28.
by ibrar74 7y ago
Yes, that's the problem this blog try to explain. NULL means "no value", but this is not true for all the languages. So you better know what is the value of NULL in the language you are trying to use.
29.
by ibrar74 7y ago
What do you mean by never set? In the database, you can either enter a string (empty or non-empty) or NULL in a column. There no such thing called never set.
30.
by ibrar74 7y ago
Actually this blog is not about how many ways you can use NULL in the database. It's all about the people who have programming experience (C/C++/JAVA) and try to write the SQL queries.

More ›