Click Here
home features news forums classifieds faqs links search
5970 members 
Amiga Q&A /  Free for All /  Emulation /  Gaming / (Latest Posts)



Lost Password?

Don't have an account yet?
Register now!

Your support is needed and is appreciated as is primarily dependent upon the support of its users.

Main sections
OS4 Zone
IRC Network
AmigaWorld Radio
Top Members
Amiga Dealers
About Us
Terms of Service

IRC Channel
Ports: 1024,5555, 6665-6669
SSL port: 6697
Channel: #Amigaworld
Channel Policy and Guidelines

Who's Online
44 crawler(s) on-line.
 9 guest(s) on-line.
 1 member(s) on-line.


You are an anonymous user.
Register Now!
 Hypex:  2 mins ago
 DiscreetFX:  8 mins ago
 JKD:  49 mins ago
 amisteph:  1 hr 47 mins ago
 Spectre660:  2 hrs 9 mins ago
 IRTheBorg:  2 hrs 14 mins ago
 tygre:  2 hrs 17 mins ago
 freak:  2 hrs 18 mins ago
 Bradsco:  2 hrs 34 mins ago
 billt:  2 hrs 55 mins ago

Software News   Software News : SQLite - A small database engine released on Aminet
   posted by TrebleSix on 2-Feb-2006 9:00:25 (1950 reads)
Just noticed this on Aminet, and looks quite interesting..........

SQLite is a small C library that implements a self-contained, embeddable,
zero-configuration SQL database engine. Features include:

* 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 disk file.
* Database files can be freely shared between machines with different byte
* Supports databases up to 2 terabytes (241 bytes) in size.
* Sizes of strings and BLOBs limited only by available memory.
* Small code footprint: less than 250KiB fully configured or less than
150KiB with optional features omitted.
* Faster than popular client/server database engines for most common
* Simple, easy to use API.
* TCL bindings included. Bindings for many other languages available
* Well-commented source code with over 95% test coverage.
* Self-contained: no external dependencies.
* Sources are in the public domain. Use for any purpose.

The SQLite distribution comes with a standalone command-line access program
(sqlite) that can be used to administer an SQLite database and which serves
as an example of how to use the SQLite library.

Click Here For Link

Related Links
· More about Software News
· News by TrebleSix

Most read story about Software News
UBoot 2010.06.04 for Sam460ex available

Last news about Software News
Goadf! 3.0 has been released
Printer Friendly Page  Send this Story to a Friend

Re: SQLite - A small database engine released on Aminet
Posted on 2-Feb-2006 19:30:56
#1 ]
Cult Member
Joined: 20-Oct-2003
Posts: 657
From: Scottsdale, AZ

That's interessting. Even the TCL bindings. Does an actual tcl exist for AmigaOS (8.x orsomething, without ixemul) ?

I had an old 2.x version, but that is pretty old and slower than the latest version. But it's rather useable for embedding in your own applications (but who can write tcl apps anyway).

AmigaOne XE G3/933/VIA/FM801/R200 (fixed),
G3SE/600/Voodoo3/Sil680/RTL8139/SBLive! (noiseless!)
XE/G4 (broken 7450/800)

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 2-Feb-2006 22:30:49
#2 ]
Elite Member
Joined: 6-Sep-2004
Posts: 3747
From: Pembrokeshire, Wales

I have yet to play wih it, but it looks cool.

Dark Lord Design Wicked Solutions For Damned Problems

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 2-Feb-2006 23:54:59
#3 ]
Elite Member
Joined: 8-Mar-2003
Posts: 2007
From: Noranda Canada

Thanks. I'll try it out.


A1-C 750GX@800 using OS4.1

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 0:44:17
#4 ]
Super Member
Joined: 2-Oct-2003
Posts: 1703
From: Cardiff

I know Apple use this in "Core Data", which was a new system-wide API added in OS X 10.4 for data-driven user-interface gadgets and whatnot. It struck me as odd they didn't use MySQL or PostgreSQL, but it must be pretty robust....


AROS - verb (Welsh) - To wait, to await, to stay, to abide.
- Clebin Games - -

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 4:09:35
#5 ]
Super Member
Joined: 24-May-2003
Posts: 1088
From: Austin, TX

I compiled it here on my AmigaOne about 6 months ago. It was announced on OS4Depot. It definitely works. Finally SQL commands on my very own Amiga.

The size of sqllite compared to the biggies is tiny, tiny. There is all kinds of stuff it does not do, but it DOES to sql 92.


..effects of civilization upon...nature, the growing gap between what education was supposed to accomplish and what it consisted of, the national debt and...high taxes, the problem of the excess cost of medical care -- Philip Wylie, 1951

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 10:49:56
#6 ]
Regular Member
Joined: 24-Apr-2004
Posts: 335
From: Grenoble (France)

Sure, SQLite is tiny and powerful with a good SQL compliance.

I tried to compile it myself and it only works on MorphOS. I think this is due to the ixemul support and POSIX stuff about file locking.

I tried the last version available on Aminet or OS4depot but it fails on usual commands. I would be interested in comments from people who tried the Aminet version ... with more actions than ".help" and ".exit"

If people is interested, you have to know I've just written my fourth article for aMiGa=PoWeR, our french paper. This is a tutorial that starts with a presentation of SQLite and then leads to a MUI based tool for requesting. Have a look at it here !

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 13:13:38
#7 ]
Joined: 2-Sep-2004
Posts: 91
From: Verona (Italy)

I'm using SQLite embedded in the Apache porting for AOS4. I wrote some PHP pages to easily manage the database of my scout group. Another task brought to my AmigaOne (I don't boot Linux since over 6 months).


In a world without walls and fences
we won't need windows and gates

 Status: Offline
Profile     Report this post  
Re: SQLite - A small database engine released on Aminet
Posted on 9-Feb-2006 11:05:32
#8 ]
Elite Member
Joined: 23-Mar-2004
Posts: 3599
From: Peterborough, UK, Planet Earth (I think...)

Kewl !

Is there a native AOS4 port ?


- AOS has been ported to ex-86 ! It's called AROS and WinUAE... Or E-UAE on Linux !

- A1XE-G4 up and runing with:
512MB Ram / 200GB and 80GB HardDisks on Sii0680.
AOS4 Final Update / AmiZilla 0.1 Alpha

 Status: Offline
Profile     Report this post  
[ home ][ about us ][ privacy ] [ forums ][ classifieds ] [ links ][ news archive ] [ link to us ][ user account ]
Copyright (C) 2000 - 2019 was originally founded by David Doyle