Re: [Pharo-users] Garage

Thanks Sven. Lol - that's a brave new world for me. I have just been a lazy consumer to date! I will attempt to dip a toe into the community proper -- Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html

Re: [Pharo-users] Garage

Jeff, > On 15 Aug 2019, at 23:36, Jeff Gray wrote: > > Is anyone maintaining garage? I get some errors in Pharo 7, which I have > patched as I have needed to. Looked in the GitHub repository and last update > was back in September. Garage is a community project with no particular maintainer. Th

[Pharo-users] Garage

Is anyone maintaining garage? I get some errors in Pharo 7, which I have patched as I have needed to. Looked in the GitHub repository and last update was back in September. -- Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html

Re: [Pharo-users] Garage sqlite on pharo > 5

I know this is me that paid Guillermo to develop Garage and it was not for us but for the community. And Guillermo made sure that we can tests all drivers on Jenkins. Stef Why declare that as dead? It is there and is okay to use. People can update it if needed. Why say this? That's not co

Re: [Pharo-users] Garage sqlite on pharo > 5

Why declare that as dead? It is there and is okay to use. People can update it if needed. Why say this? That's not constructive, man. We need DB access. Pharo without DB access is going nowhere in the industry. Just had a pairing session w/ Doru and guess what? The data I need for Moose/Roassa

Re: [Pharo-users] Garage sqlite on pharo > 5

Guillermo created Garage because the consortium asked and payed him to do and I think that he did it well. Now Guillermo does not use any database during his development and he is busy to work on many important tasks for Pharo. I will ask Guillermo to declare Garage as dead and people should n

Re: [Pharo-users] Garage sqlite on pharo > 5

2016-10-17 8:12 GMT-03:00 Norbert Hartl : > Does anyone use Garage SQL drivers with sqlite in pharo >= 5? Garage SQLite driver doesn't work on Pharo 5, the FFI API changed and Garage wasn't updated to use UFFI. You have to use Torsten version in UDBC. Gofer it smalltalkhubUser: 'TorstenBe

[Pharo-users] Garage sqlite on pharo > 5

Does anyone use Garage SQL drivers with sqlite in pharo >= 5? thanks, Norbert

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

Pierce! Cheers, Vincent > -Message d'origine- > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part de > Pierce Ng > Envoyé : vendredi 12 août 2016 17:44 > À : Any question about pharo is welcome > Objet : Re: [Pharo-users] [Garage] How to espa

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

On Fri, Aug 12, 2016 at 01:36:21PM +0200, Blondeau Vincent wrote: > > Which database? > Postgres PostgresV2 driver does not support the PostgreSQL extended query protocol which allows prepared statements, AFAIK. https://www.postgresql.org/docs/current/static/protocol-overview.html. As for esc

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

Hi Vincent, I don't know which special characters are you trying to escape, but if simply send printString to the variable, it will escape any quote that would end the string literal. | variable statement | variable := 'Pharo''s O''Reilly book'. statement := 'SELECT ', variable printString. Trans

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

> On 12 Aug 2016, at 13:36, Blondeau Vincent > wrote: > > > I think that ' close the EXECUTE query and is not escaped by garage. you are right. The statement is very sub-optimal (but should be easy to fix). "If not it means by the moment that we are a named prepared statement and w

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

> -Message d'origine- > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part de > Holger Freyther > Envoyé : vendredi 12 août 2016 13:22 > À : Any question about pharo is welcome > Objet : Re: [Pharo-users] [Garage] How to espace sql special chars

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

> On 12 Aug 2016, at 12:10, Blondeau Vincent > wrote: > > BTW, even with prepared statements, it doesn't work either: > SQL query : EXECUTE preparedStmtd2qbaa1ap7ceiaq643sxlkyyw('Quand > l'utilisateur est connecté sur "son serveur"', '1277') > -> 'ERREUR: erreur de syntaxe sur ou près de « ut

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

