SqueakDBX September 2010

squeakdbx@lists.squeakfoundation.org

3 participants
5 discussions

Re: [SqueakDBX] Character encoding and pooling in SqueakDBX and Glorp
by Mariano Martinez Peck 22 Oct '10

22 Oct '10

On Fri, Aug 27, 2010 at 8:10 AM, Panu Suominen <panu.j.m.suominen(a)gmail.com>wrote: > Thank you for excelent feedback. > thanks for your changes :) > > 2010/8/26 Mariano Martinez Peck <marianopeck(a)gmail.com>: > > - I guess a lot of people doesn't need UTF (or other) encoding. And I > guess > > that the transformation brings some overhead in the query result > mosty...(I > > should run the benchmarks and see if there is difference). But I was > > thinking if we could make this optional. > > I was thinking that too. Apparently no encoding means that only 7bit > characters should be used? > > I am totally newbie with encoding. I have no idea about how many bits hahah. The only thing I would like is that with "no encoding" I do what we were doing until this change. > > or something like that....but the idea of making it optional not to have > > overhead if not required, and being able to be enabled from the app code. > > This probably need some thinking. Because if one uses database through > GLORP the encoding parameter should be passed somehow to lower levels. > Yes, I saw this after sending all the emails :( > Would the ConnectionSettings in SqueakDBX level be right place? ahhhh yes, I forgot about ConnectionSettings :) That sounds more reasonable than Connection. FOr all your changes and comments it seems you understood SqueakDBX quite well and fast heheh > And in > Glorp I think the platform level seems to be good. Then in Glorp one > could express > (Login new) > database: (PostgreSQLPlatform withEncoding: #utf8); > username: 'yyyyy'; > password: 'xxxx'; > connectString: 'host' , '_' , 'database' > > (PostgreSQLPlatform withEncoding: #utf8) would be short cut for > (PostgreSQLPlatform new encoding: #utf8). > > > > maybe we can just set again the NullEncoder in that case? or raise an > error ? what do you think? > > Yep, error checking code was not up to the task in the first try. > Probably raise an error. Espesially if user has decided to use > encoding (and data needs it). If > code would continue silently with NullEncoder the data read would be > corrupted. > > I agree. Raise an error with a really clear message. I would like to add tests for this encoding stuff, if it makes sense. I try to keep tests updated and trying to cover most of the features. > > > Ok.... I run the benchmarks and I was rigth > > If I understood correctly berformance dropped over 10%. It is quite > much. Have to see if that could be improved. > If you want, you can try it by yourself: http://www.squeakdbx.org/Benchmarks Easy, evaluate:* DBXBenchmark* facility: *DBXPostgreFacility* facilityForBenchmark. *DBXTinyBenchmarks* new runAll. > > > In addition, if someone has its own database using a particular encoding, > and doesn't implement openConnection (that does the query, like you did in > postgres) because he doesn't knwo, this > > will be a problem beasue the database will have an encoding X and you > will be encoding always with UTF8 ;) > > This is a problem. However I do feel that encoding should be checked > when database is connected (at least when user has selected that > encoding should be used). > yes, but only when the user has selected encoded > Also endocoding should be property of the connection. If it would be > class variable it would be impractical to connect to different > databases with different encoding. > > you are right, sorry about that. > I think one possibility to takle these problems would be > EncoderFactory user passes to the code. This factory would set encoder > in connection but weren't we going to put it in connectionSettings? > based either on the database query > or by preselected value. The query option would ask the connection > about encoding (using message encodingName or something like that). If > connection cant > handle the message then exception is raised (user chosed to > automatically select encoding in setting where code is not up to the > task). > > The preselected option would just set right encoder to the connection. > I think that validation of this choice should be skipped because it > would render this option to be basically the same than the automatic > option. Preselected encoding could be NullEncoder. > > Uhh sorry, you lost me in this last paragraph. Maybe if I see the code I understand better : > If this sound sensible I will try to implement the changes in the > weekend but cant promise I have the time. :) > > That would be cool, but don't worry, no stress. BTW...just by curious. where/why are you trying to use SqueakDBX? cheers mariano

3 24

Fwd: Smalltalks 2010 --- Registration and invitation
by Mariano Martinez Peck 24 Sep '10

24 Sep '10

