Leandro,
Your idea of using HBNETIO seems interesting but will require more
experienced users to comment about it.
Right now I just use simple DBF/CDX/FTP but I want to convert a simple
system to SQLite to learn a bit about SQL sintax and design.
A serveless SQL database is what I need right now. I need something
simple and easy to start. According to what I could understand using SQLite
instead of DBF will result in a more stable and secure program that means
less data corruption or maybe no corruption. Data loss is inadmissible in
real life applications!
I understand that SQLite is not designed for shared access but maybe for
2-12 concurrent connections it will be good enough and right now I'm not
planning to use it for more than that. Maybe in a future development I could
switch to PostgreSQL for a more powerfull and SECURE application or maybe to
BerkleyDB from Oracle according to the news Alex Strickland shared with us.
Wikipedia's: "Berkeley DB (BDB) is a computer software library that
provides a high-performance embedded database, with bindings in C, C++,
Java, Perl, Python, Ruby, Tcl, Smalltalk, and other programming languages.
BDB stores arbitrary key/data pairs as byte arrays, and supports multiple
data items for a single key. BDB can support thousands of simultaneous
threads of control or concurrent processes manipulating databases as large
as 256 terabytes, on a wide variety of operating systems including most
Unix-like and Windows systems, and real-time operating systems."
http://www.oracle.com/database/docs/berkeley-db-datasheet.pdf
The goal right now is to jump quickly to something better and more
reliable than DBF and I need information and shared experience from others
to do the right choice. Maybe SQLite is not the right option and would not
be worthy of my efforts to learn, maybe I should jump to PostgreSQL (or
other).
SQLite's features http://www.sqlite.org/features.html:
*.. Transactions are atomic, consistent, isolated, and durable (ACID) even
after system crashes and power failures.
*.. Zero-configuration - no setup or administration needed.
*.. Implements most of SQL92. (Features not supported)
*.. A complete database is stored in a single cross-platform disk file.
*.. Supports terabyte-sized databases and gigabyte-sized strings and blobs.
(See limits.html.)
*.. Small code footprint: less than 300KiB fully configured or less than
180KiB with optional features omitted.
*.. Faster than popular client/server database engines for most common
operations.
*.. Simple, easy to use API.
*.. Written in ANSI-C. TCL bindings included. Bindings for dozens of other
languages available separately.
*.. Well-commented source code with 100% branch test coverage.
*.. Available as a single ANSI-C source-code file that you can easily drop
into another project.
*.. Self-contained: no external dependencies.
*.. Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and
WinCE) are supported out of the box. Easy to port to other systems.
*.. Sources are in the public domain. Use for any purpose.
*.. Comes with a standalone command-line interface (CLI) client that can be
used to administer SQLite databases.
Please any advise is welcome.
Qatan
----- Original Message -----
From: "Leandro Damasio - 2D Info" <te...@2dinfo.com.br>
To: "Users of the Harbour compiler" <harbour-users@harbour-project.org>
Sent: Thursday, 6 de May de 2010 20:06
Subject: Re: [Harbour-users] DBF Fast text search / SQLite
Hello Qatan
Seems very interesting. Does anyone know if this SQLite could be used
with Harbour for a serious application (by serious I mean, trustyworth
and with enough resources to do the common commercial application's
transactions and operations).
A fast and realiable serverless SQL engine would be really something to
business applications, but according to SQLite documentation
(http://www.sqlite.org/whentouse.htm) SQLite is not really designed for
shared access because "SQLite uses reader/writer locks on the entire
database file".
I dont really know hbnetio, but maybe SQLite could be shared across LAN
trough an hbnetio server. Can someone (who knows better hbnetio) tell if
this approach is applicable?
Regards
Leandro
_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
Harbour-users@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour-users
_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
Harbour-users@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour-users
