AminetAminet
Search:
83629 packages online
About
Recent
Browse
Search
Upload
Setup
Services

dev/c/sqlitequery.lha

Mirror:Random
Showing:m68k-amigaosppc-amigaosppc-morphosi386-arosi386-amithlonppc-warpupppc-powerupgeneric
No screenshot available
Short:Example for using the sqlite3 library
Author:Mathias 'Corto' Parnaudeau (amigadev free fr)
Uploader:Mathias 'Corto' Parnaudeau (amigadev free fr)
Type:dev/c
Version:0.10
Requires:libsqlite3.a
Architecture:ppc-amigaos; ppc-morphos
Date:2008-10-23
Download:http://aminet.net/dev/c/sqlitequery.lha - View contents
Readme:http://aminet.net/dev/c/sqlitequery.readme
Downloads:1730

This example is provided with sources and executables for MorphOS and OS4.
Comments will help to understand how to manage the sqlite3 library, a static
one provided in archive sqlite-3.6.1-amiga.lha that I used for testing.

It is as simple as possible but keeping an interest : you can write queries to
the
database and display results in a list.

To try it, a small database is provided, it contains a kind of bug tracker data,
with tables projects and tickets.

A button allows to execute the query written above and another one lists
the database tables. At the bottom, an area will display errors.

Let me know if you have interest. Else you can improve yourself !


Contents of dev/c/sqlitequery.lha
 PERMSSN    UID  GID    PACKED    SIZE  RATIO METHOD CRC     STAMP          NAME
---------- ----------- ------- ------- ------ ---------- ------------ -------------
[generic]                  509    3072  16.6% -lh5- 7d30 Oct 22 22:30 sqlitequery/bugs.db
[generic]                 4051   11768  34.4% -lh5- bcd7 Oct 22 22:30 sqlitequery/sqlitequery.c
[generic]               270574  603520  44.8% -lh5- 5278 Oct 22 22:30 sqlitequery/sqlitequery.mos
[generic]               318772  677756  47.0% -lh5- ef4c Oct 22 22:30 sqlitequery/sqlitequery.os4
[generic]                  518     960  54.0% -lh5- cfac Oct 22 22:30 sqlitequery/sqlitequery.readme
---------- ----------- ------- ------- ------ ---------- ------------ -------------
 Total         5 files  594424 1297076  45.8%            Oct 23 07:03

Aminet © 1992-2021 Urban Müller and the Aminet team. Aminet contact address: <aminetaminet net>