Portable SQLite Expert Professional 6.1.3.724

 

 

SQLite Expert Portable is a powerful tool designed to simplify the development of SQLite3 databases. It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases.

SQLite Expert Portable is a powerful and intuitive database management software that allows users to easily design, maintain and manage SQLite databases. The software is designed for both novice and advanced users, providing a user-friendly interface and comprehensive set of tools for creating and managing databases.

One of the key features of SQLite Expert Portable is its ability to create and edit tables, indexes, triggers, views, and other database objects. Users can easily create new tables and fields or modify existing ones using the intuitive drag-and-drop interface. The software also includes a powerful SQL editor that supports syntax highlighting, code completion, and error checking, making it easy for users to write and execute complex SQL statements.

Another major feature of SQLite Expert Professional is its data editing and browsing capabilities. With this software, users can easily view, edit, and delete records in their databases. The software also provides a number of advanced data manipulation features, such as filtering, sorting, and grouping, which makes it easy for users to quickly retrieve and analyze data.

In addition to its database management features, SQLite Expert Professional also provides a number of useful tools for database maintenance and optimization. These include a compacting tool for reducing the size of databases, an integrity checker for ensuring data consistency, and an analyzer for identifying performance bottlenecks.

The software also provides a number of important security features, including support for encryption and password protection. This allows users to safeguard sensitive data from unauthorized access and ensure that their databases are protected against external threats.

One of the greatest advantages of SQLite Expert Professional is its cross-platform compatibility. The software is designed to run on Windows, macOS, and Linux operating systems, making it easy for users to access and manage their databases from any device or platform.

Another major advantage of SQLite Expert Professional is its scalability. The software can handle databases of all sizes, from small personal projects to large enterprise-level applications. This makes it an ideal choice for developers and organizations looking for a robust, reliable, and scalable database management solution.

Overall, SQLite Expert Portable is a comprehensive and powerful database management software that provides users with all the tools they need to design, maintain, and manage their SQLite databases. With its intuitive interface, advanced features, and cross-platform compatibility, it is an excellent choice for both novice and advanced users alike. Whether you are a developer working on a small project or an enterprise-level organization managing complex databases, SQLite Expert Professional has everything you need to get the job done.

Because it integrates database management and maintenance into an intuitive and user-friendly interface, the application can be mastered by both beginner and advanced users.

The main window of SQLite Expert Professional allows you to view all the connected databases and execute your own SQL scripts using the SQL Builder tab. The left panel displays all of the available tables so you can easily restructure fields, foreign keys, indexes or triggers without losing any information. The Data tab enables you to view and edit all the entries effortlessly.

In case you want to open a new database, you can access the File menu then choose the proper option or select the ‘Open Database’ button available in the main toolbar. After that, you will be prompted to select the file name and the alias for the new database, as well as some internal parameters such as Page Size or Encoding.

However, SQLite Expert Portable will automatically choose a default alias for the current database but you can change it according to your needs.

If you want to view the properties for the selected database such as the total number of existing tables or triggers you can easily access the Database tab.

The Design tab allows you to view, add, delete or modify fields, indexes, foreign keys, constraints and triggers using the right-click menu. Additionally, you can add new entries by selecting the proper button located at the bottom of the application.

What’s more, SQLite Expert Portable supports transactions with rollback and atomic commit so you can easily correct recovery from failures and make sure that your databases won’t be affected due to system crashes. In case you want to start a new transaction in the selected database, you can choose the proper option from the main menu or execute a Begin [Transaction] command in an SQL script.

Visual SQL Query Builder

– Build complex SQL queries with ease.
– Formatted SQL query text layout.
– Powerful means of SQL query parsing and analysis.
– Advanced SQL editor with syntax highlighting and code completion.

Data editing

– Edit data in the grid using powerful in-place editors.
– Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
– Visualize and modify BLOB fields using the integrated Hex editor.

Powerful restructure capabilities

– Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
– Restructure any complex table without losing data.
– Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.

