Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re^4: A decade in the Monastery

by rir (Vicar)
on Jul 16, 2010 at 14:03 UTC ( #849982=note: print w/replies, xml ) Need Help??

in reply to Re^3: A decade in the Monastery
in thread A decade in the Monastery

Forget??! Mine was made on 19AUG92 and is going strong.

Wipe the drool off your chin. It's unseemly. Ha!

Be well,

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://849982]
[Corion]: Of course, the query performance for "all items on page 10" is likely worse than rank() between 100 and 109 , but if that means I can write 15 lines of SQL instead of needing to think about how to partition things and how to encode the page size...
[Corion]: ... that would be nice. But alas, I'm currently tied to SQLite as minimum implementation, and it doesn't implement window functions :-(
[Corion]: And I'm not aware of any other serverless SQL implementation that even reaches the capability of SQLite, not to mention surpasses it

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (10)
As of 2018-03-22 12:21 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (274 votes). Check out past polls.