PureBasic Forums - English

Does SQLite do "stored procedures" like MSSQL and Oracle?

I'll take that as a no

Are there -any- simple databases that do SP's? I can't think of any.

I believe so + triggers.

See for info:
http://www.sqlite.org/faq.html

Just searched over there, no mentioning SP's..

Yeah, I'm there right now. I'm not seeing SP support in SQLite.

You can distrubte MSDE with apps. I'm reading up on that now. Can you tell I've been writting lots of SPs over the years? I really can't do without them.

Thanks for the reply

Sorry, me DB stupid..
I'm busy with SQLite building me a dbms but that's fairly simple.
It's not the practical use side of SQLite using.

I wish I wasn't so used to SPs so I could try it out. SQLite looks like a great app.

MySQL version 5 can do Stored Procedures, however, I have not personally tried it and I do not know how it compares to MSSQL.

If you're interested:
http://dev.mysql.com/doc/mysql/en/store ... dures.html

Wow, MySQL has evolved a lot since I last used it. Which was a few years ago. I wonder if you can redistribute it with an app?

A few people on PowerBASIC forum have managed to use the dll only.
However, i don't trust it, you'll have to test this without ever having the package installed onm that computer.

BTW, sqlite is still poor on multiuse afaik.
Hence the lite..
Maybe best for local single user stuff.

I still believe that Firebird SQL is the best "totally" free DBMS system around (It does stored procedures). You can even get the source code, if you desire.

http://www.firebirdsql.org


--Bob

blueb wrote:I still believe that Firebird SQL is the best "totally" free DBMS system around (It does stored procedures). You can even get the source code, if you desire.

http://www.firebirdsql.org

--Bob

I agree, I just recently completed a Delphi system using the embedded version of Firebird and it all went swimmingly. Now if only we had a wrapper for Embedded Firebird *hint hint*

Colin

blueb wrote:I still believe that Firebird SQL is the best "totally" free DBMS system around (It does stored procedures). You can even get the source code, if you desire.

http://www.firebirdsql.org


--Bob

Thank you Bob!!!!

FBSQL looks veeeeeerry interesting. I'm reading up now...

@Colboy

How many FBSQL files will I have to pack in with my application installer? Is it easy to redist?

Omnius wrote:@Colboy

How many FBSQL files will I have to pack in with my application installer? Is it easy to redist?

1 DLL (fbclient.dll) and 2 supporting files firebird.conf and firebird.msg and of course the database itself. Redistribution is simple, files just need to be copied. For Delphi I'm using the ZEOS wrapper. You need to make sure you download the embedded version of Firebird, which I think is currently 1.5.2, no version 2.0 alpha yet available.

Colin