Ok I searched and still have SQLite question

Omnius · Post by **Omnius** » Wed Jul 20, 2005 11:50 pm

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

Omnius · Post by **Omnius** » Thu Jul 21, 2005 6:42 pm

I'll take that as a no

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

Edwin Knoppert · Post by **Edwin Knoppert** » Thu Jul 21, 2005 7:39 pm

I believe so + triggers.

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

Edwin Knoppert · Post by **Edwin Knoppert** » Thu Jul 21, 2005 7:42 pm

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

Omnius · Post by **Omnius** » Thu Jul 21, 2005 7:44 pm

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

Edwin Knoppert · Post by **Edwin Knoppert** » Thu Jul 21, 2005 10:39 pm

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.

Omnius · Post by **Omnius** » Thu Jul 21, 2005 10:49 pm

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

Beach · Post by **Beach** » Thu Jul 21, 2005 11:42 pm

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

Omnius · Post by **Omnius** » Fri Jul 22, 2005 12:25 am

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?

Edwin Knoppert · Post by **Edwin Knoppert** » Fri Jul 22, 2005 8:59 am

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.

blueb · Post by **blueb** » Fri Jul 22, 2005 3:16 pm

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

ColBoy · Post by **ColBoy** » Fri Jul 22, 2005 3:23 pm

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

Omnius · Post by **Omnius** » Fri Jul 22, 2005 5:25 pm

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...

Omnius · Post by **Omnius** » Fri Jul 22, 2005 5:35 pm

@Colboy

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

ColBoy · Post by **ColBoy** » Fri Jul 22, 2005 6:10 pm

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

PureBasic Forums - English

Ok I searched and still have SQLite question

Ok I searched and still have SQLite question

Oooo K...

Me too

It looks good

Redistribute

Redistributing

Re: Redistributing