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

When hardcore errors with double Glorp INSERTs turn out to be ancient web problems

I've been hunting for some strange problem which I thought was related to Glorp or (less likely) our business code for months. Every once in a while, our production server would log strange NOT NULL problems on inserts of records that do not erectly resolve their foreign keys, even though the objects these records usually refer to can … Continue reading When hardcore errors with double Glorp INSERTs turn out to be ancient web problems

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

A closer look at Kontolino

Two weeks ago I announced the public availability of Kontolino!, our new online service for the accounting needs of small businesses and freelancers. These two weeks have been quite exciting, because this was our first publicly accessible web server project that was done internally from A to Z. We currently welcome a few new test … Continue reading A closer look at Kontolino

Say hello to Kontolino: Smalltalk and Seaside hard at work for Small Businesses

I am happy to announce today the opening of Kontolino! Kontolino! is a web based accounting system for small and medium businesses under German tax regulation (So it is completely in German, sorry folks!). It is implemented in VA Smalltalk and Seaside and uses DB2 as its storage Backend. We're using Glorp for the O/R … Continue reading Say hello to Kontolino: Smalltalk and Seaside hard at work for Small Businesses

Glorp and Schemas – a fix and a short login guide

I just fixed a bug in Glorp that prevents it from respecting the schema you set in the Login object. Why do you need that? In some shops, Schema names are used to distinguish certain project stages or "customer areas" from each other. So in one of my projects they'd have the same set of … Continue reading Glorp and Schemas – a fix and a short login guide

How the latest Glorp eats passwords ;-)

I am playing with VAST 8.6 and its latest Glorp port on VA Smalltalk. So far, I like what I see, even if Glorp still has glitches that I am currently working on with the Instantiations Support team. One thing that made me scratch my head was my unability to login to a database more … Continue reading How the latest Glorp eats passwords 😉

VA Smalltalk 8.6 on Windows 7×64: a first glimpse

Last week Instantiations announced the availability of VA Smalltalk 8.6. This new release brings a few novelties. First, the installation on Windows 7 (and most likely also Windows 8 and 8.1) works like a charm. There is no special procedure any more for machines with User Acces Control enabled - all files are put into … Continue reading VA Smalltalk 8.6 on Windows 7×64: a first glimpse