SQLite Forum

SQLite turns 20
Login

SQLite turns 20

(1) By Richard Hipp (drh) on 2020-05-29 16:18:51 [link] [source]

The first check-ins of SQLite source code happened 20 years ago today, on 2000-05-29.

(2) By Wout Mertens (wmertens) on 2020-05-29 17:08:51 in reply to 1 [link] [source]

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

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

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

```

(3) By anonymous on 2020-05-29 17:25:37 in reply to 1 [link] [source]

                                    (
                       (
               )                    )             (
                       )           (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]

(23) By Tom B (tb13) on 2020-06-02 02:15:22 in reply to 3 [link] [source]

Cool graphic, awesome software!  I use it and advocate for it every day.  Thx Dr. Hipp and co!

(4) By Warren Young (wyoung) on 2020-05-29 17:25:52 in reply to 1 [source]

SELECT * FROM memories WHERE joy > 0;

(5) By luuk on 2020-05-29 17:28:07 in reply to 4 [link] [source]

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

;)

(6) By anonymous on 2020-05-29 17:31:46 in reply to 5 [link] [source]

... It's a loooooooong-running query

(8) By Keith Medcalf (kmedcalf) on 2020-05-29 17:59:57 in reply to 6 [link] [source]

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 ...

(9) By luuk on 2020-05-29 18:01:55 in reply to 8 [link] [source]

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

(24) By jose isaias cabrera (jicman) on 2020-06-03 17:12:01 in reply to 8 [link] [source]

Classic Keith! :-)

(14) By anonymous on 2020-05-29 21:27:02 in reply to 5 [link] [source]

Here's an exact count:

fossil sql -R sqlite.fossil

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

Of course, fun never stops!

(7) By anonymous on 2020-05-29 17:49:20 in reply to 1 [link] [source]

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

(10) By Richard Hipp (drh) on 2020-05-29 18:06:54 in reply to 1 [link] [source]

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.)

(11) By anonymous on 2020-05-29 19:00:02 in reply to 10 [link] [source]

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.

(13) By Richard Hipp (drh) on 2020-05-29 19:52:07 in reply to 11 [link] [source]

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.

(12) By anonymous on 2020-05-29 19:29:36 in reply to 1 [link] [source]

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.

(15) By anonymous on 2020-05-29 23:27:28 in reply to 1 [link] [source]

@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

(16) By skywalk on 2020-05-30 14:10:58 in reply to 1 [link] [source]

Please sir, may we have 20 more?!

(17) By Richard Hipp (drh) on 2020-05-30 14:56:47 in reply to 16 [link] [source]

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

(18) By luuk on 2020-05-30 15:14:42 in reply to 17 [link] [source]

Can you update the docs with that?

😁

(20) By Warren Young (wyoung) on 2020-05-30 16:13:37 in reply to 18 [link] [source]

(21) By anonymous on 2020-05-30 20:12:16 in reply to 20 [link] [source]

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!

(22) By Richard Hipp (drh) on 2020-05-30 20:15:02 in reply to 21 [link] [source]

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!".

(19) By anonymous on 2020-05-30 15:53:46 in reply to 1 [link] [source]

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)

(25) By jose isaias cabrera (jicman) on 2020-06-03 17:16:35 in reply to 19 [link] [source]

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