Tag - Database

Entries feed - Comments feed

2010-09-20

Synopse Big Table 1.9.2

Synopse Big Table has been updated into version 1.9.2.
Some new methods, and string key values can be safely bigger than 65535 chars now.

New benchmark available:
36 seconds for creating more than 150,000 records, storing 3 GB of data.
393 ms to create 1,000,000 records, with an associated string key.
Delphi rocks!

Continue reading

2010-08-24

Synopse SQLite3 Framework 1.9.1

The Synopse SQLite3 Database Framework was just released under version 1.9.1:
- internal SQLite3 database engine is updated to version 3.7.2;
- new TSQLRecordFTS3 record, for using FTS3 virtual tables, i.e. implementing full-text search;
- new SQLite3UIEdit unit, to edit table content with a dialog created from RTTI;
- new dedicated BLOB methods and JSON array serialization;
- a lot of fixes and speed enhancements (including our HTTP/1.1 RESTful server now using Thread Pool).

The new 3.7.2 version of the SQLite3 engine, which is mandatory according to SQLite3's authors, is included.

Continue reading

2010-08-04

Synopse SQLite3 Framework Main Demo - draft

The SQLite3 MainDemo source code has just been uploaded to the repository.

This application is just a database tool which stores text content and files into the database, in both clear and "safe" manner. Safe records are stored using AES-256/SHA-256 encryption. There is an Audit Trail table for tracking the changes.

Continue reading

2010-07-02

JSON format of a RESTful application

RESTful JSON is still a buzzing process... there is no standard yet, and they should not be, since JSON itself has its own RFC, and REST is a powerful but vague statement.

Continue reading

2010-06-12

Synopse Big Table v1.8

The Synopse Big Table library has been updated to the 1.8 version.

Some bug fixes, a Thread safe way of working and a some new methods (AddFile, GetPart).

Continue reading

2010-03-22

Synopse Big Table v1.3

The Synopse Big Table has been updated to the 1.3 version.
You can now access to your data with more common Open() then Read() and Seek() methods. Some other enhancements.

Continue reading

2010-03-18

Synopse Big Table v1.2

The Synopse Big Table has been updated to the 1.2 version.
It can now index its data according to an UTF-8 encoded string ID.
Some minor issues fixed, and speed enhancements (like a reading cache).

Continue reading

2010-03-16

Synopse Big Table

An open source Delphi unit for very fast data storage and access.  If you just need to save raw data on disk, and retrieve it with an unique ID number, you can use this unit, which is much faster than any database engine. Work from Delphi 2 to Delphi 2010. Licensed under a MPL/GPL/LGPL tri-license.

Continue reading

page 6 of 6 -