SqueakDBX March 2011

squeakdbx@lists.squeakfoundation.org

13 participants
17 discussions

Installing on Windows with MSSql backend was Re: [Esug-list] [ANN] ESUG supports once again SqueakDBX
by Miguel Sanchez 10 Apr '11

10 Apr '11

Many thanks Mariano, copying libsybdb-5.dll to the Pharo directory (along with the precompiled openDBX dll's full listing below.) sorted out the problem with the DLL dialog. libfirebirdbackend-1.dll libmssqlbackend-1.dll libmysqlbackend-1.dll libodbcbackend-1.dll libopendbx-1.dll libopendbxplus-1.dll liboraclebackend-1.dll libpgsqlbackend-1.dll libsqlite3backend-1.dll libsybasebackend-1.dll libsybdb-5.dll However.......When I try to connect to the database (see below) I get thrown into the debugger with the following signal. DBXRecoverableError: RECOVERABLE OpenDBX: Connecting to server failed. | conn connectionSettings | connectionSettings := DBXConnectionSettings host: 'localhost' port: '1433' database: 'LanceNG' userName: 'mike' userPassword: 'mike'. conn := DBXConnection platform: DBXMSSQLPlatform new settings: connectionSettings. conn connect. conn open. It's a little strange that the message occurs on "conn open" and not on "conn connect" (?). I have tested the user from the local MSSQL management Studio and logs in fine and has correct permissions on objects. I have not found a dump or debug log in the Pharo directory. I'll start looking at compiling freetds and opendbx as there may be utilities that will give more meaningful debug info to isolate where the problem lies. Best Regards, Miguel On 4 March 2011 10:39, Mariano Martinez Peck <marianopeck(a)gmail.com> wrote: > Hi. I cc'ed the squeakdbx mailing list because others may help you better > than me. You can register if you want. > > On Fri, Mar 4, 2011 at 10:26 AM, <Mikey.Sanchez(a)gmail.com> wrote: >> >> Buenos dias (tardes?) >> > > jejeje buenos días acá (estoy en Francia ahora) > >> >> That's brilliant news! In enterprise legacy DB's are (still) so often the >> simplest integration point that a functional non-blocking implementation is >> vital. >> >> By coincidence I've been looking at SqueakDBX to interface to a SQLServer >> database for a once off import (for now) using Pharo 1.1.1 one-click. >> and......... I'm having some trouble. >> I installed SqueakDBX and Glorp via metacello. >> Downloaded Windows binaries for openDBX. >> Got a windows dialog when trying to connect that libsybdb-5.dll was >> missing. >> Soooooo when I googled it I came to the conclusion that I need to compile >> either openDBX or freeTDS. However mingw.org seems to be out of action and >> I'm struggling to find alternative installers. >> > > All that is true. Whenever you want to use SqueakDBX you need both: openDBX > library AND the database client library. However, there are already copiled > dll so that you can directly use. > >> >> While googling I saw that you had responded to newbies in the squeakDBX >> mailing list making suggestions. You wouldn't happen to know where I can lay >> my hands on a compiled 32 bit libsybdb-5.dll. It would save me some pain I >> think . > > Sure. I attach. Please rename .xxx to .dll > Now, I wondering if we should upload them for make it easier... > > BTW, these links should help you in case you need to compile: > > http://www.squeakdbx.org/SQL%20Server > http://www.squeakdbx.org/database%20scripts > http://www.squeakdbx.org/SQL%20Server%20for%20Win > >> >> BTW. What is the state of squeakDBX W.R.T. MSSQL at the moment? >> > > It is working. In fact, Diogenes Moreira did a production system using > GLorpDBX + SqueakDBX + MSSQL > > cheers > > mariano > >> >> Many thanks. >> >> >> Miguel Sanchez >> >> >> On Mar 4, 2011 9:40am, Mariano Martinez Peck <marianopeck(a)gmail.com> >> 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 squeakdbx(a)lists.squeakfoundation.org >> > >> > >> > >> > >> > >> > >> > >> > 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. >> > >> > >

4 12

Re: [Pharo-project] PharoCasts with experts
by laurent laffont 29 Mar '11

29 Mar '11

On Mon, Mar 28, 2011 at 9:26 PM, Stéphane Ducasse <stephane.ducasse(a)inria.fr > wrote: > I could you my little application of cards as an example to map to a db. > OK. I have time tomorrow between 12h30 => 14h00. Can we have a 30mn session ? 1 hour ? If tomorrow is not OK, next week I could do in the evening, 20h30 => 22h00, tell me the day. Laurent > > Stef > > On Mar 28, 2011, at 7:46 PM, Mariano Martinez Peck wrote: > > > > > > > On Mon, Mar 28, 2011 at 9:03 AM, laurent laffont < > laurent.laffont(a)gmail.com> wrote: > > Hi, > > > > Actually I'm training remotely a developer on Pharo using Skype and > TeamViewer. This guy records all sessions for its own purpose and I like the > idea. > > > > For PharoCasts I would like to record 30mn to 1 hour sessions (as I know > you don't have time) with an expert who shows us real code, explaining a > framework / programming style / pattern while programming some examples (in > the spirit of PharoCasts, and may be > http://forum.world.st/Screencast-proposition-Watch-someone-read-code-td3244…). > > > > Right now I'm thinking about: > > - Mariano on DBXTalk > > > > Hi Laurent. I will be happy to do one, but I won't have time until 2 > weeks. But after that, I will try. I have NO IDEA how to do an screencast, > but I can try. > > > > I cc'ed the SqueakDBX mailing list since I am all ears to hear what > people want to see about SqueakDBX. In you have something in mind, please > let me know. > > > > - Gary on Polymorph > > - Igor on VM debugging or FFI / NativeBoost (for example interfacing with > http://id3lib.sourceforge.net/ or other lib) > > - Lukas on Magritte or PetitParser > > - Dale on Metacello > > - Nicolas on Iliad > > - Janko on Aida/Web > > > > and all that I forgot ..... I'm sure plenty of people would like their > open-source project to be more known. This may be an opportunity. > > > > > > How to do this: contact me if you wish to do that so we can choose an > hour that match our respective calendars and agree on tools used (skype, > google video chat, vnc, teamviewer, ....) - I will care about video stuff. > Just talk and code :) > > > > > > Anyone ? > > > > > > Laurent Laffont - @lolgzs > > > > Pharo Smalltalk Screencasts: http://www.pharocasts.com/ > > Blog: http://magaloma.blogspot.com/ > > Developer group: http://cara74.seasidehosting.st > > > > > > >

1 0

Re: [Pharo-project] PharoCasts with experts
by Mariano Martinez Peck 29 Mar '11

29 Mar '11

On Mon, Mar 28, 2011 at 9:03 AM, laurent laffont <laurent.laffont(a)gmail.com>wrote: > Hi, > > Actually I'm training remotely a developer on Pharo using Skype and > TeamViewer. This guy records all sessions for its own purpose and I like the > idea. > > For PharoCasts I would like to record 30mn to 1 hour sessions (as I know > you don't have time) with an expert who shows us real code, explaining a > framework / programming style / pattern while programming some examples (in > the spirit of PharoCasts, and may be > http://forum.world.st/Screencast-proposition-Watch-someone-read-code-td3244…). > > Right now I'm thinking about: > - Mariano on DBXTalk > Hi Laurent. I will be happy to do one, but I won't have time until 2 weeks. But after that, I will try. I have NO IDEA how to do an screencast, but I can try. I cc'ed the SqueakDBX mailing list since I am all ears to hear what people want to see about SqueakDBX. In you have something in mind, please let me know. > - Gary on Polymorph > - Igor on VM debugging or FFI / NativeBoost (for example interfacing with > http://id3lib.sourceforge.net/ or other lib) > - Lukas on Magritte or PetitParser > - Dale on Metacello > - Nicolas on Iliad > - Janko on Aida/Web > > and all that I forgot ..... I'm sure plenty of people would like their > open-source project to be more known. This may be an opportunity. > > > How to do this: contact me if you wish to do that so we can choose an hour > that match our respective calendars and agree on tools used (skype, google > video chat, vnc, teamviewer, ....) - I will care about video stuff. Just > talk and code :) > > > Anyone ? > > > Laurent Laffont - @lolgzs <http://twitter.com/#%21/lolgzs> > > Pharo Smalltalk Screencasts: http://www.pharocasts.com/ > Blog: http://magaloma.blogspot.com/ > Developer group: http://cara74.seasidehosting.st > >

2 3

SqueakDBX: ConfigurationOfGlorpDBX-Mariano.32.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 26 Mar '11

26 Mar '11

Mariano Martínez Peck uploaded a new version of ConfigurationOfGlorpDBX to project SqueakDBX: http://www.squeaksource.com/SqueakDBX/ConfigurationOfGlorpDBX-Mariano.32.mcz ==================== Summary ==================== Name: ConfigurationOfGlorpDBX-Mariano.32 Author: Mariano Time: 25 March 2011, 11:12:49 pm UUID: 89d39c32-6d18-493a-bb6a-ae15df562307 Ancestors: ConfigurationOfGlorpDBX-Mariano.31 release 1.4 for squeak

1 0

Issue 1 in dbxtalk: Tests should be split into a separate package
by dbxtalk＠googlecode.com 25 Mar '11

25 Mar '11

Status: Accepted Owner: marianopeck Labels: Type-Defect Priority-Medium New issue 1 by marianopeck: Tests should be split into a separate package http://code.google.com/p/dbxtalk/issues/detail?id=1 And we should take care so that not to use '-' and confuse Monticello so that it thinks it is a subcategory. Once we split this, Metacello configuration should be updated also so that it supports different groups

2 1

New port to Pharo
by Mariano Martinez Peck 21 Mar '11

21 Mar '11

Hi Alan. There is a new group of people for SqueakDBX (now renamed to DBXTalk) which will try to do a new port of Glorp to Pharo. I have some questions about that: 1) DBXTalk is/will be much more than just a binding to OpenDBX and that Glorp. We want to build several tools on top of that, included Glorp. All our work is MIT, and having Glorp also would be AWESOME. Please let us know the status about Glorp's License. I think the community will also love that. 2) If we start with the port, we would like to start from the last stable version of it. Which one is it ? 3) Any advice / suggestion about the port? all packages are mandatory ? Thanks a lot in advance, Mariano

