SqueakDBX January 2010

squeakdbx@lists.squeakfoundation.org

2 participants
6 discussions

Fwd: [ANN] PDF of Dynamic Web Development with Seaside
by Mariano Martinez Peck 27 Jan '10

27 Jan '10

For those who may be interested. ---------- Forwarded message ---------- From: Lukas Renggli <renggli(a)gmail.com> Date: Wed, Jan 27, 2010 at 2:49 PM Subject: [squeak-dev] [ANN] PDF of Dynamic Web Development with Seaside To: Seaside <seaside(a)lists.squeakfoundation.org>, Pharo Development < pharo-project(a)lists.gforge.inria.fr>, Squeak < squeak-dev(a)lists.squeakfoundation.org>, "Magritte, Pier and Related Tools ..." <smallwiki(a)iam.unibe.ch> The PDF version of the book "Dynamic Web Development with Seaside" is available for download now: http://book.seaside.st/book/introduction/pdf-book At the end of the payment process (PayPal) you will be redirected to the download area where you are able to get the latest builds of the PDF version of the book. If you bookmark the page you will be able to download fixes and extra chapters as we integrate them into the online version. By buying the PDF version you support our hard work on the book. We wish to thank the European Smalltalk User Group (ESUG), inceptive.be, Cincom Smalltalk and GemStone Smalltalk for generously sponsoring this book. We are looking for additional sponsors. If you are interested, please contact us. If you are a publisher and interested in publishing this material, please let us know. Please distribute this message widely. Cheers, Stef & Lukas -- Lukas Renggli http://www.lukas-renggli.ch

1 0

Re: [squeak-dev] Re: SqueakDBX installation questions (problems)?
by Mariano Martinez Peck 14 Jan '10

14 Jan '10

On Thu, Jan 14, 2010 at 1:28 AM, Andreas Raab <andreas.raab(a)gmx.de> wrote: > John Chludzinski wrote: > >> Using SqueakMap I installed "SqueakDBX, version: 1.1" >> (OpenDBX-Core-MarianoMartinezPeck.234.mcz). I then installed >> FFI-Win32-ar.2.mcz, just to make sure I had the necessary FFI support. >> Tried "MysqlTinyBenchmarks new benchmarkInsert" again and died with >> 'Loading backend library failed' in DBXPlatform>>createConnection:. >> >> BTW, I checked and indeed libopendbx-1.dll is in the bin folder. >> >> Any ideas? >> > > You may need the "extra" dlls in the windows download of OpenDBX. I'm > thinking they implement the backend connections so if you're going to use > MySQL you'll likely need the mysql backend dll. > > That question is wrriten in the FAQ: http://www.squeakdbx.org/FAQ Yes, it is exactly what Andreas said. Think in OpenDBX like ODBC. You need the odbc.dll but also you will need then the odbc library of the backend. Here it is the same. You need opendbx dll but also the mysql client library dlls. You can download essential package from here: http://dev.mysql .com/downloads/mysql/5.0.html#win32 You may want to install only the client. Be sure also the that the dlls are "findable" by windows. In my case, I installed in C:/MySQL and I put in $PATH the directory C:\MySQL\bin\ Probably, this is done automatically done by windows. Cheers Mariano > Cheers, > - Andreas > >

1 0

Re: [squeak-dev] SqueakDBX installation questions (problems)?
by Mariano Martinez Peck 13 Jan '10

13 Jan '10

