~                  ~
     *                   *                *       *
                  *               *
  ~       *                *         ~    *
              *       ~        *              *   ~
                  )         (         )              *
    *    ~     ) (_)   (   (_)   )   (_) (  *
           *  (_) # ) (_) ) # ( (_) ( # (_)       *
              _#.-#(_)-#-(_)#(_)-#-(_)#-.#_
  *         .' #  # #  #  # # #  #  # #  # `.   ~     *
           :   #    #  #  #   #  #  #    #   :
    ~      :.       #     #   #     #       .:      *
        *  | `-.__                     __.-' | *
           |

"""""""""""``` | * * | | || |~)|~) / | | |~||~|~ |~ | | ~ ~ * | | * | |~)||~)~|~| ||~| / | *

• .-| |~)||~ | |~|| /|~ | |-. .' '. ~ ~ .' . * jgs :-.__ _.-' : .

  """""""""""

  .' -.. _..-'

  """"-----------""""

```

                                    (
                       (
               )                    )             (
                       )           (o)    )
               (      (o)    )     ,|,            )
              (o)     ,|,          |~\    (      (o)
              ,|,     |~\    (     \ |   (o)     ,|,
              \~|     \ |   (o)    |'\   ,|,     |~\
              |'\     |'\@@@,|,@@@@\ |@@@\~|     \ |
              \ | o@@@\ |@@@\~|@@@@|'\@@@|'\@@@o |'\
             o|'\@@@@@|'\@@@|'\@@@@\ |@@@\ |@@@@@\ |o
           o@@\ |@@@@@\ |@@@\ |@@@@@@@@@@|'\@@@@@|'\@@o
          @@@@|'\@@@@@@@@@@@|'\@@@@@@@@@@\ |@@@@@\ |@@@@
          p@@@@@@@@@@@@@@@@@\ |@@@@@@@@@@|'\@@@@@@@@@@@q
          @@o@@@@@@@@@@@@@@@|'\@@@@@@@@@@@@@@@@@@@@@@o@@
          @:@@@o@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@o@@::@
          ::@@::@@o@@@@@@@@@@@@@@@@@@@@@@@@@@@@o@@:@@::@
          ::@@::@@@@::oo@@@@oo@@@@@ooo@@@@@o:::@@@::::::
          %::::::@::::::@@@@:::@@@:::::@@@@:::::@@:::::%
          %%::::::::::::@@::::::@:::::::@@::::::::::::%%
          ::%%%::::::::::@:#####::::###::::::::::::%%%::
        .#::%::%%%%%%:::::#:::::#::#:::#::::::%%%%%::%::#.
      .###::::::%%:::%:%%:::::::#:#:::::#:%%:%:::%%:::::###.
    .#####::::::%:::::%%:::#####::#:::::#::::%::::::::::#####.
   .######':::::::::::%:::#:::::::#:::::#::::%:::::::::'######.
   .#########'':::::::::::#::::::::#:::#:::::::::::''#########.
   '.#############''':::::#######:::###::::::'''#############.'
    '.######################################################.'
   .ooooooo.o # .oooooo. #### ooooo ####### o8o #### .####.
  d8P'  '.'Y8  d8P' #'Y8b ### '888' ####### '"'  # .o8 .'
  Y88bo.      888 .... 888 ... 888  .....  oooo #.o888oo  .ooooo.
   '"Y8888o.  888      888     888         '888    888   d88' '88b
       '"Y88b 888      888     888          888    888   888ooo888
  oo     .d8P '88b    d88b     888       o  888    888 . 888
  8""88888P'   'Y8bood8P'Ybd' o888ooooood8 o888o   "888" 'Y8bod8P'
     
                                                                                                                                                

Edited from the original art by Catalyst @ [https://asciiart.website/index.php?art=events/birthday]

SELECT * FROM memories WHERE joy > 0;

Could you expand that with some results? Or did you not get any?

;)

... It's a loooooooong-running query

That is because you forgot to constrain the timestamp of the memory, and a couple trillion years of events is a lot to search for a bit of joy. You probably should also make sure you have an index on (joy, timestamp) unless you want a long non-productive table search ...

It's the long productive searches that i care for more....

Classic Keith! :-)

Here's an exact count:

fossil sql -R sqlite.fossil

sqlite> SELECT count(*) FROM event WHERE comment LIKE ':-)%';
141

Of course, fun never stops!

Congrats. In the spirit of that anniversary, I'm replying on my 10 years old iPad 1 running iOS 5.1.1!

Stupid Fossil Tricks

The This Day In History page shows what was happening on the project on the same day of various years going backwards in time. And today, for the first time ever, that page is showing us what was going on 20 years ago.

(Note: I pegged the link above to 2020-05-29, so that people who visit this page in the future will see the same thing as we are seeing today. Omit the "today=" query parameter to see backwards in time for the current day.)

17:44 :-) (CVS 2) (check-in: 53841c66 user: drh tags: trunk)

Man, that's lots of joyful commits! ... or maybe that was Fossil already making fun of CVS.

You hardly ever look at check-in comments in raw CVS. Later on, I added things like CVSTrac which made the comments visible, and so I started writing better check-in comments. But back in 2000, the check-in comment prompt was just an annoyance, and so I filled it in with a smiley.

See the History of Fossil for more background information.

Thank you for SQLite & Fossil (which came years later).

In turn for your kind gifts to the world, I propose we each do what your comments always say:

** May you do good and not evil.

** May you find forgiveness for yourself and forgive others.

** May you share freely, never taking more than you give.

@202020Y dY                         dY          dY    dY                   SS
   20    20                         20          Y@.  .@Y                   QQ
   20    20d20Yb. .d2020b. 20d20@b. 20  .dY      @DRH@Y  .d@DAN@. AA    YY LL
   20    20'  '20 20'  '20 20'  '20 2020@"         20    20'  '20 LL    OO ii
   20    20    20 20.  .20 20    20 20  '@b.       20    20.  .20 LL.  .UU tt
   dY    dY    dY '2020@'@ dY    dY dY   'YY       dY    '@JOE@Y' '@40OF!! ee

Please sir, may we have 20 more?!

Scheduled end-of-life for SQLite is 2050-05-29. But that is a long way off yet. We'll see how it goes.

Can you update the docs with that?

😁

It's already there.

Aviation-grade testing ....

Any chance SQLite has just managed to blast off to LEO on board of SpaceX Dragon Crew?

Either way, thanks to SQLite team!

Kudos to SpaceX/NASA teams and Safe return to the Astronauts!

Any chance SQLite has just managed to blast off to LEO on board of SpaceX Dragon Crew?

I heard that the astronauts' kneeboards are ipads, which if true means the answer is "Yes!".

Congratulations!

Wouldn't that be the perfect moment for an anniversary edition completing SQL92 compatibility? (Support for alterations of schema definitions with ALTER and DROP)

Apologies for been late to the party. Thanks and congrats to Dr. Hipp and the team.