Glorp/DB2 – Tip: Sorting case insensitive

If you are working with Glorp and DB2 and use #orderBy: you may have found out that the results of ordering by CHAR or VARCHAR columns may end up strange. DB2 assumes that a Small letter is less than a capitalized one. "Hans" is lower than "HANK". In my case this came obvious in a … Continue reading Glorp/DB2 – Tip: Sorting case insensitive

Advertisements

Beautiful little tutorial on how to build a complete Seaside Application with an RDB Backend

Sven just announced the availability of a new tutorial named "Reddit.st — In 10 Cool Pharo Classes".I am fascinated by how short and clear this piece is. It really explains all you need to know to get started building a Seaside Application using Glorp and Postgres as a database. It is nice to read and really covers … Continue reading Beautiful little tutorial on how to build a complete Seaside Application with an RDB Backend

My first (somewhat) complex GLORP Query that actually works

For some of you, this is old hats. For me, it is a little victory that needs a little pause from coding and leaning back and looking outside at the sun and feel like a super hero. I just wrote my first more complex Glorp Query that actually works. Here is what it looks like: … Continue reading My first (somewhat) complex GLORP Query that actually works

Seaside: click a link using jQuery

Sometimes there are things that sound easy in the first place and then take a lot of time trying, yahooing and stackoverflowing etc. Lots of mosaic pieces are found on each iteration of the famous search-try-fail cycle. This is one of these. So what do we have? I wanted to add a double click handler … Continue reading Seaside: click a link using jQuery

Seaside without Continuations pt. 2: WATask is not as useless as you might think

Seaside still is one of the most popular web frameworks in the Smalltalk world. Its integration with client-side JavaScript is far from perfect, but you can do quite nice things with Seaside even in this field. For more server-bound logic, Seaside still is among the most advanced frameworks even far beyond Planet Smalltalk. One of … Continue reading Seaside without Continuations pt. 2: WATask is not as useless as you might think

Glorp Wisdom (pt. 313): Never make two collections exclusive that can share objects

(Please note: the problems described here are not limited to Glorp. This is an issue to keep in mind in all O/R mapping technologies, not only in Smalltalk. What I'm talking about here is also relevant in other languages and frameworks. It just fits nicely into the Glorp Wisdom series) Some days are even worse … Continue reading Glorp Wisdom (pt. 313): Never make two collections exclusive that can share objects

Glorp Wisdom (pt. 312): Don’t reuse objects in exclusive relationships!

There are days when you hunt for a bug and almost are close to giving up. On some of these, it's best to go home, play with your kids or watch a good movie and start again the next day. On some, however, you finally find out teh whole problem was just a case of … Continue reading Glorp Wisdom (pt. 312): Don’t reuse objects in exclusive relationships!

The WASstServerAdaptor story and its (preliminary) end

Well, a developer's day is full of victories and waterloos. So I've had my developer's day today. After I had discussed my Server startup problems related to ports already in use, Marten came up with an explanation for VAST's behavior on the VAST Support Group: The reason for this behaviour is located in the method: … Continue reading The WASstServerAdaptor story and its (preliminary) end

Issuing a REORG TABLE command to DB2 from VA Smalltalk (and Glorp)

You may have realized already that I misuse my blog and therewith you, my valued reader, as a swap space for small and maybe not so small little tricks I find in my day job from time to time. And here is one little thing I just learned about how to invoke commands in DB2 … Continue reading Issuing a REORG TABLE command to DB2 from VA Smalltalk (and Glorp)