Page 1 of 1
[Implemented] Add SQLite as a standard PB library
Posted: Thu Jul 01, 2004 4:04 pm
by USCode
Add SQLite as a standard PB library.
A local SQL DB library for PB that can be linked directly into the executable would be very handy!
With SQLite's very liberal license and source code availability, this could be done.
Discussion on making SQLite a PB library:
viewtopic.php?t=11499&highlight=
Posted: Sun Jul 18, 2004 6:31 am
by kake26
I totally agree. I'm writting my own binding and I will make it avail once I'm done and yes I'm doing it in nothing but PB. USCode, if you want a copy when I'm done lemme know I'll send source. I have at least 2 other people wanting a copy too so I figure why not pass it out.
Posted: Sun Jul 18, 2004 4:08 pm
by Shannara
I am interested in a copy as well
Re: Add SQLite as a standard PB library
Posted: Sun Jul 18, 2004 5:16 pm
by NoahPhense
What, no PBDB?!
geesh..
- np
Posted: Sun Jul 18, 2004 7:20 pm
by kake26
Well, SQLite is cool and there are ODBC drivers for it, but that defeats the purpose. I can write to a DB as of now, but I cannot retrieve results. These damn pointers to pointers are a problem for me I must resolve.
Posted: Sun Jul 18, 2004 7:23 pm
by kake26
@NoahPhense: (EL kicks ass) , yes that he does. He's helped me with the SQLite once already I may need to ask him again a few things. Once its done I'll use tailbite and make a PureLib from it and distribute that and its source.
..
Posted: Sun Jul 18, 2004 7:31 pm
by NoahPhense
I'm surprised he's not in here as he's already developing a library:
viewtopic.php?t=10724
- np
Posted: Sun Jul 18, 2004 7:37 pm
by kake26
I know he does it all in ASM which not many people understand. I want to make it in normal purebasic so people have a clue of what I'm doing with the SQLite DLL file.
Posted: Sun Jul 18, 2004 7:45 pm
by El_Choni
Hi, I was away for a few days. I can help you if you want. However, I can't develop nor test anything these days because I'm at my brother's computer.
Regards,
..
Posted: Sun Jul 18, 2004 7:47 pm
by NoahPhense
kake26 wrote:I know he does it all in ASM which not many people understand. I want to make it in normal purebasic so people have a clue of what I'm doing with the SQLite DLL file.
Ah.. but in the end, it's still standard PB lib with standard PB commands right?
Code: Select all
Person.s = "Smith, John"
SQLiteExec("INSERT INTO StatusTable VALUES('" + Person + "','OUT','')")
I'm not trying to discourage you. By all means, this would be an excellent
learning process.
Shoot, that's all I do in here is learn.. maybe I should get back to my todo
list..
- np
Posted: Sun Jul 18, 2004 8:39 pm
by kake26
@El_Choni: Yeah, I'm very close to this except the query result stuff since it returns a pointer to a pointer. I'm not sure how to deal with those. I can make thew calls and stuff just fine. I could I not peel the first one then get the addr for the second one and peek that?