On Wed, Jan 13, 2010 at 11:19 PM, John Chludzinski < john.chludzinski(a)gmail.com> wrote: > First, I'm on Windows XP. > > I went to http://www.squeaksource.com/SqueakDBX. and downloaded > OpenDBX-Core-MarianoMartinezPeck.252.mcz and loaded it. When > installing OpenDBX-Core-MarianoMartinezPeck.252.mcz I never saw any > hiccups about FFI so I assumed the Croquet image has the necessary FFI > classes. > You cannot only install that package. There are several packages to install them. In our website you can find almost all information: http://www.squeakdbx.org/ In this case, you should read: http://www.squeakdbx.org/Installation But...it is something like this: Installer ss project: ’SqueakDBX’; install: ’SqueakDBXPharoLoader’. (or you can download it manually using monticello browser) And then evaluate: SqueakDBXPharoLoader loadSqueakDBX Instead of using our own loaders you can also use the Metacello configuration. You have to download the package ConfigurationOfSqueakDBX from the repository MetacelloRepository in SqueakSource and then evaluate: (ConfigurationOfSqueakDBX project version: '1.0') load. > > I then followed the link to > http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows and > downloaded the opendbx-1.4.4_win32.zip binaries. This contains 2 > dll's and a folder will more dll's. I extracted the 2 top level dll's > into my bin-directory containing Croquet.exe. > I suggest you to read: - http://www.squeakdbx.org/Compiling%20and%20installing%20OpenDBX - http://www.squeakdbx.org/Compiling%20for%20different%20backends In http://www.squeakdbx.org/documentation you have a lot of info. > After modifying MysqlTinyBenchmarks>>initializeConnection with the > appropriate info (password, database, host, etc.) I tried executing: > "MysqlTinyBenchmarks new benchmarkInsert". This died in DBXPlatform >> > createConnection: referencing OpenDBX. When I went back and looked at > the Transcript window messages (about loading > OpenDBX-Core-MarianoMartinezPeck.252.mcz) I noticed "OpenDBX is > Undeclared" in multiple places. I assumed this is a reference to a > class that wasn't included in OpenDBX-Core-MarianoMartinezPeck.252.mcz > package? > Yes, the loader should fix this. > > I wish there were a simple list of instructions to accomplish this? > (Or, maybe I'm not seeing the obvious?) > > Almost all information is in the website. Just ask if you have further questions. We have our own mailing list also (I have cc'ed it) A little note: I have ever tested SqueakDBX on Croquet, so, I don't know if it works or not. I guess...but not tested (at least for our team). Cheers! Mariano > ---John > >

1 0

Re: Gofer for GlorpDBX
by Mariano Martinez Peck 10 Jan '10

10 Jan '10

On Sun, Jan 10, 2010 at 9:49 PM, John Toohey <jt(a)parspro.com> wrote: > My app is a private one, with about 30+ users are a given time, however, > its must be responsive for all these users, as they are updating markets > prices etc. When a market closes, I need to updates a few thousand records, > and during that time, I cannot have the image *frozen*, as it would effect > the other users, in a time critical application. I haven't been able to do > proper stress tests yet, as I'm still wrapping up functionality, but based > on what I've read, I decided that using a SP to perform the updates would be > faster. > > Ok. That's perfect. However, let me remark something. As you may know, SqueakDBX uses FFI to talk to OpenDBX. FFI locks THE COMPLETE VM while the C function is being executed. And that cannot be change. What you can change is try to do those functions as little time as possible. Imagine a query and that the function does not return until the query is done. THAT will freeze the image for a long time. However, we have a better strategy. OpenDBX, when possible, uses asynchronous queries. This means that it just calls a function to send the query, and then, it loops asking "is it ready?" until the query is done So, we have "little locks". The goods news is that after asking, if there are other process in the queue, it should be processed. With this way we process several queries "at the same time.". Se the method DBXPlatform >> processNextResultSet: aConnection querySettings: aQuerySettings where we do: (code = OpenDBX resultTimeout) ifTrue: [ (Delay forMilliseconds: (aQuerySettings timeout asMiliseconds)) wait ]. I invite you to read the slides: http://www.slideshare.net/esug/squeak-dbx There I explain this comparing SqueakDBX against ODBC driver for squeak. I said "OpenDBX, when possible" because it not depends only in OpenDBX but also in the client library. Some support this and some doesn't. But I think most engines support this. I know PostgreSQL does. BTW, which OS are you deploying on ? Cheers Mariano > Did I misunderstand this? > > > On Sun, Jan 10, 2010 at 15:27, Mariano Martinez Peck < > marianopeck(a)gmail.com> wrote: > >> >> >> On Sun, Jan 10, 2010 at 9:23 PM, John Toohey <jt(a)parspro.com> wrote: >> >>> Nice, I didn't notice these on the site before. Seem OpenDBX wins easily >>> with inserts to Postgres. Unfortunately, because of the image freezing >>> during a large amount of updates/inserts, >> >> >> Can you explain me this a bit more? The image "should" "freeze". Actually, >> the queries are running in a most important priority than the UI. However, >> for example you have a Seaside website, and there comes another request from >> another user and sends a query to the database, it should also process this >> new request. >> >> >>> I'm going to a stored procedure for that. >>> >>> >>> On Sun, Jan 10, 2010 at 14:56, Mariano Martinez Peck < >>> marianopeck(a)gmail.com> wrote: >>> >>>> >>>> >>>> On Sun, Jan 10, 2010 at 5:51 PM, John Toohey <jt(a)parspro.com> wrote: >>>> >>>>> Thanks, this is what I wanted. It takes time to build a new image from >>>>> scratch, so I want to use Gofer to install Seaside, Glorp, my code etc. I >>>>> wanted to get a script that was tested and would give me the latest builds. >>>>> Just wondering if you have an benchmarks on using the Native driver with the >>>>> GlorpDBX. I'm going into production soon, and still am not sure what way to >>>>> go. >>>>> >>>>> >>>> Hi John. There are becnhmarks for SqueakDBX agains native drivers, but >>>> not related with GlorpDBX. Although, if one driver is faster, it make sense >>>> that GLorp is faster too using that driver. >>>> >>>> The SqueakDBX benchmarks were of the first things we did when we start >>>> SqueakDBX. You can read this link: http://www.squeakdbx.org/Benchmarks >>>> >>>> You can run them by yourself and compare. >>>> >>>> Ask if you need help with that :) >>>> >>>> Cheers >>>> >>>> Mariano >>>> >>>> >>>>> >>>>> On Sat, Jan 9, 2010 at 17:41, Mariano Martinez Peck < >>>>> marianopeck(a)gmail.com> wrote: >>>>> >>>>>> >>>>>> >>>>>> On Sat, Jan 9, 2010 at 11:24 PM, John Toohey <jt(a)parspro.com> wrote: >>>>>> >>>>>>> Have you made a Gofer script to install the latest GloprDBX and >>>>>>> Postgres driver on the latest RC1 Pharo images? I'm trying to create a full >>>>>>> Gofer script that will build my entire app from a Pharo DEV image. >>>>>>> >>>>>>> >>>>>> Hi John. I didn't wrote any Gofer plugin and I even don't have it in >>>>>> mind. The future of SqueakDBX and GlorpDBX packages managment will be with >>>>>> Metacello. >>>>>> >>>>>> So far, you have in the repository MetacelloRepository in >>>>>> squeakspurce, two packages: ConfigurationOfSqueakDBX and >>>>>> ConfigurationOfGlorpDBX. The second one, right now it install GlorpDBX and >>>>>> the SqueakDBX driver, NOT the PostgreSQL native driver. If this is what you >>>>>> want, maybe I can add a group to metacello conf. >>>>>> >>>>>> Right now, to install SqueakDBX you have to evaluate: >>>>>> >>>>>> Gofer new >>>>>> squeaksource: 'MetacelloRepository'; >>>>>> package: 'ConfigurationOfSqueakDBX'; >>>>>> load. >>>>>> >>>>>> ((Smalltalk at: #ConfigurationOfSqueakDBX) project version: '1.0') >>>>>> load. >>>>>> >>>>>> >>>>>> And for GlorpDBX: >>>>>> >>>>>> Gofer new >>>>>> squeaksource: 'MetacelloRepository'; >>>>>> package: 'ConfigurationOfGlorpDBX'; >>>>>> load. >>>>>> >>>>>> ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') >>>>>> load. >>>>>> >>>>>> If you really need to load GlorpDBX with Postgresql native driver, >>>>>> than I can create a group so that you will be able to evaluate: >>>>>> >>>>>> ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') >>>>>> load: 'GlorpDBXWithNativePostgreSQLNativeDriver' >>>>>> >>>>>> Do you need that? >>>>>> >>>>>> In addition, the loaders we wrote some time ago, should be running: >>>>>> >>>>>> Gofer new >>>>>> squeaksource: 'Glorp'; >>>>>> package: 'ConfigurationOfGlorpDBX'; >>>>>> load. >>>>>> >>>>>> GlorpPharoLoader loadGlorpWithNativePostgreSQLDriver >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>>> -JT >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> -JT >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> -JT >>> >>> >>> >> > > > -- > -JT > > >

1 0

Re: Gofer for GlorpDBX
by Mariano Martinez Peck 10 Jan '10

10 Jan '10

