News for hackers. Stuff that matters.
Re:Show HN: FSQL – Search through your file system with SQL-... by atemerev on Monday May 15, 2017 @05:42PM (#14345399)
I wanted to write the exact opposite: a Mysql/Postgres client as a FUSE filesystem driver. Namespaces -> folders, tables -> (editable) CSV files, stored procedures and settings accessible as (editable) plain text files.
Re:Show HN: FSQL – Search through your file system with SQL-... by howderek on Monday May 15, 2017 @09:08PM (#14346635)
If someone put data in a column that wasn't valid, like a string in a bigint column, would the table be altered or would the FUSE driver refuse to make the change?
Re:Show HN: FSQL – Search through your file system with SQL-... by vidarh on Tuesday May 16, 2017 @09:30AM (#14349381)
There's been some attempts. Here's one:

https://github.com/BMDan/DFuse

Re:Show HN: FSQL – Search through your file system with SQL-... by bbcbasic on Monday May 15, 2017 @06:00PM (#14345522)
Sounds dangerous!
Re:Show HN: FSQL – Search through your file system with SQL-... by atemerev on Monday May 15, 2017 @06:49PM (#14345879)
No more than DELETE FROM ... WHERE ... wait, where is WHERE?
Re:Show HN: FSQL – Search through your file system with SQL-... by philsnow on Monday May 15, 2017 @10:10PM (#14346871)
Even this can be made safe(r) if you only only only connect to your database nthrough a proxy that sanitizes queries. IIRC vitess adds an implicit LIMIT 10 to queries that don't have a limit.
Re:Show HN: FSQL – Search through your file system with SQL-... by cdmckay on Tuesday May 16, 2017 @03:14AM (#14347899)
A simple solution is to not allow UPDATE or DELETE statements without a WHERE clause.