actère 56' (Syntax error near char 56) Vincent > -Message d'origine- > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part de > Holger Freyther > Envoyé : vendredi 12 août 2016 10:45 > À : Any question about pharo is welcome > Objet : Re: [

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

ût 2016 10:45 > À : Any question about pharo is welcome > Objet : Re: [Pharo-users] [Garage] How to espace sql special chars in a query? > > > > On 12 Aug 2016, at 10:34, Blondeau Vincent > wrote: > > > > Hello, > > Hi > > > > I am looking for a met

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

> On 12 Aug 2016, at 10:34, Blondeau Vincent > wrote: > > Hello, Hi > I am looking for a method that escape special characters for SQL queries. > E.g.: I want to escape : ‘ in a where expression: ‘….Where field1 = ‘’‘, > myvariable , ‘‘’ …..’ with myvariable := ‘don’’t do’. > I am using ga

[Pharo-users] [Garage] How to espace sql special chars in a query?

Hello, I am looking for a method that escape special characters for SQL queries. E.g.: I want to escape : ' in a where expression: 'Where field1 = ''', myvariable , ''' .' with myvariable := 'don''t do'. I am using garage and haven't found it in the package. Does someone know where I can

Re: [Pharo-users] Garage and VoyageMongo Pharo5 versions for the MOOC

> On 01 Mar 2016, at 18:14, Luc Fabresse wrote: > > Hi Guys, > > I am trying to prepare a ConfigurationOfPharoWeb for the MOOC on Pharo5. > > So I would be really greatful to have some help ;-) > > - Garage does not seem to load properly in Pharo 5. > > - VoyageMongo does not have a Pharo5 v

[Pharo-users] Garage and VoyageMongo Pharo5 versions for the MOOC

Hi Guys, I am trying to prepare a ConfigurationOfPharoWeb for the MOOC on Pharo5. So I would be really greatful to have some help ;-) - Garage does not seem to load properly in Pharo 5. - VoyageMongo does not have a Pharo5 version nor a ConfigOf in the MetaRepoForPharo5 Thanks #Luc

[Pharo-users] Garage with oracle

Does anyone use Garage with an oracle database? Maybe someone that develops on Mac OS? I would be interested in the best way to compile and install libraries in order to use it from pharo. Norbert

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

On 04/08/15 16:25, Guillermo Polito wrote: > Helloo :) > > First Tomasso, it's nice to know it's working well for you :). We need > feedback and contributions, even the smallests (like docs, or blogposts > with your experiences or tutorials). > > Answering your question, GarageGlorp does no

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

Thanks Guillermo, we were struggling with all these names also. This reference is important, and IMHO it should be pasted also in the page of every DB related project, so that we can have a map and now where we are. best arturo On Tue, Aug 4, 2015 at 11:25 AM, Guillermo Polito wrote: > *OpenDBX

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

Helloo :) First Tomasso, it's nice to know it's working well for you :). We need feedback and contributions, even the smallests (like docs, or blogposts with your experiences or tutorials). Answering your question, GarageGlorp does not yet use the cursors from the Garage drivers. I do not kno

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

2015-08-03 16:20 GMT-03:00 Esteban Lorenzano : > yes… just that is not accurate :) > is basically like that, just that DBXTalk is not a driver, is an umbrella > project. The OpenDBX drivers is still called OpenDBXDriver :P TooManyAbstractionsException signal. ;) Esteban A. Maringolo

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

yes… just that is not accurate :) is basically like that, just that DBXTalk is not a driver, is an umbrella project. The OpenDBX drivers is still called OpenDBXDriver :P Esteban > On 03 Aug 2015, at 20:55, Sean P. DeNigris wrote: > > Esteban A. Maringolo wrote >> Garage is... > > Thank you! V

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

Esteban A. Maringolo wrote > Garage is... Thank you! Very helpful. It seems like this would be a great clarification to add to http://guillep.github.io/DBXTalk/ , no? - Cheers, Sean -- View this message in context: http://forum.world.st/Garage-Glorp-PostgreSQL-and-Cursors-tp4840760p4840827

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

