Database support ?

BackupUser · Post by **BackupUser** » Mon Sep 30, 2002 10:49 am

Restored from previous forum. Originally posted by wcardoso.

:)I'm thinking to change my actual developer tools to PureBasic, but I need to know how is the database support of this tool.
Thank you from Uruguay

BackupUser · Post by **BackupUser** » Mon Sep 30, 2002 3:11 pm

Restored from previous forum. Originally posted by fweil.

Hello Uruguay and wcardoso ...

Welcome to this forum.

Maybe you can first try to make your opinion using the search function of this forum.

Key-in 'database' word just and you will have some posts about it.

Then come back with more accurate questions.

What I, and others can say about databases is that it is easy to design application program using ODBC connections on Windows installations.

Purebasic allows to put SQL stuff easy in programs.

As you can built SQL requests dynamically in your Purebasic programs, it has no limit and gives good performances (just limited to the database server you use !).

Welcome again and enjoy Purebasic.

Francois Weil
14, rue Douer
F64100 Bayonne

BackupUser · Post by **BackupUser** » Tue Oct 01, 2002 10:58 am

Restored from previous forum. Originally posted by wcardoso.

Hello fweil!
Thanks for reply, but my question is about the native support for database; something like commands to create database without the need to use any external database manager. I know PB can connect with standard ODBC systems like ACCESS or ORACLE, but my needs are more modest.
Thanks anyway

BackupUser · Post by **BackupUser** » Tue Oct 01, 2002 5:12 pm

Restored from previous forum. Originally posted by fweil.

I hope I do not mistake (Fred ?) but I don't believe it is possible to 'Create' a database strictly speaking ... you will just connect to an existing engine on which it will be possible to update using SQL.

If you mean to design an engine itself, it will not be something easy / possible right now. Basically a database engine is something tricky if you want to have a large set of features.

...

Francois Weil
14, rue Douer
F64100 Bayonne

BackupUser · Post by **BackupUser** » Tue Oct 01, 2002 6:13 pm

Restored from previous forum. Originally posted by fred.

Some languages have very small buildin database, but PB doesn't have. I think there are enough free and easy to use DB manager here (MySQL, PostGres etc..). And of course, very very powerful.

Fred - AlphaSND

BackupUser · Post by **BackupUser** » Wed Oct 02, 2002 6:41 am

Restored from previous forum. Originally posted by fweil.

Fred,

I think you are right, the SQL support should be enough to make Purebasic programs communicating with any db engine available on the market.

Writing an internal engine would be maze to reach a low level of what MySQL or Oracle do.

For accessing Access database, all the needed stuff lies with the API quite easily I think.

Don't know about others experience !?

Francois Weil
14, rue Douer
F64100 Bayonne

BackupUser · Post by **BackupUser** » Wed Oct 02, 2002 8:35 am

Restored from previous forum. Originally posted by fred.

For accessing ACCESS, there is an ODBC interface, so no problem with native commands (I use it).

Fred - AlphaSND