cdbc

cdbc

Frode Nordahl (fnordahl) Publisher

Install latest/stable of cdbc

Ubuntu 16.04 or later?

Make sure snap support is enabled in your Desktop store.


Install using the command line

sudo snap install cdbc

Don't have snapd? Get set up for snaps.

Channel Version Published

C library providing simple and easy to use interfaces to the ODBC API

Icon based on "Database free icon" by smashicons from www.flaticon.com and "ready" by Arbcom from https://commons.wikimedia.org

Example code

 #include "cdbc.h"

 int main(int argc, char **argv) {
     CDBC cdbc;
     CDBC_QUERY q;
     CDBC_RESULT res;
     char *row_value;
     int id = 1;

     // initialize CDBC and connect
     cdbc = cdbc_init();
     cdbc_connect(cdbc, "MySQL", "DATABASE=mydb", "127.0.0.1", 3306, "username", "password");

     // prepare SQL query
     q = cdbc_prepare(cdbc, "SELECT * FROM table WHERE id = ?");

     // bind input parameters
     cdbc_bind_param(q, 1, CDBC_C_LONG, id, sizeof(id));

     // execute SQL query
     cdbc_execute(q);

     // get pointer to row in resultset
     row_value = cdbc_c_name(q, "row_name");

     // fetch data
     res = cdbc_fetch(q);
     while (res) {
         printf("%s\n", row_value);
         res = cdbc_fetch(q);
     }

     // clean up
     cdbc_finish(q);
     cdbc_disconnect(cdbc);
     cdbc_cleanup(cdbc);

     return 0;
 }

Have a look at https://github.com/fnordahl/cdbc/blob/master/tests/test.c for more a more complete example with error handling etc.

The functional tests (https://github.com/fnordahl/cdbc/blob/master/.travis.yml) for this repository contain some hints about consuming the library from your snap: https://github.com/fnordahl/cdbc/blob/master/tests/snap/snapcraft.yaml

Developer website

Details for cdbc

License
Apache-2.0
Last updated
5 December 2019

Share this snap

Generate an embeddable card to be shared on external websites.


Related blog posts


Where people are using cdbc

Users by distribution (log)

Ubuntu 20.04
Ubuntu 18.04
Ubuntu 20.10

Install cdbc on your Linux distribution

Choose your Linux distribution to get detailed installation instructions. If yours is not shown, get more details on the installing snapd documentation.


Is there a problem with cdbc? Report this app