Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

SirClive's scratchpad

by SirClive (Scribe)
on Jun 17, 2009 at 13:56 UTC ( #772402=scratchpad: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

    Log In?

    What's my password?
    Create A New User
    [Corion]: Meh. Once again I find that SQLite doesn't support window functions and I want to use those nowadays :-)
    [erix]: Look what I found! :P
    [Corion]: Hmm - actually, I don't need them, even though they'd be nice. I just want the (say) 10 latest images, and that's easily done with a limit 10 offset 0 clause, as I don't need all top 10 images for all users.
    [Corion]: erix: Sure, but this is for a really-lightweight application and I'm replacing a CSV file / JSON file for user configuration with SQLite (and optionally, Pg) :)
    [erix]: isn't a texty format handier for configs?
    [Corion]: So far, I've avoided having even a user database by storing the user information in a (signed) cookie that the browser keeps for me, but as I want to be able to lock users, I need a second storage option :)
    [Corion]: erix: It's needed for keeping the list of users and the list of tags associated with an image, and for keeping the images with users. I want an easy way to know if an image can be deleted, which means that it can't be referenced by any tag anymore. ...
    [Corion]: SQL feels like a natural choice here :)

    How do I use this? | Other CB clients
    Other Users?
    Others meditating upon the Monastery: (12)
    As of 2018-03-20 14:02 GMT
    Find Nodes?
      Voting Booth?
      When I think of a mole I think of:

      Results (253 votes). Check out past polls.