PureBasic Forums - English

dracflamloc wrote:Access is pretty awful and has its own quirks and limitations. Also requires the ODBC use, which can cause issues if your users have different ODBC driver versions or different OSes that don't have the same MDAC installed.

When making a statement like "Access is pretty awful", you must add "In your own opinion" since that is all it is.

We've had thousands of users with no issues at all, and since PureBasic uses ODBC natively, it makes things quick and simple.

Well, all I can say is that MS has many millions of loyal customers for this technology, including most of the fortune 500, and if it were a buggy and unreliable offering that would in no wise be the case.

>Access is pretty awful and has its own quirks and limitations. Also requires the ODBC use, which can cause issues if your users have different ODBC driver versions or different OSes that don't have the same MDAC installed.

What a nonsense..
Since years the stuff is very good.
I'm using ADO for layer and it's great.
Afaik it's even directly accessible (i believe it's pre-installed on xp, i might be wrong).
Sure if you can't handle the com stuff or you messed with ODBC you'll have a bad time.
Stay away from ODBC, the possible fieldtypes (~90) is enormous.

--------------------------------

But imo for simple databases i would recommend sqlite.

srod wrote:

Dare wrote:Hi srod,

Thanks! I'll see if I can find the post covering that.

Look all you like, but it was an exchange of e-mails!

Re Access: I use it a lot for a variety of things and it is very good. I hear you can stress it on a high-traffic website or with massive amounts of data but I have never encountered either problem.

But it is windows only.


Is MySQL still free?

I am looking with tired eyes and probably missed something but it seemed that they were selling it (or a licence) when I looked earlier.

Dare wrote:Is MySQL still free?

Not if you are going to be charging for your software. Then its around $500 per license.

Its a big myth they still like to propagate. Its free as long as your software is free.

The whole notion of LAMP is a joke too since one of the major components is not free if you are selling your LAMP services.

But hey, its a cool acronym and everyone knows the software industry LOVES acronyms!

Paul wrote:MS Access engine as it comes with Windows. ODBC drivers are already to go and it's lightning fast. No extra baggage needed to package with your application.

Gets my vote every time.

Since it's been some time since I researched database capabilities can you tell me what it's blob capabilities are?

Many thanks.

cheers

Both sqlite as access handle blobs fine.
I mean 100% (thus also chr(0) and so)

Thanks Edwin.

I'm using sqlite somewhat successfully with blobs now but it's been a lot of trial and error and I didn't remember if Access was even a candidate. I might take a look at it.

cheers.

Straker wrote:

Dare wrote:Is MySQL still free?

Not if you are going to be charging for your software. Then its around $500 per license.

Its a big myth they still like to propagate. Its free as long as your software is free.

The whole notion of LAMP is a joke too since one of the major components is not free if you are selling your LAMP services.

But hey, its a cool acronym and everyone knows the software industry LOVES acronyms!

Thanks Straker.

rsts wrote:Thanks Edwin.

I'm using sqlite somewhat successfully with blobs now but it's been a lot of trial and error and I didn't remember if Access was even a candidate. I might take a look at it.

cheers.

Some fokes (like me) use a custom encoding to store binary data, don't it's not necessary.

X'hexdata here' and for MDB 0xBBBB kind of, forgot exactly.