This Easy to use tool allows the user to connect to any database and browse it This Easy to use tool allows user to connect to any database and browse or modify data, run sql scripts, export and print data. Database Browser 5. The program was created by the developer as a freeware product, but donations for the continued development are highly appreciated. You may generally make a donation via the developer's main web site.
Note that a recent version of Tcl is required in order to build from the repository sources. The amalgamation source code files the "sqlite3. About Documentation Download Support Purchase. Search Documentation Search Changelog. See the change log or the timeline for more information. C source code as an amalgamation , version 3.
C source code as an amalgamation. Documentation as a bundle of static HTML files. We have added a new feature for configuring conditional formats in the Browse Data tab. With this, you can set colours, font, font size, text alignment, and more depending on the values of the cell. It works very similarly to what you might know from your spreadsheet application.
Conditional formats are set per column and multiple formats can be configured for each column. Conditional formats can select for anything that can be filtered for, e. Your configured conditional formats are saved to your project files as well. Additionally there is a new format toolbar which allows you to set formats arbitrarily without giving any condition. This allows you to format the table contents just like a table in your favourite spreadsheet application, e.
SQL queries are now running in a separate thread. This means the UI can respond while the query is running. For long-running queries, this makes a huge difference because it allows you to cancel the query anytime. SQLite does not support accessing the database from multiple threads simultaneously for all database configurations.
Because we want to make sure that it is impossible to corrupt a database file, DB4S does not allow two queries or one query and another long-running process to run simultaneously. In the status bar, you are now notified of any long-running processes and you can cancel them too. But no worries: Whenever you try to start a second query, a message box will inform you and let you decide whether to cancel or wait for the other process to finish. It is now possible to sort by multiple columns in the Browse Data tab.
You can configure any number of sort keys. Their order will appear in the column headers. Simply clicking a column header resets any old sort orders and sorts by just the clicked column. To add another sort key hold the Ctrl key while clicking the column header. Holding the Ctrl key and clicking a column header which is already in the list of to columns for sorting changes the sort order of that column.
All the columns used for sorting are stored in your project files. The parser is not perfect and when failing to parse a certain table or index schema, you will not be able to use all features of DB4S on that table or index. Especially editing the schema but also to some extent modifying the contents of the table will not be possible. So even though it is not directly visible, the parser is a very important part of the application.
This release comes with a new parser. This allows us to fix a lot of problems, for example with complex CHECK constraints, which are now working as expected. The new parser is not only more robust, but it also extracts more information out of the SQL statements which makes editing these tables a smoother experience.
0コメント