Smalltalk › Pharo › Pharo Smalltalk Developers

[ANN] ESUG supports once again SqueakDBX

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

7 messages Options

Mariano Martinez Peck

[ANN] ESUG supports once again SqueakDBX

We are really happy to announce that ESUG will sponsor us once again through the ESUG Summer Talk project. This means that we have reached the ESUG expectations and that they still think that relational database access is an important matter in Smalltalk.

One important thing is that we are going to rename the project (we are still working on it) since SqueakDBX runs not only in Squeak but also in Pharo, and there have been even ports to Dolphin. What's the reason for this decision? Because we do not want to couple ourselves to a smalltalk dialect nor to OpenDBX, because our project is much more than that (later I will tell you about our plans). So, these are some of the possible names: ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST, NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your favourite or help us find a new one.

Another important subject is the team. There will be three "mentors", Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.

We are open to suggestions and ideas. In addition, we have defined a possible list of actions that I copy at the end of the email.

For the moment, the url remains www.squeakdbx.org and the mailing list [hidden email]

Once again, we want to thank ESUG for their support and trust.

Thank you very much,

SqueakDBX team

Possible list of actions:

1) Change SqueakDBX’s name.

2) Update GLORP version since the actual one is 3 years old.

Port it again from VisualWorks, create a VW porting tool (may be).
Complete support to Glorp. Today it works with PostgreSQL, Oracle and MySQL. Make it work with most databases OpenDBX supports.

3) Create a lightweight solution, alternatively to GLORP. There are some options:

Make SqueakSave work with SqueakDBX. SqueakSave developers already contacted us because they wanted to do it. SqueakSave seems to be 20% slower than Glorp but you don't need to write the mappings :)
Adapt Ramon Leon's active record to use an abstract database driver, and create a driver for SqueakDBX.
Port the new Glorp’s kind of active record to Pharo. (included in 2).

4) Write a Pharo By Example 2 chapter based on the card game Stef built ;).

5) Cog compatibility.

6) Use Alien instead of FFI.
Eliot is working on a threaded CogVM. One of the projects of the GSoC of this year was to make something similar to a threaded FFI. What the student did is a modification in Alien (I think) that can be run in a multithreaded envirorment. He worked with Eliot. The idea is when Eliot releases the threaded CogVM, this FFI would work our of the box, and would avoid locking the WHOLE vm while a C function is being invoked (as it happens today with FFI).....So....when that VM is released, we MUST migrate to that).

7) Explore performance issues (maybe with our approach of "In thread execution plugin").

8) Complete integration with OpenDBX. For example, Oracle, for large objects (Clob, Blob, etc) use specific functions. There are specific functions in OpenDBX that have to be used if the database uses specific functions (oracle is the only one for the moment.). We don't manage those functions yet.

9) In this link http://www.squeakdbx.org/Targets%20and%20Features
You can see a list of future possible features like Connection pooling (now it is done!), Prepared statement interface, Store procedures, Escape and avoid of SQL insertion, Authentication support: extends to other methods, not only user/password, Full text support, etc.

garduino

Re: [squeak-dev] [ANN] ESUG supports once again SqueakDBX

Certainly all the Smalltalk community should thank ESUG by the
continous support to lot of initiatives.

Thanks ESUG.

2011/3/4 Mariano Martinez Peck <[hidden email]>:

