SQLLite 3 Blob Data

[DJFuego]

was this function added? can you import bin data like pictures etc.. Will I have to convert to base 64 to add the bin data as text?

[Dines]

Maybe it'd be possible for some expressions to be added:

Get File As Blob("SQLLITE3", "c:\blah\doggy.bmp")

Get Bank as Blob("SQLLITE3", "Name of Bank made in Binary Object")


Then in your queries, you could just do something like

"INSERT INTO table(data) values(" + get file as blob("SQLLITE 3", "c:\file.bmp") + ")"

[byo]

This would be very cool.
I never used blobs so I'm not sure how to implement this correctly but I'll try my best. I'm involved in a project right now and college and work takes my available time but I'll do my research and maybe I can add that ASAP.

[DJFuego]

That would be awesome as I'm trying to make a Document management system. Incorporating image data into the database would save a lot of time but I don't know about the speed and or how big the database will be able to get before breaking.

anyone maxed out an SQL Lite DB yet? Broken one?

[Dines]

They should have stress-test stats on the website, you can have a look maybe.

[byo]

http://www.sqlite.org/whentouse.html
This page should answer all questions related to limitations and features, when to use it, comparisons, etc.

[DJFuego]

2 terrabytes Nice!

[byo]

Yes, it is.

But you need to be careful to use SQLite professionally when the data volume is really large (many gigabytes) as this DB engine is made of file buffer access and read/write operations may need a super computer with lots of RAM. In that case, I'd recommend other professional database engines like SQL Server, MySQL and Oracle which have a running server application to deal with the data, log files, etc.

You can already have those database engines in MMF2 by using the ODBC object. Some people complain about ODBC bottlenecks but recent studies published averywhere on the internet show that ODBC drivers are stable and lightweight.