MySQL framework for Pharo to analyze futures and options.
Hi folks! I'm using MySQL to hold some data on commodities prices for futures valuation and want to - of course - use Smalltalk as a front-end. Which framework would you recommend? This is a good opportunity for me to push Pharo in the company I work for. I want to leverage after that on Roassal and other visualization tools. But the data is already in a SQL database. Thanks in advance Nacho ----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/MySQL-framework-for-Pharo-to-analyze-futures-and-optio... Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
On Fri, Mar 27, 2015 at 02:21:01PM -0700, nacho wrote:
I'm using MySQL to hold some data on commodities prices for futures valuation and want to - of course - use Smalltalk as a front-end. Which framework would you recommend?
There is a pure Smalltalk MySQL driver on Squeaksource. Not sure whether it has been moved to SS3 or STH. http://www.squeaksource.com/StdbMysqlProtocol Others have suggested Glorp. Glancing at the code, seems Glorp currently only works with VisualWorks' MySQL driver. Based on my experience integrating NBSQLite3 into Glorp, I'd say it will take about a day or two, depending on the design of the driver. I've tested abovementioned MySQL driver with some version of MySQL5 some months ago. Pierce
On 29 Mar 2015, at 04:47, Pierce Ng <pierce@samadhiweb.com> wrote:
On Fri, Mar 27, 2015 at 02:21:01PM -0700, nacho wrote:
I'm using MySQL to hold some data on commodities prices for futures valuation and want to - of course - use Smalltalk as a front-end. Which framework would you recommend?
There is a pure Smalltalk MySQL driver on Squeaksource. Not sure whether it has been moved to SS3 or STH.
http://www.squeaksource.com/StdbMysqlProtocol
Others have suggested Glorp. Glancing at the code, seems Glorp currently only works with VisualWorks' MySQL driver. Based on my experience integrating NBSQLite3 into Glorp, I'd say it will take about a day or two, depending on the design of the driver. I've tested abovementioned MySQL driver with some version of MySQL5 some months ago.
It would be very good to have another Glorp solution with a pure Smalltalk implemented DB driver, like the PostgresV2 one. IMHO this is way less error prone than the whole library/driver/.. mess on all these different platform. Sven
On Sun, Mar 29, 2015 at 6:07 AM, Sven Van Caekenberghe <sven@stfx.eu> wrote:
On 29 Mar 2015, at 04:47, Pierce Ng <pierce@samadhiweb.com> wrote:
On Fri, Mar 27, 2015 at 02:21:01PM -0700, nacho wrote:
I'm using MySQL to hold some data on commodities prices for futures valuation and want to - of course - use Smalltalk as a front-end. Which framework would you recommend?
There is a pure Smalltalk MySQL driver on Squeaksource. Not sure whether it has been moved to SS3 or STH.
http://www.squeaksource.com/StdbMysqlProtocol
Others have suggested Glorp. Glancing at the code, seems Glorp currently only works with VisualWorks' MySQL driver. Based on my experience integrating NBSQLite3 into Glorp, I'd say it will take about a day or two, depending on the design of the driver. I've tested abovementioned MySQL driver with some version of MySQL5 some months ago.
It would be very good to have another Glorp solution with a pure Smalltalk implemented DB driver, like the PostgresV2 one. IMHO this is way less error prone than the whole library/driver/.. mess on all these different platform.
Since our Glorp refactor back years ago...adding a Glorp adaptor (DatabaseDriver subclasses) should be very very easy. So yes, it would be nice to do it for the MySQL driver...but I thought we already had that... -- Mariano http://marianopeck.wordpress.com
Hi! @Cameron: Yes the data is in a MySQL database. I could do a dump and save it as CVS or plain text, should be no problem but I think I prefer to keep it as a SQL database as the new data gets updated automatically. @Mariano: I installed Glorp and as you say, the driver is there, altough in the class comments it says that is not complete yet. I would take a look these days to see if it works properly. Thanks for your support!! Cheers Nacho ----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/MySQL-framework-for-Pharo-to-analyze-futures-and-optio... Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
On 29/03/2015 15:58, Mariano Martinez Peck wrote:
On Sun, Mar 29, 2015 at 6:07 AM, Sven Van Caekenberghe <sven@stfx.eu <mailto:sven@stfx.eu>> wrote:
> On 29 Mar 2015, at 04:47, Pierce Ng <pierce@samadhiweb.com <mailto:pierce@samadhiweb.com>> wrote: > > On Fri, Mar 27, 2015 at 02:21:01PM -0700, nacho wrote: >> I'm using MySQL to hold some data on commodities prices for futures >> valuation and want to - of course - use Smalltalk as a front-end. Which >> framework would you recommend? > > There is a pure Smalltalk MySQL driver on Squeaksource. Not sure whether > it has been moved to SS3 or STH. > > http://www.squeaksource.com/StdbMysqlProtocol
Here it is: http://smalltalkhub.com/#!/~DBXTalk/MysqlDriver
> > Others have suggested Glorp. Glancing at the code, seems Glorp currently only > works with VisualWorks' MySQL driver. Based on my experience integrating > NBSQLite3 into Glorp, I'd say it will take about a day or two, depending on the > design of the driver. I've tested abovementioned MySQL driver with some version > of MySQL5 some months ago.
It would be very good to have another Glorp solution with a pure Smalltalk implemented DB driver, like the PostgresV2 one. IMHO this is way less error prone than the whole library/driver/.. mess on all these different platform.
Since our Glorp refactor back years ago...adding a Glorp adaptor (DatabaseDriver subclasses) should be very very easy. So yes, it would be nice to do it for the MySQL driver...but I thought we already had that...
Me and some other students made an adaptator for the MySQL Driver written in smalltalk based on the one for PostgresV2, you can find it here: http://smalltalkhub.com/#!/~ThomasHeniart/GlorpDriverMySQL There is a method NativeMySQLDriver>>beGlorpDefaultDriver to use it as native driver for glorp. We posted it on the mailing list one and a half month ago ^^
-- Mariano http://marianopeck.wordpress.com
Hi, Thanks for all the input. I've managed to download Glorp and the MySQL Glorp driver. However I'm having serious difficulties in setting it to work. I've search for some documentation in the Glorp page but seems there's a problem with Google Drive. Is there any place to search / look at an example on how to actually connect, map and query a SQL database from Pharo? Thanks in advance Nacho! ----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/MySQL-framework-for-Pharo-to-analyze-futures-and-optio... Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Of general educational nature are two Glorp guides that I know of: 1) Glorp / User Guide by Nevin Pratt, and 2) San Diego State University "Glorp Tutorial" by Roger Whitney. - Otherwise, there are members on this board who can direct your attention to test code to test your configuration. Good luck, Cam On Mon, Mar 30, 2015 at 10:14 AM, nacho <0800nacho@gmail.com> wrote:
Hi, Thanks for all the input. I've managed to download Glorp and the MySQL Glorp driver. However I'm having serious difficulties in setting it to work. I've search for some documentation in the Glorp page but seems there's a problem with Google Drive. Is there any place to search / look at an example on how to actually connect, map and query a SQL database from Pharo? Thanks in advance Nacho!
----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/MySQL-framework-for-Pharo-to-analyze-futures-and-optio... Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
I have similar plans and also want to use MySQL under Windows. Olivier points me to ODBC connector (http://smalltalkhub.com/#!/~PharoExtras/ODBC <http://smalltalkhub.com/#%21/%7EPharoExtras/ODBC>). Merwan points me to a MySQL driver (http://smalltalkhub.com/#!/~DBXTalk/MysqlDriver). Anyway: Can someone tell me, if DBXtalk is the way to go? BW, Volkert Am 27.03.2015 um 22:21 schrieb nacho:
Hi folks! I'm using MySQL to hold some data on commodities prices for futures valuation and want to - of course - use Smalltalk as a front-end. Which framework would you recommend? This is a good opportunity for me to push Pharo in the company I work for. I want to leverage after that on Roassal and other visualization tools. But the data is already in a SQL database. Thanks in advance Nacho
participants (7)
-
Cameron Sanders -
Mariano Martinez Peck -
Merwan Ouddane -
nacho -
Pierce Ng -
Sven Van Caekenberghe -
volkert