> We are really happy to announce that ESUG will sponsor us once again through
> the ESUG Summer Talk project. This means that we have reached the ESUG
> expectations and that they still think that relational database access is an
> important matter in Smalltalk.
>
> One important thing is that we are going to rename the project (we are still
> working on it) since SqueakDBX runs not only in Squeak but also in Pharo,
> and there have been even ports to Dolphin. What's the reason for this
> decision? Because we do not want to couple ourselves to a smalltalk dialect
> nor to OpenDBX, because our project is much more than that (later I will
> tell you about our plans). So, these are some of the possible names:
> ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST,
> NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your
> favourite or help us find a new one.
>
> Another important subject is the team. There will be three "mentors",
> Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and
> three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.
>
> We are open to suggestions and ideas. In addition, we have defined a
> possible list of actions that I copy at the end of the email.
>
> For the moment, the url remains www.squeakdbx.org and the mailing
> list [hidden email]
>
> Once again, we want to thank ESUG for their support and trust.
>
> Thank you very much,
>
> SqueakDBX team
>
>
>
>
>
> Possible list of actions:
>
> 1) Change SqueakDBX’s name.
>
> 2) Update GLORP version since the actual one is 3 years old.
>
> Port it again from VisualWorks, create a VW porting tool (may be).
> Complete support to Glorp. Today it works with PostgreSQL, Oracle and
> MySQL. Make it work with most databases OpenDBX supports.
>
> 3) Create a lightweight solution, alternatively to GLORP. There are some
> options:
>
> Make SqueakSave work with SqueakDBX. SqueakSave developers already
> contacted us because they wanted to do it. SqueakSave seems to be 20% slower
> than Glorp but you don't need to write the mappings :)
> Adapt Ramon Leon's active record to use an abstract database driver, and
> create a driver for SqueakDBX.
> Port the new Glorp’s kind of active record to Pharo. (included in 2).
>
> 4) Write a Pharo By Example 2 chapter based on the card game Stef built ;).
>
> 5) Cog compatibility.
>
> 6) Use Alien instead of FFI.
> Eliot is working on a threaded CogVM. One of the projects of the GSoC of
> this year was to make something similar to a threaded FFI. What the student
> did is a modification in Alien (I think) that can be run in a multithreaded
> envirorment. He worked with Eliot. The idea is when Eliot releases the
> threaded CogVM, this FFI would work our of the box, and would avoid locking
> the WHOLE vm while a C function is being invoked (as it happens today with
> FFI).....So....when that VM is released, we MUST migrate to that).
>
> 7) Explore performance issues (maybe with our approach of "In thread
> execution plugin").
>
> 8) Complete integration with OpenDBX. For example, Oracle, for large objects
> (Clob, Blob, etc) use specific functions. There are specific functions in
> OpenDBX that have to be used if the database uses specific functions (oracle
> is the only one for the moment.). We don't manage those functions yet.
>
> 9) In this link http://www.squeakdbx.org/Targets%20and%20Features
> You can see a list of future possible features like Connection pooling (now
> it is done!), Prepared statement interface, Store procedures, Escape and
> avoid of SQL insertion, Authentication support: extends to other methods,
> not only user/password, Full text support, etc.
>
>
>

Mariano Martinez Peck

Re: [squeak-dev] [ANN] ESUG supports once again SqueakDBX

On Fri, Mar 4, 2011 at 11:50 AM, Germán Arduino <[hidden email]> wrote:

Certainly all the Smalltalk community should thank ESUG by the
continous support to lot of initiatives.

And to ESUG sponsors :)
and ESUG conference attendees...and...and..lots of people :)

Thanks ESUG.

2011/3/4 Mariano Martinez Peck <[hidden email]>:

> We are really happy to announce that ESUG will sponsor us once again through
> the ESUG Summer Talk project. This means that we have reached the ESUG
> expectations and that they still think that relational database access is an
> important matter in Smalltalk.
>
> One important thing is that we are going to rename the project (we are still
> working on it) since SqueakDBX runs not only in Squeak but also in Pharo,
> and there have been even ports to Dolphin. What's the reason for this
> decision? Because we do not want to couple ourselves to a smalltalk dialect
> nor to OpenDBX, because our project is much more than that (later I will
> tell you about our plans). So, these are some of the possible names:
> ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST,
> NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your
> favourite or help us find a new one.
>
> Another important subject is the team. There will be three "mentors",
> Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and
> three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.
>
> We are open to suggestions and ideas. In addition, we have defined a
> possible list of actions that I copy at the end of the email.
>
> For the moment, the url remains www.squeakdbx.org and the mailing
> list [hidden email]
>
> Once again, we want to thank ESUG for their support and trust.
>
> Thank you very much,
>
> SqueakDBX team
>
>
>
>
>
> Possible list of actions:
>
> 1) Change SqueakDBX’s name.
>
> 2) Update GLORP version since the actual one is 3 years old.
>
> Port it again from VisualWorks, create a VW porting tool (may be).
> Complete support to Glorp. Today it works with PostgreSQL, Oracle and
> MySQL. Make it work with most databases OpenDBX supports.
>
> 3) Create a lightweight solution, alternatively to GLORP. There are some
> options:
>
> Make SqueakSave work with SqueakDBX. SqueakSave developers already
> contacted us because they wanted to do it. SqueakSave seems to be 20% slower
> than Glorp but you don't need to write the mappings :)
> Adapt Ramon Leon's active record to use an abstract database driver, and
> create a driver for SqueakDBX.
> Port the new Glorp’s kind of active record to Pharo. (included in 2).
>
> 4) Write a Pharo By Example 2 chapter based on the card game Stef built ;).
>
> 5) Cog compatibility.
>
> 6) Use Alien instead of FFI.
> Eliot is working on a threaded CogVM. One of the projects of the GSoC of
> this year was to make something similar to a threaded FFI. What the student
> did is a modification in Alien (I think) that can be run in a multithreaded
> envirorment. He worked with Eliot. The idea is when Eliot releases the
> threaded CogVM, this FFI would work our of the box, and would avoid locking
> the WHOLE vm while a C function is being invoked (as it happens today with
> FFI).....So....when that VM is released, we MUST migrate to that).
>
> 7) Explore performance issues (maybe with our approach of "In thread
> execution plugin").
>
> 8) Complete integration with OpenDBX. For example, Oracle, for large objects
> (Clob, Blob, etc) use specific functions. There are specific functions in
> OpenDBX that have to be used if the database uses specific functions (oracle
> is the only one for the moment.). We don't manage those functions yet.
>
> 9) In this link http://www.squeakdbx.org/Targets%20and%20Features
> You can see a list of future possible features like Connection pooling (now
> it is done!), Prepared statement interface, Store procedures, Escape and
> avoid of SQL insertion, Authentication support: extends to other methods,
> not only user/password, Full text support, etc.
>
>
>

