LazSqlX is a light database manager for MsSql, Oracle, MySql, Sqlite and Firebird.
- Can run sql queries against specified databases.
- It supports autocomplete features for tablenames,fieldnames (based on tablenames and/or aliases of tables).
- Can preview and/or modify data (when right-click a table and |Open TableData|)
- Can export data returned from a query or from OpenTableData to xml,sqlinsert script,csv,rtf,json.
- Can export/copy rows by random selection (using CTRL and mouse) as tab delimited data,tab delimited data with headers, sql insert script
- Can create,edit,drop tables,fields on tables, indexes and constraints
- It has a built-in query designer (drag&drop), can create virtual relations and for selected table generates query based on relations created (or relations already has from db).
- Can generate basic queries and/or stored procedures for Select, SelectItem, Insert, Update and Delete; for supported databases.
- Can preview MEMO/Blob fields on Dbl-Click, if Blob field is of known pic format, it will display the picture with ability to save it. If table opened from OpenTableData table popup menu, then it can also Load/Save BLOB fields and Text for MemoFields (use dblClick on the field to open a dialog window for more)
It's in experimental phase, still much work to do for a stable version, but still can do it's job most of the time :)
Project Members: