I am sorry…

It looks like you found a link that is broken. Very likely, I can help you find what you are looking for.

Here is the right link to some common pages people often come here for

I would appreciate if you can help me fix this. Please leave a comment on this page with the link you used and I will get a 301 set up for your next visit and make sure it does not happen again (*)

Thanks in advance for your help and sorry you had to hit this issue

Thomas Kejser

Databases

If you were looking for help with database and data modeling, try the Database or Data Modeling Category.

Computer Game Guides

You can find these in the Game Guides section.

Code and Programming

Try the Resources section.

Search for Stuff

If none of the above was what you were looking for, you can search here:

(*) I automatically track 404 pages on this site and try to correct them as I find them. However, a lot of them come from Search Bots and not a human who experienced the issue. Because of this, I need your help (assuming you are human) in providing the link you used so I can fix this properly.


  3Comments

  1. Kristi   •  

    Thanks for your articles, I’ve been enjoying reading!

    FYI, on the “Sorry” page, the Database and Modeling links are broken … missing the “/category/” bit in the link, I figured out.

    Cheers!
    Kristi

    • Thomas Kejser   •     Author

      Hi Kristi

      Thanks for reporting the problem. Quite ironic that the 404 page has a 404 itself. Now fixed. Much appreciate you taking the time to report it.

  2. Haziq   •  

    Sure, that seems fine. The plain Adjacency List design is good for cetrian types of queries, but bad for querying whole subtrees.FWIW, I have written applications that used the Closure Table alone, without the traditional Adjacency List, and it worked out fine.Another option if you need to query trees only from the root node (and not arbitrary internal subtrees), is to use a hybrid approach with Adjacency List (the parent_id column): add one more column “root_id” so every descendant knows its root ancestor. So querying a whole tree is as simple: SELECT * FROM Comments WHERE root_id = 1;

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">