Mariano Martinez Peck

Re: [Esug-list] [squeak-dev] [ANN] ESUG supports once againSqueakDBX

On Sat, Mar 5, 2011 at 2:47 AM, Carlos Crosetti <[hidden email]> wrote:

My 10 cents to the SqueakDBX list of actions......

Long time ago, when I learnt about the VW UI Builder, I attempted to run an existing sample code that was basically a dataset widget browsing a collection of objects, and then I wrote some code to make them persistent using ObjectLens and Oracle.

Later on time, I would say 12+ years later, I learnt about GLORP and wrote a morphic-based dialog to do the most simple CRUD model to teach myself persisting objects into PostgreSQL using Glorp and a GUI.

My suggestion to the SqueakDBX team is to incllude a working sample but this time based on the Morphic UI Designer.

Got it. And what about Seaside for example? Few years back, we used to have a Seaside + GlorpDBX + SqueakDBX example that we used for the university thesis. However, I guess it is quite outdated and note sure if it works. But maybe we should do that. I think it is a good idea.

In addition, we can use the same example for the PBE chapter.

Finally, I remember an ESUG project which idea was a open source application based in pharo, seaside, glorp, etc, to use as an example/learning. I don't remember the name right now....but it would be awesome if that app could be changed to use GlorpDBX + SqueakDBX instead :)

thanks

mariano

----- Original Message -----

From: [hidden email]

To: [hidden email]

Cc: [hidden email] ; [hidden email] ; [hidden email] ; [hidden email]

Sent: Friday, March 04, 2011 7:53 AM

Subject: Re: [Esug-list] [squeak-dev] [ANN] ESUG supports once againSqueakDBX

On Fri, Mar 4, 2011 at 11:50 AM, Germán Arduino <[hidden email]> wrote:

Certainly all the Smalltalk community should thank ESUG by the
continous support to lot of initiatives.

And to ESUG sponsors :)
and ESUG conference attendees...and...and..lots of people :)

Thanks ESUG.

2011/3/4 Mariano Martinez Peck <[hidden email]>:

> We are really happy to announce that ESUG will sponsor us once again through