2 1

Fwd: [SqueakDBX] Problems
by Guillermo Polito 20 Mar '11

20 Mar '11

---------- Forwarded message ---------- From: Benoit St-Jean <bstjean(a)yahoo.com> Date: Sat, Mar 19, 2011 at 2:29 PM Subject: Re: [SqueakDBX] Problems To: Guillermo Polito <guillermopolito(a)gmail.com> Hi Guillermo, Since I'm doing lots of stuff using Smalltalk and a plethora of databases, I'd be willing to help you guys with SqueakDBX & Glorp. I'm mostly working on Windows now (WinXP) but I have SQL Server, MS-Access, SQLite, Firebird, MySQL, InterBase & PostgreSQL database servers currently installed and running. I can also test Oracle & DB/2 if needed, all this on Windows of course. If you need to test ports of SqueakDBX, I have many versions of Squeak, Pharo and VisualWorks installed as well as Dolphin, ObjectStudio & VisualAge. Even an old VSE environment that I sometimes fire up to soothe my nostalgic side! :) Anyhow, I've been working exclusively with Smalltalk for the last 20 years and used to be working with Glorp's parent, TOPLink. As a matter of fact, my current employer is still using TOPLink with VisualAge & VisualWorks. If I can be of any help, let me know. P.S. I have been thinking, for a long time, about creating a *real-world* database model to seriously test database-related Smalltalk projects/packages/apps. I've always had the impression that testing against a 1000 records table ain't telling you much about how the app/package/project will behave in reality. I could create a real "benchmark" that could be used across multiple databases in not much time if needed. In fact, most of the stuff I do (I'm working on my own OO-RDBMS mapping framework) is tested against millions of records because I've decided, upfront, that I would not put performance aside at the start. My framework ain't as "intelligent" and transparent as Glorp but it's fast, simple and lightweight. And I know how it will behave when faced with millions of records, with queries using 5-6 LEFT JOINs, subqueries, etc. I think SqueakDBX & Glorp would benefit being "debugged" against some "real world" data & volume if we ever consider using those tools in a work environment and get passed the "hobby" project. What do you think? See my favorite headache these days... :) http://myfavoriteheadache.wordpress.com/ ----------------- Benoit St-Jean Yahoo! Messenger: bstjean A standpoint is an intellectual horizon of radius zero. (Albert Einstein)

