Hi all,

This might interest those who want a lightweight sqlite gui that's based on a Windows look and feel. Maybe a Windows 95 look?

Github link: https://github.com/little-brother/sqlite-gui

Very nice and no dependencies and you can replace the sqlite3.dll

The schema for the prefs.sqlite can also be simplified. PRIMARY KEY is an alternate spelling for UNIQUE, so you only need one of them, not both.

Plus, something which is unique/primary key is already indexed so no need to create a duplicate index explicitly.

These just waste space but should no be harmful, at least not in up-to-date versions of SQLite3.

The functionality and interface is reminiscent of the old MS SQL Server Admin/Query Tool thingimy back before they made it useless (and slow as molasses running up hill in an Edmonton -40 degree Winter) by re-writing it in dot SNOT and calling it "SQL Manglement Studio".

I found a couple of bugs already and there are some UI annoyances, but it does seems to work, if you are into GUIs.

Hi LB,

thanks for creating the tool.

A minor bug I've found is that if you right-click a table before selecting it, the highlight jumps up to the previous highlighted table.

1. Open the tool with bookstore DB
2. Click books table
3. Right-click orders
4. Notice the highlight on orders quickly changes to books. If you query orders, it'll actually query books.

It would be nice to rename the editor tabs.

There doesn't seem to be a way to close an editor tab. Do you plan on adding that in?

Also, when I close a database, I would expect the editor window to close. Perhaps there can be a prompt to the user asking if they want to save their query.

I tested a little version 1.7.2 (came from forum post about Drill-Down) and my first test results are quiet good.

Some hints for improvement:

The splitters of the screen areas can be moved and the areas re-sized ... but the mouse does not show at which points on screen. It is usual in such GUIs to change the mouse cursor into a splitter symbol while it hoovers over the sensible area.

Thanks. I always forget about this improvement. I should it put on the top in To-Do list.

P.S. The best way to suggest smth is use Issues or email me at lb-im@ya.ru

Ok, Latest exe crashes on [Right-Mouse-Clk]-Export to csv of recent query results.

Could you provide more details e.g. data (or at least table structure) and the query text to reproduce error? Perhaps it's a BLOB trouble.

csv export is no longer double spaced for Windows, but why the semicolon to separate the records? Is that more common to use than a comma?

1;Steelheart;Brandon Sanderson;978-0385743563;5.0;3
2;All Our Yesterdays;Cristin Terrill;978-1423176374;7.3;10
3;Life After Life;Jill McCorkle;978-1616203221;2.82;4
4;Life After Life;Kate Atkinson;978-0316176491;8.1;5
5;Foundation;Isaac Asimov;978-0553293357;12.7;8
6;Dracula;Bram Stoker;978-0486411095;6.6;0

I like when data is queried with a right-click on a table, it opens in a new results tab, but find it not intuitive the query is placed in the same editor tab. Would you consider having the new query open a new editor tab with the new query?

App uses the delimeter applying on last CSV export.

Ah, I do see the options to use other column delimiters, but I agree that the default of a comma is a better idea.

Couple small things...

I don't know if it would ever be done, but you can't create an empty table. There's an error message when creating an empty table without any records:

---------------------------
Error
---------------------------
near ")": syntax error
---------------------------
OK   
---------------------------

Is there a way to save database changes, or does that happen automatically? When creating a new table in your bookstore example DB, it looks like it automatically saved it, without any kind of user ack. I suppose this is operating like the sqlite cli...there's no prompt to save before exiting. For a gui, though, a save db changes message might be expected.

The "save" icon (for save query) looks permanently grayed out, but it actually saves queries. Is that by default?

Is that by default?

I meant to ask if that's by DESIGN. As is, is it by design to have the icon look grayed out/disabled.

Ironically, it's your pipe character that's causing a problem with your post's formatting: click Edit, then click the "Markup Style" link to learn more about Markdown formatting, which will explain why it's being formatted thus.

Solution: put the pipe in backticks.

Heh, what a newbie. Thanks eh! What should have appeared is the pipe symbol |.

1.3.1 released

• Show referenced data by Alt + Click
• Workflow manager (beta)
• Query the table data in a new tab
• F5 to refresh tree
• REDO in Editor by Ctrl + Shift + Z
• Decode and concat functions
• Back up prefs.sqlite
• Fix sorting in data grids
• Fix csv import
• Recompile sqlite3.dll
• Change icu extension to third party
• Minor changes

This release introduced a new ETL tool to execute sequences of parameterized queries and import/export data via ODBC to SQLite database.
It's a simplifier version of SSIS and Apache NiFi :D Check Wiki to learn more.

Download 1.3.1

1.3.1 released

• ODBC import
• Database comparison
• Database search
• Database statistics
• Fix bugs

Download 1.3.2

Since 1.3.2 I have added two features

1. Enable/disable indexes/triggers
2. Special an editor tab with terminal mode (picture).

Download 1.3.6

P.S. I don't feel as I have right to publish releases here. So I stop it :)

This download is blocked by Chrome.

Thanks a lot! I don't know about this issue because I primarily use Firefox.

This is due to the fact that some antiviruses do not like small files :/

But the fact that this is the reason for the blockage is nonsense.

I recompiled all dll-s with -O option (optimize for speed) and updated releases files to reduce a Chrome paranoia.

See here for details

Expand Technical Information for ways to circumvent.

None of them cause triggering the virus detection. I don't use any of them.
I've been told that a reason is a empty entry point like this. I'm a not skilled C-programmer, so it take a time to grok it.

If it helps, this is the reason logged for detecting a threat:

Detected: PUA:Win32/InstallCore
Status: Failed
This threat or app might not be completely remediated.
This program has potentially unwanted behaviour.

On Windows 10 using Chrome or Edge to download the zip from the link given.

Thanks for your report. I'll try to fix it.
P.S. I added it as a new issue.

Looks like I solved the problem by a compiler update. I recompiled dlls and now it is safe from a virustotal's point of view.