> the ESUG Summer Talk project. This means that we have reached the ESUG
> expectations and that they still think that relational database access is an
> important matter in Smalltalk.
>
> One important thing is that we are going to rename the project (we are still
> working on it) since SqueakDBX runs not only in Squeak but also in Pharo,
> and there have been even ports to Dolphin. What's the reason for this
> decision? Because we do not want to couple ourselves to a smalltalk dialect
> nor to OpenDBX, because our project is much more than that (later I will
> tell you about our plans). So, these are some of the possible names:
> ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST,
> NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your
> favourite or help us find a new one.
>
> Another important subject is the team. There will be three "mentors",
> Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and
> three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.
>
> We are open to suggestions and ideas. In addition, we have defined a
> possible list of actions that I copy at the end of the email.
>
> For the moment, the url remains www.squeakdbx.org and the mailing
> list [hidden email]
>
> Once again, we want to thank ESUG for their support and trust.
>
> Thank you very much,
>
> SqueakDBX team
>
>
>
>
>
> Possible list of actions:
>
> 1) Change SqueakDBX’s name.
>
> 2) Update GLORP version since the actual one is 3 years old.
>
> Port it again from VisualWorks, create a VW porting tool (may be).
> Complete support to Glorp. Today it works with PostgreSQL, Oracle and
> MySQL. Make it work with most databases OpenDBX supports.
>
> 3) Create a lightweight solution, alternatively to GLORP. There are some
> options:
>
> Make SqueakSave work with SqueakDBX. SqueakSave developers already
> contacted us because they wanted to do it. SqueakSave seems to be 20% slower
> than Glorp but you don't need to write the mappings :)
> Adapt Ramon Leon's active record to use an abstract database driver, and
> create a driver for SqueakDBX.
> Port the new Glorp’s kind of active record to Pharo. (included in 2).
>
> 4) Write a Pharo By Example 2 chapter based on the card game Stef built ;).
>
> 5) Cog compatibility.
>
> 6) Use Alien instead of FFI.
> Eliot is working on a threaded CogVM. One of the projects of the GSoC of
> this year was to make something similar to a threaded FFI. What the student
> did is a modification in Alien (I think) that can be run in a multithreaded
> envirorment. He worked with Eliot. The idea is when Eliot releases the
> threaded CogVM, this FFI would work our of the box, and would avoid locking
> the WHOLE vm while a C function is being invoked (as it happens today with
> FFI).....So....when that VM is released, we MUST migrate to that).
>
> 7) Explore performance issues (maybe with our approach of "In thread
> execution plugin").
>
> 8) Complete integration with OpenDBX. For example, Oracle, for large objects
> (Clob, Blob, etc) use specific functions. There are specific functions in
> OpenDBX that have to be used if the database uses specific functions (oracle
> is the only one for the moment.). We don't manage those functions yet.
>
> 9) In this link http://www.squeakdbx.org/Targets%20and%20Features
> You can see a list of future possible features like Connection pooling (now
> it is done!), Prepared statement interface, Store procedures, Escape and
> avoid of SQL insertion, Authentication support: extends to other methods,
> not only user/password, Full text support, etc.
>
>
>

_______________________________________________
Esug-list mailing list
[hidden email]
http://lists.esug.org/mailman/listinfo/esug-list_lists.esug.org

Sven Van Caekenberghe

Re: [Esug-list] [squeak-dev] [ANN] ESUG supports once againSqueakDBX

On 05 Mar 2011, at 11:32, Mariano Martinez Peck wrote:

> Got it. And what about Seaside for example? Few years back, we used to have a Seaside + GlorpDBX + SqueakDBX example that we used for the university thesis. However, I guess it is quite outdated and note sure if it works. But maybe we should do that. I think it is a good idea.

Last year, I did my own example and wrote an article about it:

Reddit.st - In 10 elegant Smalltalk classes

Implementing a Reddit style web application in Smalltalk

Using Seaside, Glorp and PostgreSQL

http://homepage.mac.com/svc/Reddit.st/

Sven

Mariano Martinez Peck

Re: [squeak-dev] [ANN] ESUG supports once again SqueakDBX

In reply to this post by Mariano Martinez Peck

On Sun, Mar 6, 2011 at 12:40 PM, Levente Uzonyi <[hidden email]> wrote:

On Fri, 4 Mar 2011, Mariano Martinez Peck wrote:

We are really happy to announce that ESUG will sponsor us once again through
the ESUG Summer Talk project. This means that we have reached the ESUG
expectations and that they still think that relational database access is an
important matter in Smalltalk.

snip

5) Cog compatibility.

What has to be done?

Indeed, nothing. We were not sure if FFI was working on it, but it turns out that it was. The idea is to be aware if Eliot releases a threaded VM/FFI so that we do not lock the VM (even if we have our micro-lock strategy when possible)

6) Use Alien instead of FFI.
Eliot is working on a threaded CogVM. One of the projects of the GSoC of
this year was to make something similar to a threaded FFI. What the student
did is a modification in Alien (I think) that can be run in a multithreaded
envirorment. He worked with Eliot. The idea is when Eliot releases the
threaded CogVM, this FFI would work our of the box, and would avoid locking
the WHOLE vm while a C function is being invoked (as it happens today with
FFI).....So....when that VM is released, we MUST migrate to that).

