Front Page All Articles Recent Changes Random Article

Contents

Concatenative language

  • ACL
  • Ait
  • Breeze
  • Cat
  • Cognate
  • colorForth
  • CoSy
  • Deque
  • Elymas
  • Enchilada
  • ETAC
  • Factor
  • Forth
  • Freelang
  • Gershwin
  • Joy
  • Kitten
  • lang5
  • Lviv
  • min
  • mjoy
  • Mlatu
  • Ode
  • Om
  • Onyx
  • Plorth
  • Popr
  • Porth
  • PostScript
  • Quackery
  • r3
  • Raven
  • Retro
  • Staapl
  • Stabel
  • Trith
  • Worst
  • xs
  • XY
  • 5th
  • 8th

Other languages

  • APL
  • C++
  • Erlang
  • FP trivia
  • Haskell
  • Io
  • Java
  • JavaScript
  • Lisp
  • ML
  • Oberon
  • RPL
  • Self
  • Slate
  • Smalltalk

Computer Science

  • Type systems
  • Language paradigms
  • Compilers
  • Interpreters
  • Garbage collection

Meta

  • Search
  • Farkup wiki format
  • People
  • Etiquette
  • Sandbox

Factor/To do/DB

See Improve database library


i want these operations to be performed with a constant number of queries:

  1. get the most recent 20 posts, by date. Get the number of comments in each post.
  2. get the number of posts per month, in the last 12 months.
  3. delete all posts with uid=$1, delete all comments whose parent post has uid=$1, delete all comments with uid=$1
  4. delete all annotations with parent paste=$1, delete paste with id=$1.
  5. In a TV app, get the duration of each show that a user is subscribed to

Fixed:

  • problem with connection pooling and sqlite
  • compound primary keys
  • foreign keys
  • omitting certain columns from result tuples
  • finish advanced query stuff

This revision created on Fri, 13 Mar 2009 19:41:05 by littledan

Latest Revisions Edit

All content is © 2008-2023 by its respective authors. By adding content to this wiki, you agree to release it under the BSD license.