39,385 downloadsUpdated: April 12, 2021Donationware / GPLv3

Manage as many SQLite databases as you want and add new tables, triggers, columns and indexes with this practical and useful application

What's new in SQLiteStudio 3.3.3:

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.SQLite is the most used database engine in the world. SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.SQLite is the most used database engine in the world. Apr 05, 2013 SQLiteStudio is a SQLite database manager with the following features: single executable file no need to install or uninstall, intuitive interface, all SQLite3 and SQLite2 features wrapped within. SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views. SQLiteStudio is a SQLite database manager with the following features: single executable file no need to install or uninstall, intuitive interface, all SQLite3 and SQLite2 features wrapped within.

Bugfix release

Read the full changelog

SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.

The application comes with an intuitive interface and well-organized menus. Since it does not require you to install it, all you have to do is to double-click the installer and start managing your SQLite databases effortlessly.

The left panel displays all of the available databases along with their data. The hierarchical tree view allows you to select any table, trigger, procedure or statement and view the data in the main window.

From the ‘Databases’ menu you are able to open a new *.db, *.sdb, *.sqlite or *.db2 file and connect to it using the right-click menu. Additionally, you can import schema from other databases or from various file formats such as CSV and dBase. After that, you can view all the existing data and manipulate it the way you want.

The Tables menu allows you to erase data, as well as create a new table and populate it by specifying the number of rows you want to add. In case you want to insert a new table in the existing database, you need to choose the proper options, then specify the table name, set table constraints and add as many columns as you want.

By using the ‘SQL query editor’ option, located in the Tools menu, you are able to manually create your SQL scripts and execute them. In this manner, you can view specific information from each table, or gather data from multiple tables using INNER JOIN statements.

Also, you can add a new trigger for the selected database by specifying its name, choosing its action, then writing the proper code.

In closing, SQLiteStudio comes in handy for users who need to manage and alter SQLite databases by inserting new tables, views, triggers and indexes.

Filed under

Download Hubs

SQLiteStudio is part of these download collections: SQLite Clients

SQLiteStudio was reviewed by Cristina Jitaru

4.0/5

This enables Disqus, Inc. to process some of your data. Disqus privacy policy

SQLiteStudio 3.3.3

add to watchlistsend us an update

8 screenshots:

runs on:: Windows 10 32/64 bit
Windows 8 32/64 bit
Windows 7 32/64 bit
file size:: 21.6 MB
filename:: sqlitestudio-3.3.3.zip
main category:: Internet
developer:
visit homepage

top alternatives FREE

top alternatives PAID

(1) By Bsy (Bshuyi) on 2021-07-02 03:50:18[link][source]

The result query from the SQLite is incorrect.

Some data are not being calculate by the formula but the data are included in the result table.

There are 10 row data, but only 9 row data is calculate, the another 1 row data is not calculate.

select (amount * rate) as cost

from report_A

Example:

Raw data: | Amount | Raterow 1 | 100 | 0.12row 2 | 50 | 0.15row 3 | 20 | 0.005row 4 | 60 | 0.13row 5 | 10 | 0.15row 6 | 67 | 0.005row 7 | 50 | 0.001row 8 | 87 | 0.006row 9 | 12 | 0.005row 10 | 43 | 0.12

Result:

Amount	Rate	Cost
row 1	100	0.12	12
row 2	50	0.15	7.5
row 3	20	0.005	0.1
row 4	60	0.13	7.8
row 5	10	0.15	1.5
row 6	67	0.005	0.335
row 7	50	0.001	0.05
row 8	87	0.006	0.522
row 9	12	0.005	0.06
row 10	43	0.12	0

Expected Result:

Amount	Rate	Cost
row 1	100	0.12	12
row 2	50	0.15	7.5
row 3	20	0.005	0.1
row 4	60	0.13	7.8
row 5	10	0.15	1.5
row 6	67	0.005	0.335
row 7	50	0.001	0.05
row 8	87	0.006	0.522
row 9	12	0.005	0.06
row 10	43	0.12	5.16

(2) By anonymous on 2021-07-02 04:22:39in reply to 1[link][source]

Which program do you use and which sqlite Version? Is ist always the last record in answer table?

(3) By Bsy (Bshuyi) on 2021-07-02 05:35:24in reply to 2[link][source]

SQLite Studio 3.2.1

Not always the last record in answer table.

It is in the between of the set of data.

(4) By Larry Brasfield (larrybr) on 2021-07-02 05:35:39in reply to 1[link][source]

I executed this DDL to begin reproducing your incorrect result: CREATE TABLE report_A (row INTEGER, amount INTEGER, rate REAL);

Then I used your so-called raw data to create, then execute this DML: INSERT INTO report_A VALUES(1,100,0.120); INSERT INTO report_A VALUES(2,50,0.150); INSERT INTO report_A VALUES(3,20,0.005); INSERT INTO report_A VALUES(4,60,0.130); INSERT INTO report_A VALUES(5,10,0.150); INSERT INTO report_A VALUES(6,67,0.005); INSERT INTO report_A VALUES(7,50,0.001); INSERT INTO report_A VALUES(8,87,0.006); INSERT INTO report_A VALUES(9,12,0.005); INSERT INTO report_A VALUES(10,43,0.120);

Then, upon executing this query, SELECT row, (amount*rate) as cost FROM report_A;, I see this result set:1|12.02|7.53|0.14|7.85|1.56|0.3357|0.058|0.5229|0.0610|5.16

To me, it looks like the correct result. I get the same result with all versions of the SQLite CLI that I have tried. So you must be doing something different. What would that be? I suspect that difference is important.

(5) By Larry Brasfield (larrybr) on 2021-07-02 05:42:33in reply to 3[link][source]

You should understand that 'SQLite Studio' is not a product of the SQLite development team, and this forum is not the right place to deal with that product's misbehavior.

If you can reduce your problem to something reproducible with the CLI shell available at the SQLite Download page, that will be on-topic here. Super dx ball. I submit that your effort to reduce the problem that way is likely to reveal what is going wrong with your use of SQLite Studio. And if you end up showing that the problem is unique to SQLite Studio, you should bring it to the attention of that product's developers.

Sqlite Studio Tutorial

(6) By Stephan Beal (stephan) on 2021-07-02 05:45:21in reply to 3[link][source]

SQLite Studio 3.2.1

SQLite Studio is a 3rd-party project neither maintained nor supported by this project. If you can reproduce your query result with the sqlite3 CLI application (as Larry attempts in his response), the libsqlite3 C API, or the System.Data dot-net bindings for that API, this is the correct forum. I