#1 2012-01-17 20:23:36

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,548
Website

SynDBExplorer fast direct export

The Open Source SynDBExplorer tool has been enhanced these days.

Main new features are:
- Execution of the current selected text (if any) instead of the whole memo content;
- "Exec & Export" new button, for direct export to file.

I really like the selection execution feature - this speed up SQL process a lot, and allow to switch from one statement to another.
And the new exporting features are opening new possibilities.

In particular, the "Exec & Export" new button is able to export any SQL statement result into:
- Regular CSV file (ready to be imported in Excel);
- Regular TXT file (columns are separated with a tab character);
- Standard JSON content (ready for any AJAX application);
- Our more compact JSON format (column names are not duplicated on each row);
- Synopse BigTable records (with fixed sized records for integers columns);
- Synopse BigTable records (with variable-length records for integers columns);
- A SQLite3 database file (creating a table with all necessary columns).

This direct export feature won't use a temporary memory buffer, just with the regular "Export" button, which exports the grid on screen.

Therefore, it will be faster, and will be able to handle any amount of data. You can export gigabytes of data directly from the tool, then consume it offline as regular SQLite3 tables or very efficient Synopse BigTable records. With a map & reduce architecture, it can be very handy to process huge amount of data. Or it can be used to convert an existing database layout into a SQLite3 database.

Thanks to these enhancements, this little tool begins to be a very nice SQL and database management tool.

All this is made possible due to the unique architecture of our SynDB classes. Their design appears to be powerful and open, at the same time: it allows easy mix of data structure, far away from the RAD layout.

See http://synopse.info/fossil/fdiff?v1=63e … d26119b35a for the main source code modification.

A visual Query Designer is also in alpha stage (select several tables, then right click on your mouse), and will become a powerful entry point for the database reverse engineering of our mORMot framework (i.e. the upcoming TSQLRecordMapped* classes). Up to now, you can JOIN visualy your tables with this right-click approach. But it will shortly become a powerful way of managing any RDBMS as objects.

Offline

#2 2012-01-18 18:56:47

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,548
Website

Re: SynDBExplorer fast direct export

I've uploaded an updated compiled version of SynDBExplorer.

It can be downloaded from http://synopse.info/files/SynDBExplorer.zip

See http://blog.synopse.info/post/2011/07/2 … ect-access about some general information concerning this tool.
And http://blog.synopse.info/post/2012/01/1 … ect-export about the new features.

Offline

#3 2012-05-22 15:09:12

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,548
Website

Re: SynDBExplorer fast direct export

SynDBExplorer now features multi tables direct export into SQLite3 DB files.
There is a new button below the tables list: select one or more table, then click on this button.
It will create a SQLite3 DB file (and optionally compress it), from the selected tables content.
Very handy for debugging and support investigation from a client database.

See http://synopse.info/forum/viewtopic.php?id=726

Offline

Board footer

Powered by FluxBB