SqueakDBX June 2011

squeakdbx@lists.squeakfoundation.org

9 participants
25 discussions

Re: [Pharo-users] Fwd: Faster That light
by Mariano Martinez Peck 23 Jun '11

23 Jun '11

I have worked the last days on a generic connection pool for Pharo. The > objective is to improve performances for an application that uses a network > data source (databases, LDAP, etc.). > > Hi Olivier. First, let me say that we really appreciate your project and we are happy with it :) Now, to avoid reinventing the wheel, I want to point you some stuff. 1) There is a GlorpDBX connection pool available. This is the package GlorpDBX-ConnectionPool. Documentation: http://www.squeakdbx.org/documentation/SqueakDBX%20connection%20pool%20for%… 2) There is a general purpose pool (for any kind of object) that also work in Glorp or DBXTalk. http://www.squeaksource.com/ObjectPool There is a package ObjectPool-GlorpDBX :) I cc'ed Panu, the developer. So...maybe you can join forces with him? > My work is now stable and the gain of performances is good. For exemple, I > have a benchmark that uses a SqueakDBX/PostgreSQL database and a LDAP > directory. Without the pool, the test take 6,61s, with the pool, only 0,367s > :-) > > I have made many stress tests for testing the fiability. This morning, the > connection pools has processed 270000 requests without problems. > > I think that my project can interest you. > > sure it does!!! > I don't know if the code is ready for production. > > It doesn't matter. It is good to know about it. > > The projet is on squeaksource and I have added your account (and Stef also) > as Guest. > > MCHttpRepository > location: 'http://www.squeaksource.com/FasterThatLight' > user: '' > password: '' > > Thanks for remarks and critics. > > Thanks. I will take a look. For the pools, the expert is Diogenes and Panu :) Best regards, -- Mariano http://marianopeck.wordpress.com

1 0

SQLite, DBX y select en el from
by Guillermo Polito 22 Jun '11

22 Jun '11

Aloha, estoy teniendo un problemita con SQLite y DBX. En primer lugar, no se porque no pasa en las otras bases, es algo a mirar quizas... Bueno, lo que pasa es que Glorp quiere tirar un query así (cuando tiene un mapeo de una herencia): SELECT * FROM (SELECT t2.ID, t2.NAME, t2.SERIAL_NUMBER, NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, NULL AS t5nullField4 FROM NONPERISHABLE_ITEM t2, WAREHOUSE_ITEM_LINK t3 WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1 UNION ALL SELECT NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, t2.ID, t2.NAME, t2.AGE, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, NULL AS t5nullField4 FROM PERISHABLE_ITEM t2, WAREHOUSE_ITEM_LINK t3 WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1 UNION ALL SELECT NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, t2.ID, t2.NAME, t2.SERIAL_NUMBER, t2.ASSEM_COST FROM UNASSEMBLED_ITEM t2, WAREHOUSE_ITEM_LINK t3 WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1) t2 Y eso hace que OpenDBX devuelva como Description del query esto: an OrderedCollection( ('ID':Number) ('NAME':String) ('SERIAL_NUMBER':Number) ('t4nullField1':a DBXTypeNotSupported) ('t4nullField2':a DBXTypeNotSupported) ('t4nullField3':a DBXTypeNotSupported) ('t5nullField1':a DBXTypeNotSupported) ('t5nullField2':a DBXTypeNotSupported) ('t5nullField3':a DBXTypeNotSupported) ('t5nullField4':a DBXTypeNotSupported)) Porque evidentemente para definir los tipos del resultset, esta usando solo la primera row parece. ¿Bug de openDBX no? -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

2 4

Re: [SqueakDBX] Re: Los mails de commits de SS no llegan a la lista
by Mariano Martinez Peck 13 Jun '11

13 Jun '11

Excellent!!! Thanks Alan. Please ask if you have questions. Guillermo can also help you with that list :) On Mon, Jun 13, 2011 at 3:27 PM, Alan Knight <knight(a)acm.org> wrote: > Oh, I should also mention that I did manage to import Guillermo's code > into Store and do a comparison against the base Glorp and had (barely) > started looking at the differences, so I should have some feedback/questions > in the next little while. > > ------------------------------ > > Alan Knight <knight(a)acm.org> > June 13, 2011 8:47 AM > > > So now I'm getting emails for proyecto_relacional, but I can't post. Google > still says it doesn't exist. > > For the platforms in Glorp, Adabas and SAPDB are something someone did a > long time and aren't really supported. Niall Ross sort of maintains > Firebird. I think I did Ocelot myself a long time ago, and its main good > thing is that it's very standards-compliant. Access works in VisualWorks, > but these days the Access you get from Microsoft is really just SQL Server > lite, and SQLite does a better job on the role that Access used to provide. > The important platforms are Postgresql, SQLite, MySQL, Oracle, and SQL > Server. Current versions in VisualWorks also have DB2. > > -- Mariano http://marianopeck.wordpress.com

1 0

