ANN: kbmSQLiteMan v. 1.1 - New free and simple SQLIte manager product has been released!
ANN: kbmSQLiteMan v. 1.1 - New free and simple SQLIte manager product has been released!
We are happy to provide an update to the new cool, free product to our friends of Components4Developers.
Its a simple to use SQLite database manager application, which includes support for SQLite 3.7.
It supports:
- Syntax highlighting
- Improved blob interpretation/preview
- Structure view with SQL generation
- Save/load scripts
- Save dataset results to CSV, XML and JSON file
- In line editing and resolving for non complex SELECTs
- SQLite v. 3.7+
- Pragma view with help reference.
Whats new:
- Most recently opened databases in File menu
- Right click popup menus on structure view (tables, fields)
- New Pragma panel with all SQLite supported Pragmas, and popup menu for copying pragma to code editor, and quick help.
- Various fixes
To access the free download, register and login on our portal at
https://portal.components4developers.com. The download will be readily available in your "Approved licenses" section.
best regards
Kim Madsen
Components4Developers
www.components4developers.com
We are happy to provide an update to the new cool, free product to our friends of Components4Developers.
Its a simple to use SQLite database manager application, which includes support for SQLite 3.7.
It supports:
- Syntax highlighting
- Improved blob interpretation/preview
- Structure view with SQL generation
- Save/load scripts
- Save dataset results to CSV, XML and JSON file
- In line editing and resolving for non complex SELECTs
- SQLite v. 3.7+
- Pragma view with help reference.
Whats new:
- Most recently opened databases in File menu
- Right click popup menus on structure view (tables, fields)
- New Pragma panel with all SQLite supported Pragmas, and popup menu for copying pragma to code editor, and quick help.
- Various fixes
To access the free download, register and login on our portal at
https://portal.components4developers.com. The download will be readily available in your "Approved licenses" section.
best regards
Kim Madsen
Components4Developers
www.components4developers.com
Hi Kim, does SQLite support multiple SQL statements in one execute? I need to do a lot of inserts all at once.
ReplyDeleteHi, SQLite certainly supports it. kbmSQLiteMan also does. Type the statements in the query editor. You can choose between two syntaxes for that, the SQLite way with ; at end of each statement, or the kbmMW way starting each non select statement with an exclamation mark !.
ReplyDeleteThe kbmMW way also supports starting a statement with an equal sign. That statement will then be used as the result in the grid. Eg.
!DELETE FROM xx
!INSERT INTO xx VALUES...
!INSERT INTO xx VALUES :::
=SELECT * FROM xx...
It will result in the grid showing the two newly inserted records. All statements run like this will be run within one single SQLite transaction.
best regards
Kim Madsen