What is a Database Sample?
It’s a taste of the real thing. These are fully contained, downloadable database functionality samples of our Raima Database Manager (RDM) , and each download highlights a certain feature within RDM. Click on the Database Samples links to view the complete series for each API. Duration = 5 minutes or less.
Note: Windows samples require Visual Studio 2008 or 2010 and Linux samples require a standard Linux development environment.
- Download the sample.
- Build it – it’s all set up.
- Run it in your debugger & watch.
- “Oh, That’s easy!”
- Try the next one
RDM SQL API For C/C++
|Windows||Linux 32-bit||Linux 64-bit||Description|
|Hello World||Hello World||Hello World||Hello World. Create & initialize database if not present. Create one record, read and print all records.|
|SQL02||SQL02||SQL02||Primary/Foreign-key reference. Two table types, second referencing the first.|
|SQL03||SQL03||SQL03||Hierarchy. Same as SQL02 but with three tables.|
|SQL04||SQL04||SQL04||Indexing. Create 10 rows with random values in indexed column. Select all in order and print.|
|SQL05||SQL05||SQL05||Many-to-many. Three tables, two foreign key references constructing a many-to-many relationship. Populate with a few rows. Select and print from one side, then from the other.|
|SQL06||SQL06||SQL06||Multiple databases. Create, initialize and populate two databases. Open one, then the other. Demonstrate usage of both at once.|
|SQL07||SQL07||SQL07||SQL Parameters. Show how RDMSQL uses parameters, contrasted to ADO.NET, ODBC and JDBC.|
|SQL08||SQL08||SQL08||Transaction. Insert rows in a transaction. Commit then select and print them.|
|SQL09||SQL09||SQL09||Transaction abort. Insert and commit some rows. Insert more rows, but abort the transaction. Select all rows and see only the first set of rows.|
|SQL10||SQL10||SQL10||Shared mode. No longer exclusive (“x”) mode. Create two connections. First connection populates database and holds transaction. Second connection attempts to read but times out.|
|SQL11||SQL11||SQL11||Multi-user. Create a new database. Spawn multiple writer threads that insert rows in transactions. Spawn multiple reader threads that use read locks.|
|SQL12||SQL12||SQL12||TFServer. Spawn TFServer. Then create same threads as SQL11, but configured for RPC to the separate process.|
|SQL13||SQL13||SQL13||Multi-process. Same as SQL12 except that processes are spawned, not threads.|
|SQL14||SQL14||SQL14||Read-only-transactions. Same as SQL13 except that the reader processes use MVCC (Multi-Version-Concurrency-Control) ROTs rather than locks.|