The Lack of a Small Unified Database

Why a single-file SQL standard format is necessary and how SQLite can get us there.
What Can End Users Do?

First of all, go here and vote for an SQLite driver in OO.o. Also, vote to add support for OO.o forms in Kexi. Even if you don't use any of them yourself, you might receive or send an SQLite database some day, so the more widespread the standard is, the better. Above all, start using SQLite today. Remember, it also works on Windows and Mac. And databases, because they are self-contained, can be moved in a snap from machine to machine. Of course, report any bugs you find so as to help speed up development.

Acknowledgments

Many thanks to Frank Schönheit, OO.o DBA developer, and to all the KOffice and SQLite developers who explained to me all the pieces needed to complete this puzzle.

Marco Fioretti is a hardware systems engineer interested in free software both as an EDA platform and, as the current leader of the RULE Project, as an efficient desktop. Marco lives with his family in Rome, Italy.

______________________

Articles about Digital Rights and more at http://stop.zona-m.net CV, talks and bio at http://mfioretti.com

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

I think it should be mentione

Antoine's picture

I think it should be mentioned (a long time after the release of this article) that koffice is now standardising on the same format as OO. I presume that this will mean they will naturally move to the same native database format. So the standardisation is happening. Maybe this article helped?
Cheers
Antoine

Re: The Lack of a Small Unified Database

Anonymous's picture

You forgot to mention that there's already a native OO.o 1.1.x
SQLite driver available (alpha-version, only tested on Linux).

More information here.

Re: The Lack of a Small Unified Database

Anonymous's picture

I submitted this article some time ago. As far as I remember (should check
my notes at home to be sure), that page had not been mentioned back then by any
of the developers I spoke with, but I might be wrong.
Thanks for pointing it out, of course it helps to reach the unified database
goal

Marco F.

unified database

eric drake's picture

In the DOS world I used to use a simple integrated package called Alpha Works. It had spreadsheet, database, word processor, communications, shell access all in one piece of software. The database format was dBase III+. When I moved to Windows, I began using Microsoft Works. The database service (or should I call it the "table" service) provided filtering, sorting, some formulas that were similar to what was available in the spreadsheet, table reporting and a form view. I have been using it for years and it has become my favorite application. The spreadsheet is more than adequate (most users aren't plotting space craft trajectories or performing complex matrix algebra). Excel has more than most users need and so does Word. Oddly enough, Works was free with the computer but I have yet to find anybody around me who uses it. They all went out and bought Excel and Word and the fact is they do far less on their systems than me. I am a sales rep handling multiple companies and multiple customers who buy some lines but not others. The database files aren't large 2 - 3000 records. The MSWorks program works totally in memory so sorting and filters are instantaneous. I can cut and paste records easily into the spreadsheet and into my Windows version of Open Office which I used to set up the order forms that my companies require (each requires a different order form). I use Open Office for this because the Works spreadsheet doesn't allow the embedding of graphics my orders often require graphic representations of what I need. I export the forms to pdf and email them to the various companies. So what is Linux missing ? (I'm writing this on my Linux system now) Something like Microsoft Works. A full integrated set of applications that isn't overloaded with features most people never use, allows easy cutting and pasting as well as database field embedding in form letters, has a small footprint, runs in memory and can export and import all the basic file formats (as Microsoft Works can). Then I would ditch Windows for good. Not that everything would be great with Linux. There's still the problem of driver support especially wireless USB and printers. My laptop's Linksys USB 1.0 802.11.b wireless network device is not recognised and my workhorse cheap Konica Minolta laser printer has no drivers for Linux. I know there is a ton of software available for Linux but the average user doesn't need a ton. A Swiss army knife with a couple of good blades, a scissors and a screwdriver covers alot of needs. Keep the corkscrew and the toothpick.

Webinar
One Click, Universal Protection: Implementing Centralized Security Policies on Linux Systems

As Linux continues to play an ever increasing role in corporate data centers and institutions, ensuring the integrity and protection of these systems must be a priority. With 60% of the world's websites and an increasing share of organization's mission-critical workloads running on Linux, failing to stop malware and other advanced threats on Linux can increasingly impact an organization's reputation and bottom line.

Learn More

Sponsored by Bit9

Webinar
Linux Backup and Recovery Webinar

Most companies incorporate backup procedures for critical data, which can be restored quickly if a loss occurs. However, fewer companies are prepared for catastrophic system failures, in which they lose all data, the entire operating system, applications, settings, patches and more, reducing their system(s) to “bare metal.” After all, before data can be restored to a system, there must be a system to restore it to.

In this one hour webinar, learn how to enhance your existing backup strategies for better disaster recovery preparedness using Storix System Backup Administrator (SBAdmin), a highly flexible bare-metal recovery solution for UNIX and Linux systems.

Learn More

Sponsored by Storix