Import and Export data

– Import data from ADO data source, CSV files, SQL script or SQLite.
– Export data to CSV files, SQL script, Excel or SQLite.
– Copy tables between SQLite databases using drag and drop operations.
– Export data to Excel via clipboard.

Other features

– Full Unicode support.
– Support for attached databases.
– Supports SQLite extensions and third-party SQLite libraries.
– Lua and Pascal scripting support.

Version 6 Changelog.

• A new Diagram page draws the whole database as an entity-relationship diagram: a box per table, view and virtual table, and a line between the columns each foreign key joins, marked with the cardinality worked out from the keys. Show table names alone, their key columns, or every column; arrange it automatically or place the tables yourself and the layout comes back with the file. It can be saved as a picture, exported to PDF tiled or as a single large page, and printed. A view or a virtual table is drawn in italic, with a tag naming what it is — View, or the module behind a virtual table, since fts5 says more about a box than “virtual table” would. Professional Edition.
• A file can now be imported into a table: JSON, XML, an HTML page, or a spreadsheet in ODS, XLSX or XLS form. The destination is a new table, created from the columns the file was found to have, or an existing one, matched by name. One dialog reads all four and shows what it found before anything is written — the columns, their types and how many rows — and says whether the file stated its columns or they were worked out from the values. A file holding more than one table offers them by name. Professional Edition.
• The JSON export asks what to do with a value that is itself JSON. Written as a string it comes out escaped, which is exactly what the column holds and reads like nothing anybody wanted; it can now be embedded in the file instead, so a JSON column reads as JSON. This covers a JSONB column and text holding a document alike. The same dialog carries the two options that were already there underneath: whether BLOB columns are included, and whether the file is formatted.
• The HTML and XML exports each write two genuinely different files, and now let you choose. The styled and formatted routes follow the grid, carrying the columns you can see, laid out as you see them; the data routes follow the dataset, carrying every column with its type — and the XML data route is the one the new import reads back.
• The export dialogs ask for the file name on the same form as the options, the way the text export always has, instead of in a Save dialog first.
• Every export can show you the file it wrote, if you ask it to: Tools → Options → Data → Open the file after exporting, off by default. A file type with nothing registered against it opens its folder with the file selected, rather than Windows’ “How do you want to open this file?” picker.
• The Options dialog has a Values page. How dates and times, booleans and GUIDs are stored moved off the Data page onto one of their own — three groups that answer the same question, and a Data page short enough to read without the dialog growing to fit it.
• Clearing an encryption key is confirmed. An empty key at the Set/Change encryption key prompt removes the encryption, leaving the file readable by anyone who has it, so it now asks first and defaults to No. It asks only where a key is actually being taken away.
• The database tree’s pop-up menu folds up: the extension commands under Extensions, and the import and transfer commands under Import/Export. It had grown long enough to run off the bottom of the screen.
• Arithmetic that overflows answers the way SQLite means it to. select 9.0e+307 * 10.0, select exp(1000.0) and an avg() over very large values each reported “Floating point overflow” instead of returning an infinity: SQLite is C, where an overflow yields infinity rather than an error, and the trap Delphi arms on every thread was catching it on the way out.
• Redesigned, rewritten help, now HTML-based, searchable and easier to read.
• Updated the SQL parser and code generation to support and take advantage of the latest SQLite features.
• Many fixes for issues uncovered by an extensive code review and a new unit-test suite.
• Lua print now behaves as it does in any other Lua interpreter: arguments are tab-separated, the line is terminated, and values of every type are rendered properly. io.write writes without separators or a newline. Older scripts that end a print with an explicit “\n” argument still work, but now produce an extra blank line.
• Fixed the scripting Output tab, which could show multi-argument print output in reverse order and silently drop repeated output.
• Fixed FileAge in Pascal scripts, which was published with a TDateTime parameter but bound internally to a different function. The date must now be received in a variable declared TDateTime; earlier versions accepted only a Double.
• Light and dark themes, with a mode picker on the toolbar. System follows the Windows setting as it changes, and is what a new installation starts on; each mode has a theme of its own, chosen once under Tools → Options → Themes. Two new themes ship with this release: DeepWhite, which a new installation uses for light mode, and DeepBlack for dark.
• The bundled dbdemos sample database now installs under the shared application data folder rather than beside the program. Scripts that referred to the old location need their path updated.
• A new Convert to STRICT command on one or more selected tables. A STRICT table refuses values that do not match its columns’ declared types instead of converting them, so the command is a wizard that reads the data first and shows what a conversion would do to it: the type each column would take, and how many rows would be refused, kept under a different type, or come back changed. Each column is offered the type that changes nothing, and ANY where no such type exists — a DECIMAL column holding both whole numbers and fractions, for instance. Nothing is altered until the last step, which shows the SQL before running it.
• Exported data now says what a cell holds. SQLite does not enforce declared types, so a column declared INTEGER can hold the text “seven”; every export format wrote such a value as the conversion’s default instead — 0, or a zero date — and an SQL script exported that way was not a copy of the table it came from. All formats now write the stored value, and a replayed script reproduces the storage classes of the original.
• A column declared BOOLEAN holding text that is not a boolean now shows that text rather than an unticked checkbox, which stated a false value nobody had established and looked no different from a stored 0. Which text counts as TRUE and FALSE can be set under Tools → Options → Data → Boolean; the defaults are what earlier versions recognised.
• Added JSON and JSONB to the type mappings. JSONB is SQLite’s binary form of a JSON document, so a column declared JSONB is now read as a blob rather than as text, which also lets Show JSONB as readable JSON apply to it.
• A table created from data rather than from SQL — by a text import, by the transfer wizard, or by a script — now declares its text columns TEXT rather than CHAR. CHAR(n) means fixed-width in standard SQL and these columns are not that; SQLite gives both names the same affinity, so nothing behaves differently. Existing databases are untouched.
• A blob stored in a column declared as text — which SQLite allows, and which a JSONB value in a JSON column is — used to leave an empty cell in the grid, no different from an empty string, and was dropped altogether by the CSV, TSV, HTML and XML exports. It now reads (blob) in the grid, and each format writes it the way it writes any other blob.
• An integer larger than 2⁵³ in a column read as a number — DECIMAL and NUMERIC columns keep whole numbers as integers — was shown and exported as the nearest value a floating-point number can hold: 9007199254740993 became 9007199254740992, and permanently so in an exported script. Such a value is now shown and written exactly.
• Fixed: sorting a large table by clicking a column header left the pointer spinning for the rest of the session.
• Fixed: a primary key declared as a table constraint with AUTOINCREMENT — PRIMARY KEY ("id" AUTOINCREMENT) — is now read as the column it names. It had been shown on the designer’s Primary Key page under Expression with the column name blank, and the column was not marked as part of the key.

Release Notes:

• The Database page is now five pages: Databases, Connection, Functions, Collations and Modules. Connection carries compile_options, the definitive answer to what the loaded SQLite library was built with; Functions lists every routine the connection answers to by name, including anything a loaded extension registered.
• The table designer names the views and triggers that use a column you are removing, before the change is applied rather than after it has quietly broken them.
• Two new limits under Tools → Options → Grid contents: Max TEXT size to show in grids bounds how much of a long value is drawn, and Max cell height in grids bounds how tall one cell can make a row.
• Options that were check boxes on forms and dialogs are now switches. Grids keep their check boxes.
• A database now opens even when an extension loaded automatically fails to initialise, and the message says which extension and why. The extensions list names the database each one was left out of.
• Compare follows the database selected in the tree when the pair it remembered is no longer open, instead of starting with neither side chosen.
• The Options window’s page list keeps the keyboard, so the pages can be walked with the arrow keys after one is clicked.

 

 

Download SQLite Expert Professional portable

Filespayout – 51.7 MB
RapidGator – 51.7 MB