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

Nickname

Password

Lost Password?

Don't have an account yet?
Register now!

Support Amigaworld.net
Your support is needed and is appreciated as Amigaworld.net is primarily dependent upon the support of its users.
Donate

Menu
Main sections
» Home
» Features
» News
» Forums
» Classifieds
» Links
» Downloads
Extras
» OS4 Zone
» IRC Network
» AmigaWorld Radio
» Newsfeed
» Top Members
» Amiga Dealers
Information
» About Us
» FAQs
» Advertise
» Polls
» Terms of Service
» Search

IRC Channel
Server: irc.amigaworld.net
Ports: 1024,5555, 6665-6669
SSL port: 6697
Channel: #Amigaworld
Channel Policy and Guidelines

Who's Online
10 crawler(s) on-line.
 136 guest(s) on-line.
 0 member(s) on-line.



You are an anonymous user.
Register Now!
 Hammer:  26 mins ago
 amigasociety:  41 mins ago
 matthey:  1 hr 21 mins ago
 billt:  2 hrs 24 mins ago
 Rob:  3 hrs 24 mins ago
 amigakit:  3 hrs 35 mins ago
 DiscreetFX:  3 hrs 52 mins ago
 Matt3k:  4 hrs 8 mins ago
 OlafS25:  4 hrs 19 mins ago
 RobertB:  5 hrs 59 mins ago

Software News   Software News : SQLite - A small database engine released on Aminet
   posted by TrebleSix on 2-Feb-2006 9:00:25 (2629 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
orders.
* 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
operations.
* Simple, easy to use API.
* TCL bindings included. Bindings for many other languages available
separately.
* 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
    

STORYID: 2872
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
Hollywood APK Compiler 4.0 released
Printer Friendly Page  Send this Story to a Friend

PosterThread
Jorge 
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!)
µA1-MK2/G3/933/R200/CMI8738
XE/G4 (broken 7450/800)

 Status: Offline
Profile     Report this post  
TrebleSix 
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  
AmigaClyde 
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.


_________________
---------
AmigaClyde

µA1-C 750GX@800 using OS4.1

 Status: Offline
Profile     Report this post  
Anonymous 
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 0:44:17
# ]



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....

Chris

 
     Report this post  
ggw 
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: 1106
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.

G


_________________
..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  
corto 
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: 342
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  
peterray 
Re: SQLite - A small database engine released on Aminet
Posted on 3-Feb-2006 13:13:38
#7 ]
Member
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).

Ciao
Gabriele


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

 Status: Offline
Profile     Report this post  
AmiGame 
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 ?

Jerry


_________________
- 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 Amigaworld.net.
Amigaworld.net was originally founded by David Doyle