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

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Hi Folks,

i made a Library for easy Database Access in GLB. Based on SQLite3.
Please PN me for a Registration-Number. Its for free - i want only see how many people use this Lib.
The Demo Version ( DBInit(0) ) can open only 5 Databases.

trucidare

New Commands since Initial-Release:


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


[attachment deleted by admin]
« 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 Kitty Hello

  • code monkey
  • Administrator
  • Prof. Inline
  • *******
  • Posts: 10697
  • here on my island the sea says 'hello'
    • View Profile
    • http://www.glbasic.com
Re: [Release] tDB - Database for Everyone
« Reply #1 on: 2008-Jun-02 »
Very helpful, thanks a lot.

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #2 on: 2008-Jun-02 »
 :nw: I owe you one !!! YAHOO !!!!

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #3 on: 2008-Jun-12 »
Sent you a msg some days ago... can you send me the reg number ? Thank you. 

btw one question...max. of 15 tables, for the registered version ? is that right ?

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #4 on: 2008-Jun-12 »
no 15 Databases similar open. YOu can put (integert) value of Tables in one Database.
I send you the code yesterday. Now have fun :)
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 Kitty Hello

  • code monkey
  • Administrator
  • Prof. Inline
  • *******
  • Posts: 10697
  • here on my island the sea says 'hello'
    • View Profile
    • http://www.glbasic.com
Re: [Release] tDB - Database for Everyone
« Reply #5 on: 2008-Jun-19 »
Is there a way of getting a (any) database cross-platform?

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #6 on: 2008-Jun-19 »
is in the work

.so / .dylib and the sdlbasic sqlite3 portation for gp2x. Any other platforms -  i dont know how
Is simple to make the lib. Only compile with cross bin tools and everything works great. Problem now is
the tDB is compiled with GLB.
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 Kitty Hello

  • code monkey
  • Administrator
  • Prof. Inline
  • *******
  • Posts: 10697
  • here on my island the sea says 'hello'
    • View Profile
    • http://www.glbasic.com
Re: [Release] tDB - Database for Everyone
« Reply #7 on: 2008-Jun-19 »
Hm... Why not just linking to libsqlite.o for any platform?

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #8 on: 2008-Jun-19 »
Give me a little how to, i never linked o files before
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 #9 on: 2008-Jun-19 »
Please don't forget to let us know about any new update on this..
I would like to leave a feedback, because this works so great... it improve my loading time in 500% as my previous version used .ini files for loading data into the program... Thank you Trucidare.

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #10 on: 2008-Jun-19 »
i work on a network solution and some improvements like raw commands.
please give a feedback on existing functions. what to make better...
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 #11 on: 2008-Jun-19 »
well, we can talk further about it... my expertise is databases anyway (IBM DB2)... thas why my programming skills sucks !! :D
only thing I have missed so far was to send sql commands, but that is what I think you meant by raw commands.

would you be able to write something using odbc ? because with it we could access any database even Oracle or DB2 (they have free version as well)


network solution ?what do you mean ?

Offline trucidare

  • Administrator
  • Prof. Inline
  • *******
  • Posts: 1377
  • Bachelor of Fail
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #12 on: 2008-Jun-19 »
i havent read about a cross plaform odbc driver. so i make it with dll´s mysql lib will come after tDB works fine.

Network solution is a simple server that stores data from client in tDB and send it to clients. for games using webservers for datastorage.
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 #13 on: 2008-Jun-19 »
you can use ODBC (Open database connectivity) to access any database if you had installed its odbc drivers on the machine.

Offline acristo

  • Mr. Drawsprite
  • **
  • Posts: 51
    • View Profile
Re: [Release] tDB - Database for Everyone
« Reply #14 on: 2008-Jun-19 »
loved the news about the network solution.