10.29.05

Sorting out SQL Trees

Posted on October 29th, 2005 in Development by Victor Laszlo

I recently came upon a problem that had a surprisingly pleasant solution. I had set of elements that look like this:

Element

Bucket

The “Bucket” for each element was a member of a hierarchical (and editable) tree. Usually, people represent a tree like this in SQL using the “adjency list model”, where the table is repeatedly joined with itself on ID=parentID to produce the tree. The schema for that table looks like this:

Bucket

ID

parentID

Order

My hierarchy also has order, so that each child of a given parent has a sequential order.

The problem I had was that I wanted to sort my elements in an order based on the order of the tree so that I could have a report that looked like this:

1. Bucket
     Element
     Element
        1.1 Bucket2
             Element
             Element

Read the rest of this entry »

Permalink Comments off · Tags: openlaszlo, laszlo

10.28.05

Architecting Laszlo Apps on the Fly

Posted on October 28th, 2005 in Development by dstowell

Software developers never have enough time. The code-slingers on the Laszlo Studios team are no different: we have many different projects running at any given time and strive to deliver perfect code on time scales of six weeks to three months. How do we do it? A little luck and a lot of laziness:

Create minimal structure and get going
On projects with tight deadlines, being able to find a relevant chunk of code and either fix it or extend it is more important than dealing with beautifully designed and over-engineered interfaces. Studios projects start with the creation of a few directories and main.lzx. Here’s the listing from our latest completed project:

Read the rest of this entry »

Permalink Comments off · Tags: openlaszlo, laszlo

10.27.05

OpenLaszlo Jobs

Posted on October 27th, 2005 in Announcements by Oliver

Laszlo Systems is looking for a Senior Visual Designer.

Read the job description here, and apply if it matches you!

Also see the Laszlo Systems jobs page, the jobs page of the OpenLaszlo wiki, and the job posting section of the Laszlo Developer Forum, for additional opportunities.

Permalink Comments off · Tags: openlaszlo, laszlo

State Machine

Posted on October 27th, 2005 in Sightings by Oliver

The OpenLaszlo project’s very own Max Carlson, together with Ben Cerveny, have created the awesome State Machine, a tool for visualizing the influence of money on politics.

Permalink Comments off · Tags: openlaszlo, laszlo

Developing Web Applications with Spring and Laszlo

Posted on October 27th, 2005 in Events by Oliver

Matt Raible will be presenting “Developing Web Applications with Spring and Laszlo. Matt is the author of Spring Live and a co-author of Pro JSP.

The Interface21 and NoFluffJustStuff Java Symposiums have announced The Spring Experience, the first ever conference exclusively for the Spring Framework community. This international event will take place December 7th - 10th, 2005 at the Sheraton Bal Harbour Beach Resort in South Florida.

Permalink 2 Comments · Tags: openlaszlo, laszlo , spring

10.21.05

OpenLaszlo Database API Spec

Posted on October 21st, 2005 in Development by Oliver

Max Carlson has posted a database API spec to the OpenLaszlo development mailing list:

The notion is to have a common REST API for Laszlo to read form and communicate changes to remote data sources. The plan is to create a special Laszlo dataset that knows how to speak this protocol and can automatically sync with the back-end. The first implementation will likely be in PHP and support SQL databases such as MySQL. Later implementations could be built on other platforms - I’d love to see one built on Rails. It’s important to note that the protocol is designed to be general enough to work with any data source that has sets of records - it’s not necessarily tied to SQL databases. I look forward to hearing your thoughts and feedback!

Permalink Comments off · Tags: openlaszlo, laszlo