Smalltalk › Pharo › Pharo Smalltalk Users

Best/simplest way to read and write to a MySQL database

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

16 messages Options

Andy Burnett

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

ᐧ

Esteban A. Maringolo

Re: Best/simplest way to read and write to a MySQL database

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 <[hidden email]>:

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 Martinez Peck

Re: Best/simplest way to read and write to a MySQL database

On Wed, May 7, 2014 at 10:12 AM, Esteban A. Maringolo <[hidden email]> 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/

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 <[hidden email]>:

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

Mariano Martinez Peck

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by Andy Burnett

On Wed, May 7, 2014 at 10:09 AM, Andy Burnett <[hidden email]> 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

Sven Van Caekenberghe-2

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by Andy Burnett

Hi Andy,

On 07 May 2014, at 15:09, Andy Burnett <[hidden email]> 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

philippeback

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by Esteban A. Maringolo

On Wed, May 7, 2014 at 3:12 PM, Esteban A. Maringolo <[hidden email]> 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 <[hidden email]>:

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
ᐧ

stepharo

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by Sven Van Caekenberghe-2

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 <[hidden email]> 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
>
>
>
>

stepharo

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by philippeback

Phil

I think that it would be good to migrate the code to SmalltalkHub.

Stef

On 7/5/14 15:48, [hidden email] wrote:

On Wed, May 7, 2014 at 3:12 PM, Esteban A. Maringolo <[hidden email]> 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 <[hidden email]>:

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

ᐧ

philippeback

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by stepharo

I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level.

Le 7 mai 2014 20:30, "stepharo" <[hidden email]> 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 <[hidden email]> 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

Guillermo Polito

Re: Best/simplest way to read and write to a MySQL database

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, [hidden email] <[hidden email]> wrote:

I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level.

Le 7 mai 2014 20:30, "stepharo" <[hidden email]> 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 <[hidden email]> 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

Guillermo Polito

Re: Best/simplest way to read and write to a MySQL database

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 <[hidden email]> 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, [hidden email] <[hidden email]> wrote:

I got it working on Pharo3 on Linux with MySQL 5.1 at the connectivity level.

Le 7 mai 2014 20:30, "stepharo" <[hidden email]> 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 <[hidden email]> 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

Andy Burnett

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by Andy Burnett

ᐧ

Thanks everyone, I shall try the DBXTalk approach. It seems as though it is being actively developed.

As a side note, I think it would be great if Pharo could identify a 'main stream' route for dealing with RDBMS. It would be similar to the way in which Zinc is the main way to do http etc.

I wouldn't want to discourage anyone from doing interestng experiments, it's just that a main stream route would help people to get going.

Cheers

Andy

stepharo

Re: Best/simplest way to read and write to a MySQL database

On 9/5/14 21:54, Andy Burnett wrote:

ᐧ

Thanks everyone, I shall try the DBXTalk approach. It seems as though it is being actively developed.

As a side note, I think it would be great if Pharo could identify a 'main stream' route for dealing with RDBMS. It would be similar to the way in which Zinc is the main way to do http etc.

Yes this is on our roadmap.
We would like to have a page with all the supported and 100% robust solutions. We will start working on that with esteban
in the context of PharoPro.

I wouldn't want to discourage anyone from doing interestng experiments, it's just that a main stream route would help people to get going.

100% agreed.

Cheers

Andy

LogiqueWerks

Re: Best/simplest way to read and write to a MySQL database

"PharoPro" ?

On 10 May 2014 04:09, stepharo <[hidden email]> wrote:

On 9/5/14 21:54, Andy Burnett wrote:

ᐧ

Thanks everyone, I shall try the DBXTalk approach. It seems as though it is being actively developed.

As a side note, I think it would be great if Pharo could identify a 'main stream' route for dealing with RDBMS. It would be similar to the way in which Zinc is the main way to do http etc.

Yes this is on our roadmap.
We would like to have a page with all the supported and 100% robust solutions. We will start working on that with esteban
in the context of PharoPro.

I wouldn't want to discourage anyone from doing interestng experiments, it's just that a main stream route would help people to get going.

100% agreed.

Cheers

Andy

pdigonzelli1

Re: Best/simplest way to read and write to a MySQL database

"PharoPro" ?

Ing. Pablo Digonzelli
Software Solutions
IP-Solutiones SRL

Metrotec SRL
25 de Mayo 521
Email: [hidden email]
[hidden email]
Cel: 5493815982714

De: "Robert Shiplett" <[hidden email]>
Para: "Any question about pharo is welcome" <[hidden email]>
Enviados: Sábado, 10 de Mayo 2014 10:01:51
Asunto: Re: [Pharo-users] Best/simplest way to read and write to a MySQL database

"PharoPro" ?

On 10 May 2014 04:09, stepharo <[hidden email]> wrote:

On 9/5/14 21:54, Andy Burnett wrote:

ᐧ

Thanks everyone, I shall try the DBXTalk approach. It seems as though it is being actively developed.

As a side note, I think it would be great if Pharo could identify a 'main stream' route for dealing with RDBMS. It would be similar to the way in which Zinc is the main way to do http etc.

Yes this is on our roadmap.
We would like to have a page with all the supported and 100% robust solutions. We will start working on that with esteban
in the context of PharoPro.

I wouldn't want to discourage anyone from doing interestng experiments, it's just that a main stream route would help people to get going.

100% agreed.

Cheers

Andy

stepharo

Re: Best/simplest way to read and write to a MySQL database

In reply to this post by LogiqueWerks

"PharoPro" ?

As you know we want people to be able to make business with Pharo so
we are brainstorming on a company offering
    - migration services
    - strong supporting
    - maintained packages

Stef

On 10 May 2014 04:09, stepharo <[hidden email]> wrote:

On 9/5/14 21:54, Andy Burnett wrote:

ᐧ

Thanks everyone, I shall try the DBXTalk approach. It seems as though it is being actively developed.

As a side note, I think it would be great if Pharo could identify a 'main stream' route for dealing with RDBMS. It would be similar to the way in which Zinc is the main way to do http etc.

Yes this is on our roadmap.
We would like to have a page with all the supported and 100% robust solutions. We will start working on that with esteban
in the context of PharoPro.

I wouldn't want to discourage anyone from doing interestng experiments, it's just that a main stream route would help people to get going.

100% agreed.

Cheers

Andy