Trees in the database: Advanced data structures

Lorenzo Alberton wrote in his blog about his paper presented at PHP conference

Storing tree structures in a bi-dimensional table has always been problematic. The simplest tree models are usually quite inefficient, while more complex ones aren’t necessarily better. In this talk I briefly go through the most used models (adjacency list, materialized path, nested sets) and introduce some more advanced ones belonging to the nested intervals family

ED: some of the principles can be applied to Firebird with CTE

What roles is user able to use?

About a month ago there was a question in Firebird (CZ) group how to find whether the user is able to use particular role or to get all roles for user.

As you probably know, a lot of stuff (almost everything) is in system catalog (system tables). The only problem is to figure out what’s the right set of parameters to use. To get all roles with users able to use it, you can use …

Firebird django backend call for testing help and progress

The call for an extra hand for testing people who are python/django experts the code is already in svn :

I’m Maximiliano Robaina (maxirobaina) and I’m working on the django-firebird backend implementation. The original google project, started by Ivan Illarionov, was deprecated because he hasn’t any time to port it to django 1.x
The django db backend has many changes, therefore, the Ivan version don’t work any more.
For this, I upload my django-firebird version which is compatible with django 1.1 beta-1., Firebird 1.5 and Firebird 2.x
The next step (for me) is to replace the svn version with my code and reorganize the repository (I will need some help for it)

Are you interested in continuing to participate on this?

If the answer is yes, plase contact to me to coordinate.

Regards.

In an related blog to new django backend release from the nagami blog :
Once, I wrote Django firebird backend http://nakagami.blog.so-net.ne.jp/2009-03-12-2
But it is not good work on Django subversion trunk today. (Target is moving !)
So I catch it up. ( Thanks Maxi )http://www005.upp.so-net.ne.jp/nakagami/Download/django-firebird_20090606.zip
I hope it works on Django 1.1 release.

1 23 24 25 26 27 48