wich and why database

For everything that's not in any way related to PureBasic. General chat etc...
ruudveen
New User
New User
Posts: 1
Joined: Fri May 21, 2004 2:20 pm
Location: the netherlands
Contact:

wich and why database

Post by ruudveen »

My first computer is dated 1980, so I'm computing = using and application-programming, during 24 years. Still I'm confused about the question 'database'.
Starting with the sequential data , we have seen for example:
Dbase/Delphi/Borland Foxpro/Access/Microsoft
DB/Lutus / IBM Oracle
MySQL / PostreSQL Interbase/Firebird
Suneiko etc.
And now - as a new user of Purebasic - discussions about Easybase .dll and Tsunami.
In pure professional way there is a need for huge databases, 50.000 to millions of records.
An individual /hobby user uses no more than a couple of hundred.
The rest all in between.

I got my wife a little bit crazy when I said in 1982, rewriting the interpreter of the Sharp basic (dutch version) , I got a a second off, after a new assembler routine.

As somebody else said : I can make a chaos in minutes, but always my pc does it better and faster.

What I need, is a system as database, with easy use, a maximum of storage, finding all at any time.
Looking at Tsunami, easy use ?

Who is able to burne the light?

Best Regards,
Ruud
Num3
PureBasic Expert
PureBasic Expert
Posts: 2812
Joined: Fri Apr 25, 2003 4:51 pm
Location: Portugal, Lisbon
Contact:

Post by Num3 »

Try SQLite (www.sqlite.org) in runs in both windows and linux and can hold up to 2Gb of data...
Dare2
Moderator
Moderator
Posts: 3321
Joined: Sat Dec 27, 2003 3:55 am
Location: Great Southern Land

Post by Dare2 »

Perhaps the way the app communicates with the db should have most (or considerable) priority. Eg, with SQL you can communicate with many different dbs and the modification, if you change your db, is minimised.

Howdy! :)
Manolo
User
User
Posts: 75
Joined: Fri Apr 25, 2003 7:06 pm
Location: Spain

Post by Manolo »

Hi,
I work with SQLite (Only for betas) and MySQL via ODBC conect for professional work (Version 4.0.18-nt) without limitations.
If you prefer work with another database, don't have problem. ODBC is supported for PB.

Regards,
Manolo
Return to the forum
User avatar
the.weavster
Addict
Addict
Posts: 1581
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Post by the.weavster »

Tsunami seems really good, but there is so little activity in the Tsunami forum I do wonder how long it will be before they pull the plug.

With regard to ODBC, if you consult database forums it is considered to be the least efficient way to connect to databases and should only be used as a last resort.

With PureBasic ODBC is dead easy to use though.

I quite like this http://www.mghsoft.com
It's small, fast and works well with PureBasic. Although I've used it with quite large tables I haven't tried it in a networked multi-user environment so I don't know how well it would cope with that.

It does say in the blurb that it's for flat files only but this is a little confusing and I think has probably cost them quite a bit of business because you can open multiple "flat files" simultaneously and each one gets it's own unique handle by which you can refer to it.
User avatar
blueb
Addict
Addict
Posts: 1118
Joined: Sat Apr 26, 2003 2:15 pm
Location: Cuernavaca, Mexico

Post by blueb »

Weavster.... :)

Tsunami is quite popular and it's free, so I don't think it's going away anytime soon.

Timm (Tsunami's creator) once said he had many thousands of downloads to the regular version. The Pro version is still free, but you have to belong to the User forum to get it. He has said that the regular version is so good that most user's don't feel the need to upgrade to the Pro version. I think he's right, there's not much room for improvement. It's very fast and is only 68k in size.

Don Dickinson has created a client/server version that incorporates Tsunami (not free and based on PowerBasic)

How are your latest efforts going? I'd be really interested in continuing improving the PureBasic files for Pure users as it's as good as anything out there... free or otherwise.

If you'd like email me at: blueb at shaw.ca

--blueb
User avatar
the.weavster
Addict
Addict
Posts: 1581
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Post by the.weavster »

Hi blueb

To be honest since investing in MyDB I haven't done anymore with Tsunami. I quite like having functions that allow me to retrieve and set the value of a field rather than having to disect or concatenate a record.

Having said that I have refined the procedures for Tsunami I previously posted in the forum. As I think I said in a previous posting they were my first attempt at programming so they weren't going to be ideal.

Maybe I will dig the revised versions out and post them here later. As I remember I had created a procedure for nearly every Tsunami function eliminating the necessity of using pointers.

Maybe they're too generous with the free version and should introduce a nag-screen to it. $24 is not a Kings ransome and if they could get more contributions maybe Tsunami would progress faster so we could have nice new features, like field definitions!

Weave
ricardo
Addict
Addict
Posts: 2438
Joined: Fri Apr 25, 2003 7:06 pm
Location: Argentina

Post by ricardo »

Hi Blueb :P

Is there any existent source for Tsunami on PB?
ARGENTINA WORLD CHAMPION
Shannara
Addict
Addict
Posts: 1808
Joined: Thu Oct 30, 2003 11:19 pm
Location: Emerald Cove, Unformed

Post by Shannara »

Looking for that interface improvement as well for Tsunami :) Will probably end up buying the Pro version since I need a client/server environment :)
Post Reply