[Release] tDB - Database for Everyone

Previous topic - Next topic

trucidare

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

trucidare

#16
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...
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

acristo

very nice.. I'll download it and test this new functionalities... Let you know later what I think...


thank you Trucidare...

trucidare

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

acristo

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-

acristo

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...

Kitty Hello

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 )

acristo

Hello trucidare, is there any update coming soon ? :D

trucidare

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

kanonet

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

trucidare

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

kanonet

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

kanonet

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

FutureCow

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.

kanonet

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