LiteSQL C++ Object Persistence Framework News

I extracted the data from the old trac wikipages, which was disabled a long time ago on sourceforge, put them into markdown/ doxygen format and produced a new webpage at litesql.org.

I hope you enjoy. B)

Kind regards,
Gulliver

Added source packages for a new release.

Version 0.3.17

• fix for #39 MD5 hash bug, UINT4 is now an uint32_t, which should work also correct on 64bit systems
• updated examples
• applied patch #15 without changes for mysql - added protobuf generator
• removed Blob::nil (patch #13)
• parser error fixed for relation::field::values (values inside relations are not parsed before)
• bugfix for #36 fatal error: exampledatabase.hpp: No such file or directory
• bugfix for #34 Missing constants for values in fields of relations
• applied suggested patch #12 MySQL Connector C /NODEFAULTLIB:LIBCMT

this release adds support for the bigint field datatype

an user from argentina wrote a short tutorial on how to use litesql:
http://www.retronet.com.ar/?p=248

Many thanks to him. :)

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time.

Changes:

• feature: added <include> tag to generator for including other model-files
• feature: added BLOB-support... read more

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time.

Changes:

• introduced CMake-based build system (used for windows build)
• introduced Installer for Windows (installs Documentation,litesql-gen, libraries and includes) ... read more

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time.

Changes:

• numerous small but important bug fixes
• litesql-gen wrote broken RelationHandle::del - method. It deleted all rows.
• Date-, DateTime- and Time-fields were broken.
• litesql-gen did not reset fields' modified flags when assigning record to object
• MySQL 5 does not like names like 'schema' and 'sql'. Internal table is now named to 'schema_' and fields are postfixed with an underscore. This breaks compatibility with databases created with previous versions.
• litesql-gen did not create correct SQL schema for backends with auto incrementing primary key fields (mysql, sqlite3)
• litesql-gen writes ifndef define endif - checks to generated header now
• litesql-gen did not sort objects of relation tags and this resulted to broken relation table names
• litesql-gen writes explicit template parameters for make_pair now (gcc 2.96 requires it)
• all backend transaction routines leaked some memory (fixed by Michel Loiseleur)
• litesql-gen crashed when XML file had undefined objects inside relation tag
• litesql-gen produced broken table names when using longer name than 31 characters
• litesql-gen produced broken SQL (duplicated relation attribute fields in CREATE TABLE - statements)
• litesql-config utility and pkg-config support added (by Eric McDonald)
• RPM packaging headers (by Eric McDonald)
• added .cvsignore - files (by Eric McDonald)
• versioning and packaging improvements (by Eric McDonald)

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time.

Changes:

• namespace - attribute is required now on (used in litesql-gen)
• relation field type names are now consistent with object field type names (they start with uppercase letter)
• bug fix: litesql-gen rejected relations with two or more objects with no relation handles (duplicate handle)
• better tests for backend databases to configure.ac (by Eric McDonald)

More info at http://litesql.sourceforge.net

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time. ... read more

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.

In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API which are type checked at compile time.... read more

LiteSQL (http://litesql.sourceforge.net) is a C++ library that provides an easy interface to sqlite3 database engine, light level of object persistence, object relation support, class-based API for generating queries and iterator-like cursors.