Re:SQL Notebook
by coleifer on Tuesday May 09, 2017 @03:47PM
(#14303235)
SQLite definitely presents some unique challenges, despite it generally being the "simplest" relational database. I've written a web-based SQLite database browser, which you can find here: https://github.com/coleifer/sqlite-web -- importantly, it supports all the `ALTER TABLE` statements you'd expect (add column, drop column, rename column, etc). This is done by renaming the table temporarily, creating a new table with the desired changes, then copying the data into the new table. Kinda clunky, but it works :)
[ Parent
| on HN ]
Which is basically how MySQL ALTER TABLE works internally anyway...