PureBasic Forums - English

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

Try SQLite (www.sqlite.org) in runs in both windows and linux and can hold up to 2Gb of data...

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!

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

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.

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

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

Hi Blueb

Is there any existent source for Tsunami on PB?

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