SQLite-3.7.6.2-x86_64.pet for Fat Dog

Miscellaneous tools
Post Reply
Message
Author
moB
Posts: 116
Joined: Mon 19 Oct 2009, 11:25
Location: Coastal

SQLite-3.7.6.2-x86_64.pet for Fat Dog

#1 Post by moB »

SQLite for FatDog64 in two pets: application & manual.

Available for testing: http://sites.google.com/site/ieincp/home/puppy5/repo
Version 3.7.6.2 of SQLite is recommended for all new development. Upgrading from version 3.7.5 is optional. Upgrading from all SQLite versions prior to 3.7.5 is recommended.
http://www.sqlite.org/

Pet package files are listed in *.files documents.

Good'ay!

moB

They had made a harpooneer of him, and that barbed iron was in lieu of a sceptre now.
--Melville, Moby Dick
.

Pelo

Database, none of those available satisfy

#2 Post by Pelo »

Will be tried with Puppy : people are still asking or Database, none of those available satisfy. SQLite could fit their needs, perhaps, but some doubt about that.
Nevertheless, i ask my development staff to test it with Puppy.

Situations Where SQLite Works Well


Embedded devices and the internet of things

Because an SQLite database requires no administration, it works well in devices that must operate without expert human support. SQLite is a good fit for use in cellphones, set-top boxes, televisions, game consoles, cameras, watches, Out house appliances, thermostats, automobiles, machine tools, airplanes, remote sensors, drones, medical devices, and robots: the "internet of things".

Client/server database engines are designed to live inside a lovingly-attended datacenter at the core of the network. SQLite works there too, but SQLite also thrives at the edge of the network, fending for itself while providing fast and reliable data services to applications that would otherwise have dodgy connectivity.

Application file format

SQLite is often used as the on-disk file format for desktop applications such as version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs, and so forth. The traditional File/Open operation calls sqlite3_open() to attach to the database file. Updates happen automatically as application content is revised so the File/Save menu option becomes superfluous. The File/Save_As menu option can be implemented using the backup API.

There are many benefits to this approach, including improved application performance, reduced cost and complexity, and improved reliability. See technical notes here and here for details.

Post Reply