snaga | 7 months ago | on: Ask HN: Advice for someone who wants to try AI-assisted coding?
snaga's comments
snaga | 10 years ago | on: Pivotal Greenplum Database has been open sourced
FYI.
[HACKERS] Patent warning about the Greenplum source code https://www.mail-archive.com/[email protected]/ms...
You may have to check this message before diving into the code.
snaga | 10 years ago | on: Show HN: sql_firewall – SQL Firewall Extension for PostgreSQL
> 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.
snaga | 10 years ago | on: Show HN: sql_firewall – SQL Firewall Extension for PostgreSQL
Yes, I think every database product needs similar solution to be protected. :)
snaga | 10 years ago | on: Show HN: sql_firewall – SQL Firewall Extension for PostgreSQL
Yes, it works well with prepared queries. :)
snaga | 10 years ago | on: Show HN: sql_firewall – SQL Firewall Extension for PostgreSQL
> 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. :)
page 1
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.