Indicate that there is no data in a table, with a message.

I will come to http://inloop.github.io/sqlite-viewer, download with single click and drag and drop to browser.

If there is a FTS5 virtual table created in the database, the file could not be opened by sqlite-viewer. At least by online version. However, it looks like the sql.js supports the virtual tables - sql-js/sql.js#392

Refresh the list of tables when I create a table. Refresh row counts when I delete or insert.

Save history of SQL commands

Provide a bigger box for entering SQL. A bigger font would be good too.

This prevents errors in urls with parameters
See patch file (check and apply).

git apply --check 0001-use-decodeURI-for-remote-URL.patch
git am < 0001-use-decodeURI-for-remote-URL.patch

0001-use-decodeURI-for-remote-URL.patch

From 83036066645a42fc32bed6cbdd26fb83e2b77fbd Mon Sep 17 00:00:00 2001
From: "[email protected]" <[email protected]>
Date: Tue, 16 May 2017 12:51:29 -0300
Subject: [PATCH] use decodeURI for remote URL

---
 js/main.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/js/main.js b/js/main.js
index eca5a64..8ebefb7 100644
--- a/js/main.js
+++ b/js/main.js
@@ -110,7 +110,7 @@ var loadUrlDB = $.urlParam('url');
 if (loadUrlDB != null) {
     setIsLoading(true);
     var xhr = new XMLHttpRequest();
-    xhr.open('GET', loadUrlDB, true);
+    xhr.open('GET', decodeURIComponent(loadUrlDB), true);
     xhr.responseType = 'arraybuffer';
 
     xhr.onload = function(e) {
-- 
2.7.4

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.

Here's a demo in which I've ported the sqlite-viewer application to my library with an aim for feature parity. The biggest difference is that I switched from select2 to choices for the table selector because I dropped jquery as a dependency.

To the maintainers: Sorry for abusing issues for self-promotion and thanks for open sourcing this application! I do mean this issue to be in the spirit of collaboration and not as an attempt to hard fork or hijack your project. I'd make a PR but the diff would basically be 100%.

This is exactly what I needed! 😁 Thank you for great work. 👍

This is really handy and i want to use it to debug my app but how would i go about auto loading a database?
UPDATE: nevermind... i just found the load url function. Thanks for this

When Fork Me on Github Link is clicked, it loads on the current tab. It would be a small usability improvement if that opens in a new tab.

Hi, thanks for this project- it's really cool!

Would it be possible to allow the loading of a sqlite db via url parameter? Like http://inloop.github.io/sqlite-viewer?url=http://mysite.com/data.sqlite?

... to have some preview on https://github.com/inloop/sqlite-viewer

Here. I'm no lawtician, but it seems like a good addition to fill these in.

Consider this query:

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(*) AS count FROM bar). Note the trailing closing parenthesis and the wrong table. This result in the pagination no longer works due to SQL syntax error.

Well.. it would be interesting to have a some sort of dockerize way to use it.

like:

docker run sqlite-viewer -v ${PWD}/data.sqlite:/var/www/data.sqlite -p 80:80

I am a novice.
I want to open the specified sql file.
When the web page is opened, the specified sql file is directly opened without dragging or opening.
Where can I modify the source code?
Thank you

Whole issue is in the title. the site freezes when you try to use 6 lines for a query

Dears,
I have an SQLite file that I couldn't open anywhere including Visual Studio Code with SQLite extension but your solution did.
I want to export the result into MySQL OR xlsx but I couldn't find it. I highly suggest you enable the export feature at least to CSV for us to get the benefit out of it. Currently, I am seeing my data without any use of the benefit.

Appreciate it if you could help me with that

Provide functionality to download a queried table as a csv file. This way we can freely compare data of multiple instances of the database. Or ability to upload 2 files at the same time and compare data between them

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 = 1

the webapp freezes

It happens when entering the text or pasting it into the text field.
Tested on Chrome and Firefox

Allow dropping tables

The CSS broke; probably due to some CSS dependency changing domains?

Database system information would be useful like version, tables, fields, etc.