HN user

snaga

534 karma
Posts27
Comments6
View on HN
h50146.www5.hpe.com 8y ago

PostgreSQL 11 New Features with Examples (Beta1) [pdf]

snaga
6pts0
h50146.www5.hpe.com 9y ago

[pdf] PostgreSQL 10 New Features with Examples

snaga
2pts2
github.com 9y ago

Show HN: Hecatoncheir: The Data Stewardship Studio

snaga
2pts0
www.nextplatform.com 9y ago

FPGAs to Shake Up Stodgy Relational Databases

snaga
3pts0
www.slideshare.net 9y ago

PostgreSQL Internals (1) for PostgreSQL 9.6

snaga
2pts0
lookaside.fbsbx.com 9y ago

PostgreSQL Internals (1) for PostgreSQL 9.6 [pdf]

snaga
2pts0
medium.com 9y ago

The Journey from Side Project to Open Source Company: Taking the First Step

snaga
3pts0
www.phoronix.com 9y ago

Pairing LLVM JIT with PostgreSQL Can Speed Up Database Performance – Phoronix

snaga
2pts0
madlib.incubator.apache.org 9y ago

Apache MADlib 1.9.1 Release (GA)

snaga
2pts0
blog.pgaddict.com 9y ago

Making debugging with GDB a bit easier – PostgreSQL Addict (2015)

snaga
1pts0
www.flashmemorysummit.com 9y ago

Flash Memory Summit 2016 Proceedings

snaga
1pts0
news.ycombinator.com 9y ago

Ask HN: What's your favorite outline editor which supports Markdown?

snaga
2pts1
www.pgcon.org 9y ago

PostgreSQL Index Internals

snaga
211pts21
15721.courses.cs.cmu.edu 10y ago

CMU 15-721 (Spring 2016) Database Systems

snaga
125pts28
community.hpe.com 10y ago

PostgreSQL 9.6 New Features with Examples [pdf]

snaga
5pts1
github.com 10y ago

Toshiba has open-sourced GridDB, a Scalable In-Memory KVS

snaga
56pts13
www.jetbrains.com 10y ago

How Developers Use Databases Today: A JetBrains Report

snaga
3pts0
github.com 10y ago

PgCenter – A Top Command for PostgreSQL

snaga
4pts0
github.com 10y ago

Pivotal Greenplum Database has been open sourced

snaga
195pts51
www.airpair.com 10y ago

SQL vs. NoSQL KO. Postgres vs. Mongo

snaga
2pts0
github.com 10y ago

Show HN: sql_firewall – SQL Firewall Extension for PostgreSQL

snaga
47pts15
lwn.net 10y ago

“Big data” features coming in PostgreSQL 9.5

snaga
226pts33
h30507.www3.hp.com 10y ago

PostgreSQL 9.5 New Features with Examples [pdf]

snaga
140pts38
axleproject.eu 10y ago

Alpha Release of 2ndQuadrant Unified Data Analytics (2UDA) – Axle Project

snaga
2pts0
lwn.net 11y ago

A report from PGCon 2015

snaga
14pts0
www.techrepublic.com 11y ago

Postgres pushes past MySQL in developer hearts

snaga
17pts8
pgsnaga.blogspot.com 11y ago

Postgres Toolkit 0.2 released

snaga
4pts0

I have tried the spec-driven development with Gemini (Gemini-CLI) and VS Code for a few weeks.

It is definitely inspired by Kiro by Amazon. (unfortunately, I'm still on the wishlist.)

It works fine for me, and I would recommend this approach to understand how AI-assisted coding works.

Parse analysis won't remove information from the query

That's right.

PostgreSQL's parse analysis keeps a statement structure with token-by-token in the parse tree, and PostgreSQL's query jumbling calculates a hash value from the parse tree.

So, it's possible to find something strange in the statement(s) if someone attempts to cheat.

there are many development shops that don't have strong database development talent on hand and really treat the database as some black box where to stuff data.

Exactly. That's the reason why we still see lots of SQL injection attacks and incidents, and the reason why I have created this module. :)