Best/simplest way to read and write to a MySQL database
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue. I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database? Cheers Andy á§
As far as I understand, you have to install DBXTalk in your image, and have the OpenDBX drivers available. There is no native option for MySQL, nor a direct wrapper of MySQL client. http://dbxtalk.smallworks.com.ar/DBXTalkDrivers/ Regards! Esteban A. Maringolo 2014-05-07 10:09 GMT-03:00 Andy Burnett <andy.burnett@knowinnovation.com>:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy á§
On Wed, May 7, 2014 at 10:12 AM, Esteban A. Maringolo <emaringolo@gmail.com>wrote:
As far as I understand, you have to install DBXTalk in your image, and have the OpenDBX drivers available. There is no native option for MySQL, nor a direct wrapper of MySQL client.
Hi Esteban, There is (well...maybe WAS) a native (Squeak) MySQL driver. I don't know what it's status is, nor if it works in Pharo or not. But some years ago there was a (limited) MySQL Squeak driver. Best,
Regards!
Esteban A. Maringolo
2014-05-07 10:09 GMT-03:00 Andy Burnett <andy.burnett@knowinnovation.com>:
I need to write some agents that will process data in a MySQL database.
They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy á§
-- Mariano http://marianopeck.wordpress.com
On Wed, May 7, 2014 at 3:12 PM, Esteban A. Maringolo <emaringolo@gmail.com>wrote:
As far as I understand, you have to install DBXTalk in your image, and have the OpenDBX drivers available. There is no native option for MySQL, nor a direct wrapper of MySQL client.
http://dbxtalk.smallworks.com.ar/DBXTalkDrivers/
Regards!
There is also stdb as in: http://www.squeaksource.com/StdbMysqlProtocol/ An example http://programminggems.wordpress.com/2012/02/27/using-mysql-in-aida-on-pharo... I do not know if it works in 3.0 but I am going to give it a shot in the coming week. Phil
Esteban A. Maringolo
2014-05-07 10:09 GMT-03:00 Andy Burnett <andy.burnett@knowinnovation.com>:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy á§
Phil I think that it would be good to migrate the code to SmalltalkHub. Stef On 7/5/14 15:48, phil@highoctane.be wrote:
On Wed, May 7, 2014 at 3:12 PM, Esteban A. Maringolo <emaringolo@gmail.com <mailto:emaringolo@gmail.com>> wrote:
As far as I understand, you have to install DBXTalk in your image, and have the OpenDBX drivers available. There is no native option for MySQL, nor a direct wrapper of MySQL client.
http://dbxtalk.smallworks.com.ar/DBXTalkDrivers/
Regards!
There is also stdb as in:
http://www.squeaksource.com/StdbMysqlProtocol/
An example
http://programminggems.wordpress.com/2012/02/27/using-mysql-in-aida-on-pharo...
I do not know if it works in 3.0 but I am going to give it a shot in the coming week.
Phil
Esteban A. Maringolo
2014-05-07 10:09 GMT-03:00 Andy Burnett <andy.burnett@knowinnovation.com <mailto:andy.burnett@knowinnovation.com>>:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy á§
On Wed, May 7, 2014 at 10:09 AM, Andy Burnett < andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
If performance is not a huge issue, and all you need to do is to write a few queries (now to map a whole domain model into a relational DB), then you may bypass the ORM (Glorp). If performance is not a very high issue, and your usage is quite simple and limited, you may want to search/test the old squeak MySQL driver and see if you can make it work and if it works with latests MySQL version.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy á§
-- Mariano http://marianopeck.wordpress.com
Hi Andy, On 07 May 2014, at 15:09, Andy Burnett <andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy
Googling a bit let to this: Now available: a database conectivity API and its MySQL implementation http://forum.world.st/Now-available-a-database-conectivity-API-and-its-MySQL... Sven
Do we migrate the code to SmalltalkHub and add some configuration? I know that Olivier told me that he uses a direct mysql driver (or I confused it with another one). Stef On 7/5/14 15:26, Sven Van Caekenberghe wrote:
Hi Andy,
On 07 May 2014, at 15:09, Andy Burnett <andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy Googling a bit let to this:
Now available: a database conectivity API and its MySQL implementation
http://forum.world.st/Now-available-a-database-conectivity-API-and-its-MySQL...
Sven
I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level. Le 7 mai 2014 20:30, "stepharo" <stepharo@free.fr> a écrit :
Do we migrate the code to SmalltalkHub and add some configuration? I know that Olivier told me that he uses a direct mysql driver (or I confused it with another one).
Stef
On 7/5/14 15:26, Sven Van Caekenberghe wrote:
Hi Andy,
On 07 May 2014, at 15:09, Andy Burnett <andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL database.
They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy
Googling a bit let to this:
Now available: a database conectivity API and its MySQL implementation
http://forum.world.st/Now-available-a-database- conectivity-API-and-its-MySQL-implementation-td3854743.html
Sven
There is also http://www.squeaksource.com/MySQL.html what is the difference? I was planning to move this last one under DBXTalk On Wed, May 7, 2014 at 8:40 PM, phil@highoctane.be <phil@highoctane.be>wrote:
I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level. Le 7 mai 2014 20:30, "stepharo" <stepharo@free.fr> a écrit :
Do we migrate the code to SmalltalkHub and add some configuration?
I know that Olivier told me that he uses a direct mysql driver (or I confused it with another one).
Stef
On 7/5/14 15:26, Sven Van Caekenberghe wrote:
Hi Andy,
On 07 May 2014, at 15:09, Andy Burnett <andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL database.
They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy
Googling a bit let to this:
Now available: a database conectivity API and its MySQL implementation
http://forum.world.st/Now-available-a-database- conectivity-API-and-its-MySQL-implementation-td3854743.html
Sven
Looks like http://www.squeaksource.com/StdbMysqlProtocol.html has more recent activity. I'll migrate that one now, It's MIT. I'll contact it's owner. On Thu, May 8, 2014 at 6:49 PM, Guillermo Polito <guillermopolito@gmail.com>wrote:
There is also
http://www.squeaksource.com/MySQL.html
what is the difference?
I was planning to move this last one under DBXTalk
On Wed, May 7, 2014 at 8:40 PM, phil@highoctane.be <phil@highoctane.be>wrote:
I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level. Le 7 mai 2014 20:30, "stepharo" <stepharo@free.fr> a écrit :
Do we migrate the code to SmalltalkHub and add some configuration?
I know that Olivier told me that he uses a direct mysql driver (or I confused it with another one).
Stef
On 7/5/14 15:26, Sven Van Caekenberghe wrote:
Hi Andy,
On 07 May 2014, at 15:09, Andy Burnett <andy.burnett@knowinnovation.com> wrote:
I need to write some agents that will process data in a MySQL
database. They don't need to do anything particularly clever, and performance isn't a huge issue.
I read the threads about Glorp and DBXTalk, and I was left feeling a bit confused about the best approach. Given that my needs are simple, what would be the recommended way to interface with the database?
Cheers Andy
Googling a bit let to this:
Now available: a database conectivity API and its MySQL implementation
http://forum.world.st/Now-available-a-database- conectivity-API-and-its-MySQL-implementation-td3854743.html
Sven
participants (7)
-
Andy Burnett -
Esteban A. Maringolo -
Guillermo Polito -
Mariano Martinez Peck -
phil＠highoctane.be -
stepharo -
Sven Van Caekenberghe