Garage is a (IMO lousy named) Pharo database interface abstraction, like Perl's DBI, ADODB, or JDBC. Any program that uses Garage's objects to access the database should be abstract enough to enable you to replace the backend by something else without changing the programming logic (e.g. replace Po

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

> On 03 Aug 2015, at 15:35, Sean P. DeNigris wrote: > > vmusulainen wrote >> http://pharo.org/news/garage-database > > I'm also confused. What is the relationship between OpenDBX and Garage? IIRC > DBXTalk was the previous name of OpenDBX, right? Maybe an FAQ is in order as > the DB-related nam

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

vmusulainen wrote > http://pharo.org/news/garage-database I'm also confused. What is the relationship between OpenDBX and Garage? IIRC DBXTalk was the previous name of OpenDBX, right? Maybe an FAQ is in order as the DB-related names seem to be multiplying ;) - Cheers, Sean -- View this mess

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

> Am 03.08.2015 um 15:11 schrieb Юрий Мироненко : > > I'm little bit shy, but what is Garage? http://pharo.org/news/garage-database Norbert > > 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso >: > Hello, > > I was tryin

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

> I'm little bit shy, but what is Garage? Good question! Alexandre > > 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso >: > Hello, > > I was trying the version of Glorp ported to Garage, and I must say it > runs smoothly, nice job! > > I am reading large amou

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

I'm little bit shy, but what is Garage? 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso : > Hello, > > I was trying the version of Glorp ported to Garage, and I must say it > runs smoothly, nice job! > > I am reading large amount of data from a Postgres db, and I was curious > about the use of curso

[Pharo-users] Garage, Glorp, PostgreSQL and Cursors

Hello, I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job! I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has thi

Re: [Pharo-users] Garage and SQLite file databases, general project structure

On Mon, May 18, 2015 at 4:48 PM, Guillermo Polito wrote: > I wanted in general to have a single easy-to-learn way to build a database > connection string for all drivers. > > [driverid]://[host][:port]/[databasename]?[properties] > > I bumped into an interesting app "SQL Workbench/J" [1] that l

Re: [Pharo-users] Garage and SQLite file databases, general project structure

On Tue, May 19, 2015 at 10:49 PM, Sven Van Caekenberghe wrote: > > > I made the following commits: > This does not change the current default behaviour, but it makes it a lot > easier to work with relative references: > Cool. Now just a passing thought. The original term URL is from RFC1738, wh

Re: [Pharo-users] Garage and SQLite file databases, general project structure

Ben, (comments inline) > On 18 May 2015, at 17:46, Ben Coman wrote: > > > > On Mon, May 18, 2015 at 7:06 PM, Sven Van Caekenberghe wrote: > > > On 18 May 2015, at 12:13, Guillermo Polito > > wrote: > > > > Hi Sven, I'll take that into account. I did not think about using an empty > > hos

Re: [Pharo-users] Garage and SQLite file databases, general project structure

On Mon, May 18, 2015 at 7:06 PM, Sven Van Caekenberghe wrote: > > > On 18 May 2015, at 12:13, Guillermo Polito > wrote: > > > > Hi Sven, I'll take that into account. I did not think about using an > empty host/port pair, maybe because of the extra slash. > > > > Also, I do not need to convert th

Re: [Pharo-users] Garage and SQLite file databases, general project structure

> On 18 May 2015, at 12:13, Guillermo Polito wrote: > > Hi Sven, I'll take that into account. I did not think about using an empty > host/port pair, maybe because of the extra slash. > > Also, I do not need to convert the file name to a file reference. That is > done in sqlite by the sqlite l

Re: [Pharo-users] Garage and SQLite file databases, general project structure

Hi Sven, I'll take that into account. I did not think about using an empty host/port pair, maybe because of the extra slash. Also, I do not need to convert the file name to a file reference. That is done in sqlite by the sqlite library itself, so it's less work for the driver. The only need I need

Re: [Pharo-users] Garage and SQLite file databases, general project structure

Hi Guile, > On 18 May 2015, at 10:48, Guillermo Polito wrote: > > Well, I wanted in general to have a single easy-to-learn way to build a > database connection string for all drivers. > > [driverid]://[host][:port]/[databasename]?[properties] > > Then, for sqlite I would like to have: > > sq

Re: [Pharo-users] Garage and SQLite file databases, general project structure

Hi Pierce, El sáb., 16 de may. de 2015 a la(s) 10:52 a. m., Pierce Ng < pie...@samadhiweb.com> escribió: > On Tue, May 12, 2015 at 08:35:23PM +0200, Torsten Bergmann wrote: > > Also I do not understand: while "Garage-Postgres" uses the Postgres > > project PostgresV2 as a backend the "Garage-Sql

Re: [Pharo-users] Garage and SQLite file databases, general project structure

Hi Torsten, Thanks for taking a look, I'll answer between lines :). El mar., 12 de may. de 2015 a la(s) 8:35 p. m., Torsten Bergmann < asta...@gmx.de> escribió: > Hi Guille, > > I had a short look at Garage [1]. Nice initiative! > > Looks like using a file is not supported for the SQLite3 backen

Re: [Pharo-users] Garage and SQLite file databases, general project structure

On Tue, May 12, 2015 at 08:35:23PM +0200, Torsten Bergmann wrote: > Also I do not understand: while "Garage-Postgres" uses the Postgres > project PostgresV2 as a backend the "Garage-Sqlite3" does not use > NBSqlite3 or SQlite3 projects as backend. > > So "GASqlite3FFI" copies many methods of the

[Pharo-users] Garage and SQLite file databases, general project structure

Hi Guille, I had a short look at Garage [1]. Nice initiative! Looks like using a file is not supported for the SQLite3 backend in Garage: GADriver fromConnectionString: 'sqlite3://file://C:/temp/test.db' GADriver fromConnectionString: 'sqlite3://C:/temp/test.db' Maybe GASqlite3Driver>>