|
|
 |
| 4D Sqlite3 |
|
| Written by Goodsoftware |
 |
|
4DSqlite3 is a Mach-O Plugin for the 4th Dimension Programming Language version 2003 or 2004 MacOSX and Windows XP or Win2000 operating systems. Within a single plugin, the programmer is provided with an API to to create SqLite databases and subsequently insert, update delete and query records using standard SQL commands. SqLite uses file sharing for its datafiles so there is no need for setting up additional server software or hardware.
The 4DSqlite3 API makes it very easy to create SQL statements that embed 4D variables or fields with a simple tag format, without the hassle of creating prepared statements. The use of tags mean that one line of code is all that is neccessary to have a valid SQL statement that inserts or updates Sqlite databases from 4D fields or variables.
Select statements have a variety of ways to extract the result into either arrays, blobs or text or Genro Bags. For example you can select into an array of pointers with each element pointing to a 4D array of the appropriate type based on the column types from the Sqlite database. You can select into a structured blob (known as a bag format) containing the names of the columns together with the data in the appropriate type. The bag functions are for Genro users who are familiar with the Bag format. Or you can select into Text or a blob. Select into Text is for queries you know will return a result less than 32k and do not contain blobs or PICTs. You have the option to change the default delimiters. And you can even select into text having all datatypes converted appropriately.
Many additional utility routines make it easy to get your data in and out of Sqlite. 4DSqlite3 provides a default mapping of 4D Types to Sqlite types that can be modified to suit. In this way you can be sure your data will be converted to the appropriate type between 4D and Sqlite datafiles. The ability to have multiple concurrent database connections from your 4D database gives the developer the ability to provide very powerful database solutions.
All large databases, eg. suburbs and postcodes, phone number lookups, bank bsb, archived data etc., can all be held outside of the main 4D database but is immediately accessible for use within the application. Creating SQL clones of you database provides sql connectivity for powerful reporting. Crystal reports can be used with Sqlite plus a variety of other query and reporting tools. . . providing a choice for your clients reporting preferences. |
|
|
|
|
|
|
| features |
Easy Tag format for embedding 4D fields and variables of any type * into SQL statements.
All 4D Types are supported *except subtables .
Automatic conversion between 4D date to ISO date format between 4D and Sqlite.
Automatic management of Blobs and PICT fields and variables.
Automatic execution and evaluation of embedded 4D functions with the result being automatically correctly formated for Sqlite.
Return results into arrays of appropriately matching types
Return results into structured blobs (bags) that contain all data formatted correctly. (Bag Manager component is included making it a breeze to manage data)
Return into a text with default overridable delimiters
Multiple databases opened simultaneously.
include data from multiple databases in a single query.
In memory databases (temporary databases).
Unlimited field types (Sqlite is mostly typeless)
Dynamic cache size.
Atomic transactions
Triggers
Views
Combined indices
Conflict handling
Tempory tables, views, indices and triggers.
Nested queries.
Normal joins and left outer joins.
Set operations (union, intersect, except)
Built-in functions (string, mathematical, date/time).
Read Sqlite databases with other applications, including the terminal. |
|
|
|
| technical support |
|
|
|
|
|
|
|
| licenses |
Developer license is free with any deployment license. |
|
|
|
|
| pricing |
|
|
|
|
|
