BASIC

Author Topic: [Release] tDB - Database for Everyone  (Read 20306 times)

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #15 on: 2008-Jun-21 »
Done Raw-Command solution. Update soon. Please send me more commands, needed for your projects.
MacBook Pro 2,2 GHz Core 2 Duo, 4 GB RAM, 160 GB HDD, 8600M GT
Core i3 - 3,07 GHz, 8 GB Ram, 2.5 TB HDD, Geforce GTX 260+ OC

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #16 on: 2008-Jun-23 »
Sorry for DoublePost:

Update Now!

New Commands:



DBRawCommand(Database,"SQL-String")
DBSearch(Database,"Table","Field for Search","What you want to have - Return","Searchstring")



Have a nice day

// Oops forgotten to Load up the update :/
See First Post

EDIT://

Small Update:

New Commands:

DBGetTimestamp()
DBMakeRealDate$(Timestamp)
DBMakeRealTime$(Timestamp)


its a small Update for Using Timestamps in tDB.

Update in First Post...
« Last Edit: 2008-Jun-24 by trucidare »
MacBook Pro 2,2 GHz Core 2 Duo, 4 GB RAM, 160 GB HDD, 8600M GT
Core i3 - 3,07 GHz, 8 GB Ram, 2.5 TB HDD, Geforce GTX 260+ OC

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #17 on: 2008-Jun-24 »
very nice.. I'll download it and test this new functionalities... Let you know later what I think...


thank you Trucidare...

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #18 on: 2008-Jun-25 »
not all of us works with SQL commands before. i want to make it simply for all.
MacBook Pro 2,2 GHz Core 2 Duo, 4 GB RAM, 160 GB HDD, 8600M GT
Core i3 - 3,07 GHz, 8 GB Ram, 2.5 TB HDD, Geforce GTX 260+ OC

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #19 on: 2008-Jun-30 »
just playing with the new profiler option :)

FunctionCallsTot.with childsExec.onlyAv.Exe[s/call]
DBInit1---
DBCreateNew10.002000.002000.00200
DBAddTable50.033000.033000.00700
DBAddField360.086000.086000.00200
DBReadRecord100---
DBPut2001.674001.674000.00800
DBGet_Str12880.004000.00400-

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #20 on: 2008-Jul-15 »
Hello trucidare.
how this DBReadrecord works ? Can you do  a little more detailed explanation ?
I really don't get why to do it...
and what about the rawcommand one... can I use it for select ? do I need to use the readrecord as well ? I'm sorry,kinda confused with this...

Offline Kitty Hello

  • code monkey
  • Administrator
  • Prof. Inline
  • *******
  • Posts: 10719
  • here on my island the sea says 'hello'
    • View Profile
    • http://www.glbasic.com
Re: [Release] tDB - Database for Everyone
« Reply #21 on: 2008-Jul-15 »
Yes, it would be cool to have a "cleaned up" version of this. With a small tutorial.
And please, please inline "C" code, so we don't need the .dll (and can compile on PocketPC :P )

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #22 on: 2008-Jul-29 »
Hello trucidare, is there any update coming soon ? :D

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #23 on: 2008-Aug-02 »
Yes nearly in future but work on gui before. please write if a critical error or must have then i make a fast update.
MacBook Pro 2,2 GHz Core 2 Duo, 4 GB RAM, 160 GB HDD, 8600M GT
Core i3 - 3,07 GHz, 8 GB Ram, 2.5 TB HDD, Geforce GTX 260+ OC

Offline kanonet

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1142
    • View Profile
    • My GLBasic code archiv
Re: [Release] tDB - Database for Everyone
« Reply #24 on: 2012-Jan-08 »
Note to everyone, that comes to this Thread:
Trucidare has released the sourcecode of the last version of tDB here: http://www.glbasic.com/forum/index.php?topic=7563.msg62556#msg62556
Thank you Trucidare!  :good:



----------


I have no C experience and cant get it to work, can someone plz help me? :nw:
I tried it with an without the GLB-Headerpack, in both cases I get the following error:
Code: GLBasic [Select]
In file included from C:\Users\kanonet\AppData\Local\Temp\glbasic\gpc_temp0.cpp:286:
C:/Users/kanonet/Desktop/tDB/tDB/depends/sqlite3.h:37:67: stdarg.h: No such file or directory
Lenovo Thinkpad T430u: Intel i5-3317U, 8GB DDR3, NVidia GeForce 620M, Micron RealSSD C400 @Win7 x64

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #25 on: 2012-Jan-08 »
you need the header package from kitty somewhere in the download or news section of the main site
MacBook Pro 2,2 GHz Core 2 Duo, 4 GB RAM, 160 GB HDD, 8600M GT
Core i3 - 3,07 GHz, 8 GB Ram, 2.5 TB HDD, Geforce GTX 260+ OC

Offline kanonet

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1142
    • View Profile
    • My GLBasic code archiv
Re: [Release] tDB - Database for Everyone
« Reply #26 on: 2012-Jan-08 »
Yeah like i said i tried it with the headerpackage too, same result.
Lenovo Thinkpad T430u: Intel i5-3317U, 8GB DDR3, NVidia GeForce 620M, Micron RealSSD C400 @Win7 x64

Offline kanonet

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1142
    • View Profile
    • My GLBasic code archiv
Re: [Release] tDB - Database for Everyone
« Reply #27 on: 2012-Jan-10 »
I got it working under Windows:
copying the headers wasnt the only thing necessary, i also needed to copy "libsqlite3dll.a" into "GLBasic\Compiler\platform\Win32\Lib". So no problems under Win anymore.
But it only links dynamical, so i still need the .dll to run it. Is there a way to static link it? If i use "libsqlite3.a" instead of "libsqlite3dll.a" it is static linked, but how can i force this behaviour?

But i cant get it to work with Linux (i guess "sglite3dll.a" is only for Win?), i get this error:
Code: GLBasic [Select]
compile+link:
In file included from /cygdrive/C/Users/kanonet/AppData/Local/Temp/glbasic/gpc_temp0.cpp:296:
/cygdrive/C/Users/kanonet/Desktop/tDB/tDB/depends/sqlite3.h:37:67: stdarg.h: No such file or directory
Can someone help me with this, please?

And finally: the sqlite version used is very outdated, would there be a way to use a newer one? On sqlite.org i cant get a .a file just .c, (how) would it be possible to use this?

Thank you in advance for your help, please keep in mind, that i have no C experience, so please make it clear for me noob.
Lenovo Thinkpad T430u: Intel i5-3317U, 8GB DDR3, NVidia GeForce 620M, Micron RealSSD C400 @Win7 x64

Offline FutureCow

  • HelpEditor
  • Prof. Inline
  • ******
  • Posts: 680
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #28 on: 2012-May-08 »
Just came across this post as I was looking for a database integration. I assume you either sorted it or no longer need the problem fixed as it's been a few months.
The error though is whinging about a missing header file (stdarg.h) - you'd need that in the right place on your server in order to compile the code.

Offline kanonet

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1142
    • View Profile
    • My GLBasic code archiv
Re: [Release] tDB - Database for Everyone
« Reply #29 on: 2012-May-08 »
I havent worked with database since my last post here. But headers werent the problem, it worked under Windows, but not under Linux, like i said before.
Lenovo Thinkpad T430u: Intel i5-3317U, 8GB DDR3, NVidia GeForce 620M, Micron RealSSD C400 @Win7 x64