3 ms·
I wanted to write the exact opposite: a Mysql/Postgres client as a FUSE filesystem driver. Namespaces -> folders, tables -> (editable) CSV files, stored procedu
by atemerev 9y ago
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.
- howderek 9y agoIf 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?
- bbcbasic 9y agoSounds dangerous!
- atemerev 9y agoNo more than DELETE FROM ... WHERE ... wait, where is WHERE?
- philsnow 9y agoEven 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.
- cdmckay 9y agoA simple solution is to not allow UPDATE or DELETE statements without a WHERE clause.
- vidarh 9y agoThere's been some attempts. Here's one: https://github.com/BMDan/DFuse https://github.com/BMDan/DFuse