A busy few weeks: a new Sourcery release, the update of the ODBC suite and SQLTool, and a brand-new application, APITest.
Sourcery 1.20
- 32-bit, modern toolchain: the whole application has been switched to 32-bit and rebuilt with the latest Acorn C compiler.
- Export lists: a new Export... option on the icon bar menu lets you export a set of projects to directories or zip files via a JSON list. The Export list window has a Template... button that writes out a list of every project, and dropping a list on the window opens an Export projects window where you can tick, correct and export projects — including a Build button that queues the ticked projects and their libraries onto the build list.
- Library diagrams: a project window can now save a Mermaid graph of the project and the libraries it includes, following libraries that are themselves Sourcery projects.
- Stability: assorted memory leaks and invalid memory accesses have been fixed.
ODBC suite
The whole ODBC stack is now updatd: the !ODBC driver manager, !ODBCMan datasource manager, and the supporting ODBCLib library and ODBC Module.New versions of drivers for MySQL, PostgreSQL, MS SQL and SQLite are also provided.
SQLTool 0.90
My SQL query tool for interrogating databases over ODBC is finally out, and it's come a long way since the old 0.65:- Browse datasources, tables, views, procedures and columns; drag tables and columns into the query editor.
- SQL formatting: Format lays out a query — keywords upper-cased, BEGIN...END/CASE...END indented — sharing the formatting rules with Grimoire.
- Generated SQL: menu actions generate INSERT, UPDATE, DELETE and CREATE TABLE statements for highlighted tables/columns.
- ER diagrams: a Diagram option produces a Mermaid entity-relationship diagram of selected tables.
- Export: result sets save as Text, CSV or TSV.
- A proper SQL editor underneath it all: syntax lexing, completion, undo, clipboard support.
