Glorp findings – using count:

Conntinuing on the Customer/Order example from my last post, we might want to only send some ads to customers who have ordered at least twice in the past. For this we'd first have to cunt all orders of our customers who haven't ordered for at least 100 days. So the first step is to create … Continue reading Glorp findings – using count:

Advertisements

Glorp Subqueries – notExists:

I decided to get back to blogging after a very long break. Since I am quite busy with our Kontolino! project, I also decided that I need to get back to blogging with small articles that require little time - but might still be useful. So here is the idea: I am struggling with Glorp … Continue reading Glorp Subqueries – notExists:

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

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