2 2

SqueakDBX: OpenDBX-Core-GuillermoPolito.283.mcz
by squeak-dev-noreply＠lists.squeakfoundation.org 19 Mar '11

19 Mar '11

A new version of OpenDBX-Core was added to project SqueakDBX: http://www.squeaksource.com/SqueakDBX/OpenDBX-Core-GuillermoPolito.283.mcz ==================== Summary ==================== Name: OpenDBX-Core-GuillermoPolito.283 Author: GuillermoPolito Time: 19 March 2011, 2:31:57 pm UUID: 78739c41-f65b-487c-901c-bccbd7d4fe9c Ancestors: OpenDBX-Core-MarianoMartinezPeck.282 Capitalize name of "instance" class variable in DBXNoEncoding

1 0

Problems
by Benoit St-Jean 19 Mar '11

19 Mar '11

I've downloaded the Squeak 4.2 All-in-One file for windows, installed Squeak, downloaded the necessary DLLs for OpenDBX for Windows and loaded the Metacello necessary stuff without problem. Now, I've been struggling to install DBXTalk and SqueakDBX. Has anyone tried installing those from a ***fresh-clean*** Squeak 4.2 image ? Besides the 2 underscore settings you have to change to be able to get passed the first 2 errors, there always seems to be something missing. Now, I'm stuck with the SmartSyntaxInterpreterPlugin class missing. Can anyone try loading DBXTalk and describe the process, step-by-step. Am I missing something obvious? tia ----------------- Benoit St-Jean Yahoo! Messenger: bstjean A standpoint is an intellectual horizon of radius zero. (Albert Einstein)

5 14

[ANN] Last SqueakDBX release and news!
by Mariano Martinez Peck 18 Mar '11

18 Mar '11

Hi folks. We just wanted to let you know that we released SqueakDBX 1.3, which is a minor release with some bugfixes, code clean up, and integration of some functionality that others developed. For more details about this small release please check: http://www.squeakdbx.org/ChangeLog As you may know, ESUG sponsored once again SqueakDBX. However, this is the last release of SqueakDBX with this name. The project was finally renamed to DBXTalk, since we can reuse the class prefix ;) joke. For the moment we are starting to work in a new repository, but this is just for us. You, as developer, right now, have to use the repository and configuration as always. Just forget about DBXTalk for now ;) Cheers SqueakDBX team

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX March 2011