Dolphin - Database ODBC support
flebber
I am new to Smalltalk and Dolphin. I am beginning a personal project a
database application, I have looking for a language and environment I
can be productive in long term and have full power in creating the
database and access to query database, stored procedures from that
language. I have been studying python/sqlachmeny, ruby/datamapper etc
and various other combinations but haven't felt comfortable.
The Dolphin environment looks instantly comfortable and watching the
video and walkthroughs its defintiely impressive. However I am loking
for some clarity on database support with Dolphin Smalltalk. I can see
that in the goodies there is an ODBC driver. http://www.smalltalking.net/Goodies/Dolphin/
Is there a database that Dolphin supports well. I am looking to use a
low cost options since I am an individual. Had thought of using
Postgresql or Oracle or MySQL.
A solid database package would be possible with dolphin wouldn't it?
Is there a best ODBC driver to use? A database with best
interoperability?
Thanks
Sayth
Bruno Buzzi Brasesco
You can check ReStore http://www.solutionsoft.co.uk/restore/.
ReStore to me is very good.
Regards,
Bruno
Udo Schneider
> I am new to Smalltalk and Dolphin. I am beginning a personal project a
> database application, I have looking for a language and environment I
> can be productive in long term and have full power in creating the
> database and access to query database, stored procedures from that
> language. I have been studying python/sqlachmeny, ruby/datamapper etc
> and various other combinations but haven't felt comfortable.
First of all welcome to Dolphin Smalltalk!
> The Dolphin environment looks instantly comfortable and watching the
> video and walkthroughs its defintiely impressive. However I am loking
> for some clarity on database support with Dolphin Smalltalk. I can see
> that in the goodies there is an ODBC driver. http://www.smalltalking.net/Goodies/Dolphin/
Dolphin includes /built-in/ support for ODBC
(http://www.object-arts.com/docs/databaseconnectivity.htm) and ADO.
So if you are happy with raw (full power?) SQL you can start directly.
Most of the Dolphin SQL Goodies are either helpers or full blown ORMs.
Some I'm aware of (not complete!!)
http://www.smalltalking.net/Goodies/Dolphin/
http://www.nls.net/mp/jarvis/Bob/DolphinGoodies.htm (Rio)
http://www.solutionsoft.co.uk/restore/index.htm (ReStore)
http://glorp.org/ (OLD Port!)
http://mrubi.users.dolphinmap.net/sqlite/sqlite.html (SQLite based)
And if you don't need SQL you can always use OmniBase :-) .... no ORM
hassels then.
> Is there a database that Dolphin supports well. I am looking to use a
> low cost options since I am an individual. Had thought of using
> Postgresql or Oracle or MySQL.
I would not use the term Oracle and "low cost" in one sentence ...
unless you refer to Oralce XE :-)
> A solid database package would be possible with dolphin wouldn't it?
> Is there a best ODBC driver to use? A database with best
> interoperability?
It's not so much a question of Smalltalk/DB interoperability ... it's
more the interoperability of the the DB and the provided ODBC driver.
Hope this helps.
CU,
Udo
Andy Bower
> You can check ReStore http://www.solutionsoft.co.uk/restore/.
>
> ReStore to me is very good.
ReStore is a good product. However, you need to know that it requires
full control over the SQL schema - in fact it builds it. If you already
have a schema and wish to interface Dolphin to it then ReStore won't be
suitable.
Best regards
Andy Bower
Bruno Buzzi Brasesco
Andy is right. ReStore was designed to build a database schema from
the scratch.
If you alreadty have a database schema you can use Dolphin DB
Connection to work with it.
Regards,
Bruno
flebber
since dolphin has full ODBC support then that may be the better way
for me to progress. I found informtion on omnibase (http://
wiki.gorisek.com/WikiDoc/WikiPage) as this appears interesting,
however as I need to query a lot of static time based data(sports
data) potentially a relational database may be more suitable (Likely
Postgresql).
Bob Jarvis
> Hi everyone
>
> I am new to Smalltalk and Dolphin. I am beginning a personal project a
> database application, I have looking for a language and environment I
> can be productive in long term and have full power in creating the
> database and access to query database, stored procedures from that
> language. I have been studying python/sqlachmeny, ruby/datamapper etc
> and various other combinations but haven't felt comfortable.
>
> The Dolphin environment looks instantly comfortable and watching the
> video and walkthroughs its defintiely impressive. However I am loking
> for some clarity on database support with Dolphin Smalltalk. I can see
>
> Is there a database that Dolphin supports well. I am looking to use a
> low cost options since I am an individual. Had thought of using
> Postgresql or Oracle or MySQL.
>
> A solid database package would be possible with dolphin wouldn't it?
> Is there a best ODBC driver to use? A database with best
> interoperability?
>
> Thanks
>
> Sayth
I don't know that the database you use really matters as long as you
can get to it. In my Goodies package there's a package (Rio - short
for Relational Interface Objects (OK, I admit it - I came up with the
name to match the acronym :-)) that allows Dolphin to interface with
any database for which an ODBC driver is available, which should be
true for most databases. Drivers are definitely available for
Postgresql and Oracle, and I suspect there's a MySQL driver out there
as well.
Bob