News for hackers. Stuff that matters.
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 :)
Re:SQL Notebook by kalleboo on Wednesday May 10, 2017 @01:09AM (#14306043)
Which is basically how MySQL ALTER TABLE works internally anyway...
Re:SQL Notebook by tenken on Tuesday May 09, 2017 @07:02PM (#14304605)
doesnt support expressions on DEFAULT keyword of create table syntax. :(