Tag Archives: sql

Valentina Database 5.4

Valentina is cross-platform SQL and non-SQL columnar database that allows development of client-server [Web] solutions and applications with an embedded local database using the same sources. Valentina DB provides an Object-Relational model, but you can also mix Relational and Extended Navigational. It introduces a revolutionary model abstraction “Link” that greatly simplifies db schema, and therefore simplifies SQL queries. It supports disk and in-memory databases, and field types including Bit, BLOB, Pictures, and Enum. It provides advanced features such as triggers, views, stored procedures, regular expressions, XML, full-text search, and calculated fields. It exists as Valentina Server, Valentina Studio, and a set of Valentina ADKs for all major programming languages.

Release Notes: Data Editor was rewritten to work with huge tables.
Significant performance improvements were achieved with MySQL servers serving many databases. The ability to set LIMIT and OFFSET was added in Query Builder. Queries can now be saved and loaded. Self recursive tables are supported in Query Builder. SSL keys generated with Putty can now be used. The speed of saving and loading dumps with MySQL and PostgreSQL was improved. PostgreSQL privileges can now be edited per User or per Schema.

Release Tags: Major

Tags: API, Libraries, Application Frameworks, SQL, sql editor, non-SQL, object-oriented database

Original news: http://freecode.com/projects/valentina

Firefox, SQLite and Places structure

This article is the first part of a series about firefox, NoSQL, bookmarks, synchronisation and the cloud. The second part can be found here.

Firefox places

Some of my readers know that I prefer Linux environments for my own PCs, but I use a Mac with OS X and a Windows XP virtual machine at work; I need cross compatibility and “places” portability. Starting with version 3.0, Firefox no longer uses the old bookmarks.html file to store passwords or history.dat for your visited pages. It uses an SQLite data base named places.sqlite in your Mozilla profile folder instead. The file “places.sqlite” stores the annotations, bookmarks, favorite icons, input history, keywords, and browsing history (a record of visited pages). Continue reading