First off a Disclaimer: I'm a noob and still learning. Please
don't bash me like some forums.

Now to the questions: I'm searching for a quick and easy way to
integrate SQLite3 in my application. I came across the
etc.c.sqlite3 and the DSQLite
library(https://github.com/bioinfornatics/DSQLite).

Thinking that the C bindings is more documented I tried learning
that. Though I can't understand the arguements of the callback
function.

extern(C) int callback(
void* NotUsedAtAll, // Null variable
int argc, // What?
char** results, // Results?
char** columnNames //Column Names?

){

for(int i = 0; i<argc; i++){
     writeln(results);
     getchar();
}

I've been reading through many explanations about this and I
understand why the callback is needed but I can't seem to
understand how to really use the callback function. Can someone
provide a brief explanation or just point me in the right
direction?

On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:

> void* NotUsedAtAll, // Null variable
> int argc, // What?
> char** results, // Results?
> char** columnNames //Column Names?

You can read about this agruments on
http://www.sqlite.org/c3ref/exec.html

On 05/07/2014 08:21 AM, Jack via Digitalmars-d-learn wrote:
> First off a Disclaimer: I'm a noob and still learning. Please don't bash me like some forums.
>
> Now to the questions: I'm searching for a quick and easy way to integrate SQLite3 in my application. I came across the etc.c.sqlite3 and the DSQLite library(https://github.com/bioinfornatics/DSQLite).
>
> Thinking that the C bindings is more documented I tried learning that. Though I can't understand the arguements of the callback function.
>
> extern(C) int callback(
> void* NotUsedAtAll, // Null variable
> int argc, // What?
> char** results, // Results?
> char** columnNames //Column Names?
>
> ){
>
> for(int i = 0; i<argc; i++){
>      writeln(results);
>      getchar();
> }
>
> I've been reading through many explanations about this and I understand why the callback is needed but I can't seem to understand how to really use the callback function. Can someone provide a brief explanation or just point me in the right direction?
maybe http://forum.dlang.org/thread/mailman.44.1397577433.2763.digitalmars-d-announce@puremagic.com this is something for you

On Wednesday, 7 May 2014 at 08:52:04 UTC, Robert Schadek via
Digitalmars-d-learn wrote:
> On 05/07/2014 08:21 AM, Jack via Digitalmars-d-learn wrote:
>> First off a Disclaimer: I'm a noob and still learning. Please
>> don't bash me like some forums.
>>
>> Now to the questions: I'm searching for a quick and easy way to
>> integrate SQLite3 in my application. I came across the
>> etc.c.sqlite3 and the DSQLite
>> library(https://github.com/bioinfornatics/DSQLite).
>>
>> Thinking that the C bindings is more documented I tried learning
>> that. Though I can't understand the arguements of the callback
>> function.
>>
>> extern(C) int callback(
>> void* NotUsedAtAll, // Null variable
>> int argc, // What?
>> char** results, // Results?
>> char** columnNames //Column Names?
>>
>> ){
>>
>> for(int i = 0; i<argc; i++){
>>      writeln(results);
>>      getchar();
>> }
>>
>> I've been reading through many explanations about this and I
>> understand why the callback is needed but I can't seem to
>> understand how to really use the callback function. Can someone
>> provide a brief explanation or just point me in the right
>> direction?
> maybe
> http://forum.dlang.org/thread/mailman.44.1397577433.2763.digitalmars-d-announce@puremagic.com
> this is something for you

Is it bad when I only understand a small portion of the code?
Jokes aside, I guess this proves I'm getting ahead of myself.
Thanks for the article.

On Wednesday, 7 May 2014 at 07:19:32 UTC, Oleg wrote:
> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>
>> void* NotUsedAtAll, // Null variable
>> int argc, // What?
>> char** results, // Results?
>> char** columnNames //Column Names?
>
> You can read about this agruments on
> http://www.sqlite.org/c3ref/exec.html

Thank you for the link. I think I got it covered for now.

On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
> First off a Disclaimer: I'm a noob and still learning. Please
> don't bash me like some forums.
>
> Now to the questions: I'm searching for a quick and easy way to
> integrate SQLite3 in my application.

maybe:
https://github.com/buggins/ddbc/wiki ?

On Wednesday, 7 May 2014 at 19:03:34 UTC, Arjan wrote:
> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>> First off a Disclaimer: I'm a noob and still learning. Please
>> don't bash me like some forums.
>>
>> Now to the questions: I'm searching for a quick and easy way to
>> integrate SQLite3 in my application.
>
> maybe:
> https://github.com/buggins/ddbc/wiki ?

This is what I'm talking about. Thank you very much...

On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
> First off a Disclaimer: I'm a noob and still learning. Please
> don't bash me like some forums.
>
> Now to the questions: I'm searching for a quick and easy way to
> integrate SQLite3 in my application. I came across the
> etc.c.sqlite3 and the DSQLite
> library(https://github.com/bioinfornatics/DSQLite).
>
> Thinking that the C bindings is more documented I tried learning
> that. Though I can't understand the arguements of the callback
> function.
>
> extern(C) int callback(
> void* NotUsedAtAll, // Null variable
> int argc, // What?
> char** results, // Results?
> char** columnNames //Column Names?
>
> ){
>
> for(int i = 0; i<argc; i++){
>      writeln(results);
>      getchar();
> }
>
> I've been reading through many explanations about this and I
> understand why the callback is needed but I can't seem to
> understand how to really use the callback function. Can someone
> provide a brief explanation or just point me in the right
> direction?

May as well throw an undocumented library at you: https://github.com/JesseKPhillips/SQLite3-D

I only used it to pull data out of SQLite database. Once you have your db object it is something like this.

    foreach(data; db.query(statement).range!Structure)...

Where you define a struct with Nullable!() types your statement pulls out.

On Wednesday, 7 May 2014 at 19:03:34 UTC, Arjan wrote:
> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>> First off a Disclaimer: I'm a noob and still learning. Please
>> don't bash me like some forums.
>>
>> Now to the questions: I'm searching for a quick and easy way to
>> integrate SQLite3 in my application.
>
> maybe:
> https://github.com/buggins/ddbc/wiki ?

I seem to have a problem with that library. Even if the modules have been imported and the libraries linked and yada yada, it spews error upon error. Sample code is this:

import std.stdio;
import ddbc.drivers.sqliteddbc;

void main(){

SQLITEDriver driver = new SQLITEDriver();
writeln("SUCCESS");
}


Error spewed out is this:
hello.d|7|Error: undefined identifier SQLITEDriver|

I think Code::Blocks is importing the modules but not detecting the modules. Been at it for a few hours now. Any help?


On Thursday, 8 May 2014 at 05:57:39 UTC, Jesse Phillips wrote:
> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>> First off a Disclaimer: I'm a noob and still learning. Please
>> don't bash me like some forums.
>>
>> Now to the questions: I'm searching for a quick and easy way to
>> integrate SQLite3 in my application. I came across the
>> etc.c.sqlite3 and the DSQLite
>> library(https://github.com/bioinfornatics/DSQLite).
>>
>> Thinking that the C bindings is more documented I tried learning
>> that. Though I can't understand the arguements of the callback
>> function.
>>
>> extern(C) int callback(
>> void* NotUsedAtAll, // Null variable
>> int argc, // What?
>> char** results, // Results?
>> char** columnNames //Column Names?
>>
>> ){
>>
>> for(int i = 0; i<argc; i++){
>>     writeln(results);
>>     getchar();
>> }
>>
>> I've been reading through many explanations about this and I
>> understand why the callback is needed but I can't seem to
>> understand how to really use the callback function. Can someone
>> provide a brief explanation or just point me in the right
>> direction?
>
> May as well throw an undocumented library at you: https://github.com/JesseKPhillips/SQLite3-D
>
> I only used it to pull data out of SQLite database. Once you have your db object it is something like this.
>
>     foreach(data; db.query(statement).range!Structure)...
>
> Where you define a struct with Nullable!() types your statement pulls out.

Sounds easy enough, I'll take a look at it. Thank you ...

On Thursday, 8 May 2014 at 10:29:16 UTC, Jack wrote:
> On Wednesday, 7 May 2014 at 19:03:34 UTC, Arjan wrote:
>> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>>> First off a Disclaimer: I'm a noob and still learning. Please
>>> don't bash me like some forums.
>>>
>>> Now to the questions: I'm searching for a quick and easy way to
>>> integrate SQLite3 in my application.
>>
>> maybe:
>> https://github.com/buggins/ddbc/wiki ?
>
> I seem to have a problem with that library. Even if the modules have been imported and the libraries linked and yada yada, it spews error upon error. Sample code is this:
>
> import std.stdio;
> import ddbc.drivers.sqliteddbc;
>
> void main(){
>
> SQLITEDriver driver = new SQLITEDriver();
> writeln("SUCCESS");
> }
>
>
> Error spewed out is this:
> hello.d|7|Error: undefined identifier SQLITEDriver|
>
> I think Code::Blocks is importing the modules but not detecting the modules. Been at it for a few hours now. Any help?

Did you specify the configuration to use to dub?
dub -c SQLite

On Thursday, 8 May 2014 at 11:07:06 UTC, Arjan wrote:
> On Thursday, 8 May 2014 at 10:29:16 UTC, Jack wrote:
>> On Wednesday, 7 May 2014 at 19:03:34 UTC, Arjan wrote:
>>> On Wednesday, 7 May 2014 at 06:21:10 UTC, Jack wrote:
>>>> First off a Disclaimer: I'm a noob and still learning. Please
>>>> don't bash me like some forums.
>>>>
>>>> Now to the questions: I'm searching for a quick and easy way to
>>>> integrate SQLite3 in my application.
>>>
>>> maybe:
>>> https://github.com/buggins/ddbc/wiki ?
>>
>> I seem to have a problem with that library. Even if the modules have been imported and the libraries linked and yada yada, it spews error upon error. Sample code is this:
>>
>> import std.stdio;
>> import ddbc.drivers.sqliteddbc;
>>
>> void main(){
>>
>> SQLITEDriver driver = new SQLITEDriver();
>> writeln("SUCCESS");
>> }
>>
>>
>> Error spewed out is this:
>> hello.d|7|Error: undefined identifier SQLITEDriver|
>>
>> I think Code::Blocks is importing the modules but not detecting the modules. Been at it for a few hours now. Any help?
>
> Did you specify the configuration to use to dub?
> dub -c SQLite

Yes. I've also linked the library to it.
Dub:
http://puu.sh/8DYrR.png
Code::Blocks Configuration:
http://puu.sh/8DYug.png