Question
dda
I was wondering whether there is a [large enough] interest in having
an sqlite3 solution for RB5. The reason I ask is, I had to mess with
sqlite3 databases – and I still use 5.5.5 for pro development – so I
had to roll my own solution. Further more, I have added some classes
that make using an sqlite3, a traditional RB db or a MySQL db pretty
seamlessly – something like AnyDB [see freshmeat project] but for RB5.
I am working on adding a standalone solution for MySQL and pgSQL. That
is, access to MySQL and pgSQL servers/dbs without the plugins. That's
still in the work so far, but it'll come in soon enough.
Any interest?
Happy New Year!
--
dda
libcurl4RB, [S]FTP transfers made easy
http://sungnyemun.org/?q=node/8
RBDeveloper Columnist, "Beyond the Limits"
http://rbdeveloper.com
Liste Française Solutions RB
http://www.solutionsrb.com/
Keith Hutchison
On 1/1/06, dda <head...@gmail.com> wrote:
> Hi all
>
> I was wondering whether there is a [large enough] interest in having
> an sqlite3 solution for RB5. The reason I ask is, I had to mess with
> sqlite3 databases – and I still use 5.5.5 for pro development – so I
> had to roll my own solution. Further more, I have added some classes
> that make using an sqlite3, a traditional RB db or a MySQL db pretty
> seamlessly – something like AnyDB [see freshmeat project] but for RB5.
> I am working on adding a standalone solution for MySQL and pgSQL. That
> is, access to MySQL and pgSQL servers/dbs without the plugins. That's
> still in the work so far, but it'll come in soon enough.
>
> Any interest?
I've thought of a command line/shell method for win32 RB standard
which should work for also for MacOX. No thoughts on OS9 yet, apart
from tcpip.
Keith
dda
died a peaceful death a few years ago.
I have a semi-working alpha that includes sqlite3 [as a standalone
implementation, in a dylib], RB DB – sqlite2 on RB5 –, MySQL from the
RS plugin, and pgSQL as a standalone implementation [in pure RB]. This
last one is giving me heartburns, but the rest is working very nicely.
As set of classes, which I have temporarily named AnyDB [and
AnyRecordset for the RS], allows access to any of them via a unified
API:
d=New Dictionary
d.Value("type")=adb.kSQLite3
d.Value("path")=":memory:"
d.Value("Create")=True
adb=new anyDB(d)
In-memory sqlite3 dbs are very fast, and beat dictionaries any time
[esp on large sets of data]. And having a unique API for different
database engines helps. So I'm going to work some more on this, and
when I have a beta, I'll notify those who have shown interest here –
or offlist.
--
dda
On 1/2/06, Keith Hutchison <keith.kjtl...@gmail.com> wrote:
> I'm interested.
Vincent Kroll
8)
dda
As I said, I have sqlite3 up and running, which is freaking great. I
just need to make pgSQL work correctly, and we're ready to go beta.
--
dda
On 1/4/06, Vincent Kroll <vkr...@arcor.de> wrote:
>
> fascinatingly ...
> 8)