How is Alien better than FFI?

We do not know. However, we will not spend time in Alien unless it is working out of the box and integrated in all standard VMs.

AFAIK Alien itself is not developed anymore,
parts of it will be merged with FFI.

Ahh ok, we didn't know. Thnkas.

Levente

P.S.: http://www.squeaksource.com/SqueakDBX.html states that code in the repository has MIT license, but it includes Glorp which has LGPL(S) license.

Yes, the problem is that SqueakDBX as itself (the database driver), is MIT. Thus, the repository is MIT. Glorp is LGPL. When we started (years after SqueakDBX) with GlorpDBX, we found it easier to commit our changes to SqueakDBX repo instead of the Glorp one (because not everybody may agree with our changes).

The good news is that Alan Night was considering making Glorp MIT. I cc'ed him to see if there are news.

Cheers

Mariano

Alan Knight-2

Re: [ANN] ESUG supports once again SqueakDBX

In reply to this post by Mariano Martinez Peck

As far as the item of updating the Glorp port, that would be great. I note that there is a crude porting tool that generates Squeak fileouts included in Glorp. There is also the work that was done for Seaside that can convert back and forth between a Store database and a Monticello repository. I think that it is not trivial to set up, but since I am the manager of the authors it should be possible to get some help. That would also be nice to then have fixes flowing in both directions.

On 2011-03-04 3:40 AM, Mariano Martinez Peck wrote:

We are really happy to announce that ESUG will sponsor us once again through the ESUG Summer Talk project. This means that we have reached the ESUG expectations and that they still think that relational database access is an important matter in Smalltalk.

One important thing is that we are going to rename the project (we are still working on it) since SqueakDBX runs not only in Squeak but also in Pharo, and there have been even ports to Dolphin. What's the reason for this decision? Because we do not want to couple ourselves to a smalltalk dialect nor to OpenDBX, because our project is much more than that (later I will tell you about our plans). So, these are some of the possible names: ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST, NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your favourite or help us find a new one.

Another important subject is the team. There will be three "mentors", Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.

We are open to suggestions and ideas. In addition, we have defined a possible list of actions that I copy at the end of the email.

For the moment, the url remains www.squeakdbx.org and the mailing list [hidden email]

Once again, we want to thank ESUG for their support and trust.

Thank you very much,

SqueakDBX team

Possible list of actions:

1) Change SqueakDBX’s name.

2) Update GLORP version since the actual one is 3 years old.

Port it again from VisualWorks, create a VW porting tool (may be).
Complete support to Glorp. Today it works with PostgreSQL, Oracle and MySQL. Make it work with most databases OpenDBX supports.

3) Create a lightweight solution, alternatively to GLORP. There are some options:

Make SqueakSave work with SqueakDBX. SqueakSave developers already contacted us because they wanted to do it. SqueakSave seems to be 20% slower than Glorp but you don't need to write the mappings :)
Adapt Ramon Leon's active record to use an abstract database driver, and create a driver for SqueakDBX.
Port the new Glorp’s kind of active record to Pharo. (included in 2).

4) Write a Pharo By Example 2 chapter based on the card game Stef built ;).

5) Cog compatibility.

6) Use Alien instead of FFI.
Eliot is working on a threaded CogVM. One of the projects of the GSoC of this year was to make something similar to a threaded FFI. What the student did is a modification in Alien (I think) that can be run in a multithreaded envirorment. He worked with Eliot. The idea is when Eliot releases the threaded CogVM, this FFI would work our of the box, and would avoid locking the WHOLE vm while a C function is being invoked (as it happens today with FFI).....So....when that VM is released, we MUST migrate to that).

7) Explore performance issues (maybe with our approach of "In thread execution plugin").

8) Complete integration with OpenDBX. For example, Oracle, for large objects (Clob, Blob, etc) use specific functions. There are specific functions in OpenDBX that have to be used if the database uses specific functions (oracle is the only one for the moment.). We don't manage those functions yet.

9) In this link http://www.squeakdbx.org/Targets%20and%20Features
You can see a list of future possible features like Connection pooling (now it is done!), Prepared statement interface, Store procedures, Escape and avoid of SQL insertion, Authentication support: extends to other methods, not only user/password, Full text support, etc.

-- 
Alan Knight [|], Engineering Manager, Cincom Smalltalk
[hidden email]
[hidden email]
http://www.cincomsmalltalk.com