---------- Forwarded message ---------- From: Andres Valloud <avalloud(a)smalltalk.comcastbiz.net> Date: 2010/9/24 Subject: Smalltalks 2010 --- Registration and invitation To: "pbe-spanish-group(a)googlegroups.com" <pbe-spanish-group(a)googlegroups.com > ======== INGLES The Fundación Argentina de Smalltalk (FAST) invites you to the 4th Smalltalk Conference of Argentina, to be held on November 11, 12 and 13, 2010 at the Concepción del Uruguay site of the Universidad Tecnológica Nacional. Everyone, including teachers, students, researchers, developers and entrepreneurs, are welcome as speakers or attendees. Registration is free and now open athttp://www.fast.org.ar. The goal of the conference is to strengthen the Argentine and international Smalltalk community through the exchange of works, experiences and anecdotes connected with this technology or related matters. Renowned members of the international Smalltalk community will visit the conference. Moreover, this edition of the conference will have a Research Session with publications reviewed by an international committee, as well as an Industry Track for those preferring a more relaxed environment. We look forward to see your submissions. You can propose papers or talks know through our website, or by sending an email toinfo(a)fast.org.ar. See you there! ======== SPANISH La Fundación Argentina de Smalltalk (FAST) los invita a la 4ta Conferencia de Smalltalk de Argentina, a realizarse desde el 11 al 13 de Noviembre del 2010 en la sede de Concepción del Uruguay de la Universidad Tecnológica Nacional. Esperamos verlos a todos entre la audiencia o como oradores, ya sean profesores, estudiantes, investigadores, desarrolladores o empresarios. La registración es gratis y está disponible enhttp://www.fast.org.ar. El objetivo de la conferencia es afianzar los vínculos entre las comunidades Smalltalk de Argentina y del mundo, a través del intercambio de trabajos, experiencias y vivencias conectadas con esta tecnología. De hecho, este año nos visitarán personalidades de renombre de la comunidad internacional. Además, en esta edición de la conferencia tendremos un track de investigación formal con publicaciones y referato de un comité internacional. También tendremos un track de industria para aquellos que prefieran un ambiente más informal. Pueden enviarnos sus propuestas de charlas o papers mediante nuestra página web, o enviándonos un mail ainfo(a)fast.org.ar. Nos vemos en la conferencia!

1 0

We will be in ESUG
by Mariano Martinez Peck 11 Sep '10

11 Sep '10

Esteban and I are going to be at ESUG (http://www.esug.org/Conferences/2010) next week (I think Esteban has already arrived). If you want to discuss or ask something about SqueakDBX/GlorpDBX you are welcome to do it :) Cheers Mariano

1 0

Re: [squeak-dev] How to install Glorp
by Mariano Martinez Peck 09 Sep '10

09 Sep '10

In pharo: Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfGlorpDBX'; load. and then (ConfigurationOfGlorpDBX project version: '1.2') load will install SqueakDBX as the database driver and Glorp-SqueakDBXDriver (ConfigurationOfGlorpDBX project version: '1.2') load: 'GlorpSqueakDBX Pool' will install SqueakDBX as the database driver and a Glorp-SqueakDBXDriver that acts as a connection pool :) (altought this only works in 1.0 right now) (ConfigurationOfGlorpDBX project version: '1.2') load: 'All with PostgreSQL native' will install the native postgresql driver Cheers Mariano BTW: you can find more info here (but it is outdated): http://www.squeakdbx.org/GLORP%20integration On Thu, Sep 9, 2010 at 12:19 AM, Germán Arduino <garduino(a)gmail.com> wrote: > Hi Squeakers and Pharoers: > > Even when I saw several mails about the topic, I failed to install > Glorp properly, on Squeak (4.1) and also on Pharo (4.1). > > No matter what method I try, or which Glorp .mcz, I allways get the > attached error, referencing some weird oracle thing. > > I'm new to Glorp, I might be forgetting something obvious, but in any > case, any help is appreciated > > Thanks. > > > -- > ================================================= > Germán S. Arduino <gsa @ arsol.net> Twitter: garduino > Arduino Software & Web Hosting http://www.arduinosoftware.com > PasswordsPro http://www.passwordspro.com > ================================================= > > > >

1 0

[ANN] SqueakDBX 1.2 release
by Mariano Martinez Peck 03 Sep '10

03 Sep '10

Hi folks. We are realeasing SqueakDBX 1.2, just an small release. For those who doesn't know, SqueakDBX is a database driver to connect to most of the existing databases. For more details, please read www.squeakdbx.org The main changes in this release are: - ConfigurationOfSqueakDBX version: 1.2 - Comments: SqueakDBX stable 1.2 - OpenDBX version: 1.5 - New Features - GlorpDBX connection pool for SqueakDBXDriver. Thanks to John Toohey for this contribution. - New support for Firebird 100% green tests in Windows. - New support for MySQL 4. - New tests for PostgreSQL sequences, for bad data settings, large objects, etc. - We now let a platform to set special options ALWAYS before opening the connection. - Packages remodularization and little changes so that to easily support ports, for example to Dolphin. - Start to support large objects. For the moment: Postgresql supports TEXT, MySQL supports TEXT and BLOB, and SQLite CLOB (error with BLOB), Oracle supports CLOB and NCLOB. - Added the possibility to enable or disable automatic release of connections using WeakRegistry. - Notes - Tested with Cog, resulting in an average of 3x increase and 100% green. - Tested in Pharo 1.0 and 1.1. - Updated Metacello configurations To install it: Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfSqueakDBX'; load. (ConfigurationOfSqueakDBX project version: '1.2') load. In Pharo 1.1 I recommend to evaluate the following: DBXPlatform disableAutomaticConnectionReleaseOnGC Cheers Mariano

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX September 2010