Our SynDBExplorer free tool has been enhanced. A SQL request history has been added to the software. It is now able to handle directly Jet / MSAccess .mdb files. It has also several fixes included (including Oracle direct link), and the internal SQLite3 engine has been updated to its latest […]
Search
Your search for syndbexplorer returned 5 results.
2012-01-17
SynDBExplorer fast direct export
2012-01-17. Open Source › Open Source libraries
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.
And the new exporting features are opening new possibilities.
2011-11-23
Does speed matters?
2011-11-23. Pascal Programming
Luigi Sandon wrote on Embarcadero's forum:
And then you ask yourself: "why use a native compiler if its code may be even slower than jitted one?". Hope the new developers will also develop better and faster code - and not viceversa.
Embarcadero is just following the Wirth's law slower than others:
"Software is getting slower more rapidly than hardware becomes faster"
Speed is only a matter of compiler for mathematical computing intensive
tasks.
Most of the time, in real apps (like business apps), the main speed issue is
more the framework size (and the number of dll invoked), memory consumption,
and general design (e.g. how caching and SQL are written).
Delphi, Java or .Net can do slow apps.
Delphi, Java or .Net can do fast apps.
You can do small and fast stand-alone apps with Delphi, running from Windows
2000 to Windows 8.
It is not possible with Java nor .Net.
This is the main difference IMHO with native code and JIT - about memory use, ease of distribution and no need of an external runtime framework.
2011-09-25
Synopse SQLite3/mORMot framework 1.15
2011-09-25. Open Source › mORMot Framework
Our Client-Server ORM framework is now available in revision 1.15.
This is a major upgrade of the framework:
- It is now called mORMot -
so please update your T-Shirts or coffee cups
- It is able to use any Database engine back-end - in fact, it is SQLite3 powered, not SQLite3 limited;
- In particular, direct OleDB and native Oracle have been implemented;
- It makes use of the genuine SQlite3 Virtual Table mechanism everywhere to allow mixed access to any database engine;
- New
TModTime / TCreateTimekind of fields; - Enhanced stability, speed and multi-thread implementation;
- Methods and functions have been enhanced, according to user feedback (thanks you all for your interest and forum posts!);
- Extended documentation (more than 700 pdf pages), with new diagrams and a lot of new content;
- New associated tools, like LogViewer or SynDBExplorer;
- The SQLite3 core can now be used without our ORM - it has been updated to the latest 3.7.8 version;
- Open Source (under GPL/LGPL/MPL license), running from Delphi 6 up to XE2.
2011-07-22
SynDBSQLite3: SQLite3 direct access
2011-07-22. Open Source › Open Source libraries
For our ORM framework, we implemented an efficient SQLite3 wrapper, joining statically (i.e. without any external dll) the SQLite3 engine to the executable. SQLite3 is in fact used as the DB kernel of the framework. For instance, thanks to its unique virtual table mechanism, even tables in other databases (like Oracle or MSSQL) are available as if they were SQLite3 tables.
We just made this wrapper independent from our ORM, in a new dedicated unit,
named
SynSQLite3.pas.
It was an easy task to let this unit be called from our SynDB database abstract classes.
