sqlite-viewer
sqlite-viewer copied to clipboard
View SQLite file online
I wanted to include most of this functionality in a different web application, so I abstracted most of this out into a separate project which may interest sqlite-viewer users: [sqlite-view](https://gitlab.com/ryneeverett/sqlite-view)....
Added new welcome message and vertically centre aligned the main div. Haven't changed any functionality.
When entering this Query > UPDATE entries > SET category=( > SELECT S.nr FROM categories C, subcategories S > WHERE (C.name="Transport") AND (S.name="Öffentlich") AND (C.nr=S.catNr) > ) > WHERE nr...
Indicate that there is no data in a table, with a message.
Refresh the list of tables when I create a table. Refresh row counts when I delete or insert.
Consider this query: ```sql SELECT * FROM foo WHERE bar_id IN (SELECT id FROM bar) LIMIT 0,30 ``` The paginator will try to find the count by running `SELECT COUNT(*)...
https://github.com/inloop/sqlite-viewer/issues/38