Working demo SQLite with C++ on Mac OSX Xcode

Working demo SQLite with C++ on Mac OSX Xcode

This was developed for Mac OSX which seems the preferred database.

Problems with the alternatives databases:

Open source Maria DB does not work at all which appears to be a mess

MYSQL is unstable and incomplete thanks to Oracle butchering it

Postgres development libraries seem complex for Xcode or just does not link up for some reason

SQLite seems to be the only one that work. For my new version 2 system, this should be fine for very simplistics needs as long as I don’t need it for Clustering on multiple systems

Instructions here:

Install SQLite3 with: brew install sqlite3

This could already be installed by default in your  Mac OSX

You could use this to Download SQLiteBrowser from http://sqlitebrowser.org/

I installed using http://macappstore.org/sqlitebrowser/

brew cask install sqlitebrowser

I installed Valentina Studio through Apple OS X App store which is free

Could make a sample C++ client for SQLite



#include <stdio.h>

#include <sqlite3.h>

int main(int argc, char* argv[])


    sqlite3 *db;

    char *zErrMsg = 0;

    int rc;


    rc = sqlite3_open(“test.db”, &db);


    if( rc ){

        fprintf(stderr, “Can’t open database: %s\n”, sqlite3_errmsg(db));

        return -1;


        fprintf(stderr, “Opened database successfully\n”);




Join my FREE newsletter to see how SQLite should fit my simplistic needs for automated trading

My working demo with SQLite

Helpful tutorial video



NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
share this recipe:

Still hungry? Here’s more

Are you interested in:


FREE 2 Hour Video! 


As you know with the crazy restrictive emergency laws being introduced in the last week, many moving their savings out of FIAT banks into cryptocurrency trading.

Here are some questions to get your started:

  • Create your own ‘bank’ anonymously with crypto
  • In the future, draw off your crypto saving with a Visa debit card
  • Trade using a European de-central exchange to trade perpetual contracts and other high performing coins
(All your info is kept private nor released!  Don’t forget to check to click your promo or spam inbox after the confirmation email is sent) 

Create your own  PRIVATE Bank