DBXTalk: Smalltalk Relational Database Suite: Glorp-GuillermoPolito.75.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Guillermo Polito uploaded a new version of Glorp to project DBXTalk: Smalltalk Relational Database Suite: http://www.squeaksource.com/DBXTalk/Glorp-GuillermoPolito.75.mcz ==================== Summary ==================== Name: Glorp-GuillermoPolito.75 Author: GuillermoPolito Time: 13 June 2011, 5:23:13 am UUID: 85478413-2a21-4ca1-aecd-cbad4be4b4d7 Ancestors: Glorp-GuillermoPolito.74 fixed getting last insert id value in sqlite -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 0

DBXTalk: Smalltalk Relational Database Suite: OpenDBXDriver-GuillermoPolito.16.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Guillermo Polito uploaded a new version of OpenDBXDriver to project DBXTalk: Smalltalk Relational Database Suite: http://www.squeaksource.com/DBXTalk/OpenDBXDriver-GuillermoPolito.16.mcz ==================== Summary ==================== Name: OpenDBXDriver-GuillermoPolito.16 Author: GuillermoPolito Time: 13 June 2011, 5:12:54 am UUID: f619f8e1-2928-4caa-a086-ccfc294c4675 Ancestors: OpenDBXDriver-MarianoMartinezPeck.15 little fix for sqlite backend which was using a nil timeout value -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 0

DBXTalk: Smalltalk Relational Database Suite: GlorpTests-GuillermoPolito.23.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Guillermo Polito uploaded a new version of GlorpTests to project DBXTalk: Smalltalk Relational Database Suite: http://www.squeaksource.com/DBXTalk/GlorpTests-GuillermoPolito.23.mcz ==================== Summary ==================== Name: GlorpTests-GuillermoPolito.23 Author: GuillermoPolito Time: 13 June 2011, 5:10:46 am UUID: 67698c9d-080e-43de-84bf-cab5275ef645 Ancestors: GlorpTests-GuillermoPolito.22 some little test fixes -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 0

DBXTalk: Smalltalk Relational Database Suite: GlorpOpenDBXDriver-GuillermoPolito.11.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Guillermo Polito uploaded a new version of GlorpOpenDBXDriver to project DBXTalk: Smalltalk Relational Database Suite: http://www.squeaksource.com/DBXTalk/GlorpOpenDBXDriver-GuillermoPolito.11.m… ==================== Summary ==================== Name: GlorpOpenDBXDriver-GuillermoPolito.11 Author: GuillermoPolito Time: 13 June 2011, 5:08:25 am UUID: 35f7a144-1a23-4554-b989-afee666a4a96 Ancestors: GlorpOpenDBXDriver-GuillermoPolito.10 added sqlite backend -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 0

DBXTalk: Smalltalk Relational Database Suite: Glorp-GuillermoPolito.74.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Guillermo Polito uploaded a new version of Glorp to project DBXTalk: Smalltalk Relational Database Suite: http://www.squeaksource.com/DBXTalk/Glorp-GuillermoPolito.74.mcz ==================== Summary ==================== Name: Glorp-GuillermoPolito.74 Author: GuillermoPolito Time: 13 June 2011, 5:02:28 am UUID: 48edeb11-207a-4498-a937-26746d6d20e4 Ancestors: Glorp-GuillermoPolito.73 removed bindings from sqlite since glorp does not support them well yet. It works now =) -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 0

Sabian que glorp "soporta" querys bindeables pero en ralidad no anda? :D
by Guillermo Polito 13 Jun '11

13 Jun '11

Tratando de hacer andar glorp con sqlite, me di cuenta que los statements que prepara en algunos casos (cuando la base soporta bindings) tienen esta forma: insert into tabla values (*?*,*?*,*?*) Pero nunca le pasa el array para los bindings! Por ende el insert nunca funciona, y nunca explota y nada ¬¬ Además, glorp soporta queries de la forma (segun sus tests) self accessor executeSQLString: 'SELECT * FROM STUFF WHERE ID = :2 OR ID = :17' binding: #(nil 10 nil nil nil nil nil nil nil nil nil nil nil nil nil nil 20). Lo cual no es consistente :D -- You received this message because you are subscribed to the Google Groups "proyecto_relacional" group. To post to this group, send email to proyecto_relacional(a)googlegroups.com. To unsubscribe from this group, send email to proyecto_relacional+unsubscribe(a)googlegroups.com. For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.

1 2

SqueakDBX: SQueakLite-UI-GiselaDecuzzi.101.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 13 Jun '11

13 Jun '11

Gisela Decuzzi uploaded a new version of SQueakLite-UI to project SqueakDBX: http://www.squeaksource.com/SqueakDBX/SQueakLite-UI-GiselaDecuzzi.101.mcz ==================== Summary ==================== Name: SQueakLite-UI-GiselaDecuzzi.101 Author: GiselaDecuzzi Time: 12 June 2011, 7:33:09 pm UUID: f750d18a-7df1-47b0-bfb3-200ad9c7712c Ancestors: SQueakLite-UI-GiselaDecuzzi.100 refactors suggestions, possible bugs

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX June 2011