On Sun, Jan 10, 2010 at 9:23 PM, John Toohey <jt(a)parspro.com> wrote: > Nice, I didn't notice these on the site before. Seem OpenDBX wins easily > with inserts to Postgres. Unfortunately, because of the image freezing > during a large amount of updates/inserts, Can you explain me this a bit more? The image "should" "freeze". Actually, the queries are running in a most important priority than the UI. However, for example you have a Seaside website, and there comes another request from another user and sends a query to the database, it should also process this new request. > I'm going to a stored procedure for that. > > > On Sun, Jan 10, 2010 at 14:56, Mariano Martinez Peck < > marianopeck(a)gmail.com> wrote: > >> >> >> On Sun, Jan 10, 2010 at 5:51 PM, John Toohey <jt(a)parspro.com> wrote: >> >>> Thanks, this is what I wanted. It takes time to build a new image from >>> scratch, so I want to use Gofer to install Seaside, Glorp, my code etc. I >>> wanted to get a script that was tested and would give me the latest builds. >>> Just wondering if you have an benchmarks on using the Native driver with the >>> GlorpDBX. I'm going into production soon, and still am not sure what way to >>> go. >>> >>> >> Hi John. There are becnhmarks for SqueakDBX agains native drivers, but not >> related with GlorpDBX. Although, if one driver is faster, it make sense that >> GLorp is faster too using that driver. >> >> The SqueakDBX benchmarks were of the first things we did when we start >> SqueakDBX. You can read this link: http://www.squeakdbx.org/Benchmarks >> >> You can run them by yourself and compare. >> >> Ask if you need help with that :) >> >> Cheers >> >> Mariano >> >> >>> >>> On Sat, Jan 9, 2010 at 17:41, Mariano Martinez Peck < >>> marianopeck(a)gmail.com> wrote: >>> >>>> >>>> >>>> On Sat, Jan 9, 2010 at 11:24 PM, John Toohey <jt(a)parspro.com> wrote: >>>> >>>>> Have you made a Gofer script to install the latest GloprDBX and >>>>> Postgres driver on the latest RC1 Pharo images? I'm trying to create a full >>>>> Gofer script that will build my entire app from a Pharo DEV image. >>>>> >>>>> >>>> Hi John. I didn't wrote any Gofer plugin and I even don't have it in >>>> mind. The future of SqueakDBX and GlorpDBX packages managment will be with >>>> Metacello. >>>> >>>> So far, you have in the repository MetacelloRepository in squeakspurce, >>>> two packages: ConfigurationOfSqueakDBX and ConfigurationOfGlorpDBX. The >>>> second one, right now it install GlorpDBX and the SqueakDBX driver, NOT the >>>> PostgreSQL native driver. If this is what you want, maybe I can add a group >>>> to metacello conf. >>>> >>>> Right now, to install SqueakDBX you have to evaluate: >>>> >>>> Gofer new >>>> squeaksource: 'MetacelloRepository'; >>>> package: 'ConfigurationOfSqueakDBX'; >>>> load. >>>> >>>> ((Smalltalk at: #ConfigurationOfSqueakDBX) project version: '1.0') load. >>>> >>>> >>>> And for GlorpDBX: >>>> >>>> Gofer new >>>> squeaksource: 'MetacelloRepository'; >>>> package: 'ConfigurationOfGlorpDBX'; >>>> load. >>>> >>>> ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load. >>>> >>>> If you really need to load GlorpDBX with Postgresql native driver, than >>>> I can create a group so that you will be able to evaluate: >>>> >>>> ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load: >>>> 'GlorpDBXWithNativePostgreSQLNativeDriver' >>>> >>>> Do you need that? >>>> >>>> In addition, the loaders we wrote some time ago, should be running: >>>> >>>> Gofer new >>>> squeaksource: 'Glorp'; >>>> package: 'ConfigurationOfGlorpDBX'; >>>> load. >>>> >>>> GlorpPharoLoader loadGlorpWithNativePostgreSQLDriver >>>> >>>> >>>> >>>> -- >>>>> -JT >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> -JT >>> >>> >>> >> > > > -- > -JT > > >

1 0

Re: Gofer for GlorpDBX
by Mariano Martinez Peck 10 Jan '10

10 Jan '10

On Sat, Jan 9, 2010 at 11:24 PM, John Toohey <jt(a)parspro.com> wrote: > Have you made a Gofer script to install the latest GloprDBX and Postgres > driver on the latest RC1 Pharo images? I'm trying to create a full Gofer > script that will build my entire app from a Pharo DEV image. > > Hi John. I didn't wrote any Gofer plugin and I even don't have it in mind. The future of SqueakDBX and GlorpDBX packages managment will be with Metacello. So far, you have in the repository MetacelloRepository in squeakspurce, two packages: ConfigurationOfSqueakDBX and ConfigurationOfGlorpDBX. The second one, right now it install GlorpDBX and the SqueakDBX driver, NOT the PostgreSQL native driver. If this is what you want, maybe I can add a group to metacello conf. Right now, to install SqueakDBX you have to evaluate: Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfSqueakDBX'; load. ((Smalltalk at: #ConfigurationOfSqueakDBX) project version: '1.0') load. And for GlorpDBX: Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfGlorpDBX'; load. ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load. If you really need to load GlorpDBX with Postgresql native driver, than I can create a group so that you will be able to evaluate: ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load: 'GlorpDBXWithNativePostgreSQLNativeDriver' Do you need that? In addition, the loaders we wrote some time ago, should be running: Gofer new squeaksource: 'Glorp'; package: 'ConfigurationOfGlorpDBX'; load. GlorpPharoLoader loadGlorpWithNativePostgreSQLDriver -- > -JT > > >

2 2

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX January 2010