[HN Gopher] SQLite Release 3.40.0
       ___________________________________________________________________
        
       SQLite Release 3.40.0
        
       Author : thefilmore
       Score  : 103 points
       Date   : 2022-11-16 18:33 UTC (4 hours ago)
        
 (HTM) web link (www.sqlite.org)
 (TXT) w3m dump (www.sqlite.org)
        
       | nix23 wrote:
       | SQLite and Minix3 is probably the most used Software on earth ;)
        
       | jmull wrote:
       | > b. Extract the values of expressions contained within
       | expression indexes where practical, rather than recomputing the
       | expression. > c. The NOT NULL and IS NULL operators (and their
       | equivalents) avoid loading the content of large strings and BLOB
       | values from disk. > d. Avoid materializing a view on which a full
       | scan is performed exactly once. Use and discard the rows of the
       | view as they are computed. > e. Allow flattening of a subquery
       | that is the right-hand operand of a LEFT JOIN in an aggregate
       | query.
       | 
       | Gulp. When writing SQL I tend to assume these kinds of things
       | have always been done... I should probably favor my own logical
       | optimizations when I can.
       | 
       | (Of course, nothing beats measuring/profiling if you really need
       | to optimize.)
        
       | pwpwp wrote:
       | Does the WASM port include full-text search (FTS)?
        
         | sgbeal wrote:
         | > Does the WASM port include full-text search (FTS)?
         | 
         | It inadvertently includes FTS4 instead of 5. That was my fault
         | and it will be changed to include 5 instead Real Soon Now.
        
         | llimllib wrote:
         | Not by default, you can test it out here[1].
         | 
         | I documented how to compile an extension into the wasm build
         | here[2], I assume something like that would work for fts? But
         | I'm not sure exactly.
         | 
         | edit: it does build with fts4 by default, just not fts5; I'm
         | not sure why
         | 
         | edit 2: to build with an apparently-functional fts5, apply this
         | diff followed by "make" from the ext/wasm directory; the wasm
         | files you want are in the ext/wasm/jswasm directory after the
         | build completes                   diff --git
         | ext/wasm/GNUmakefile ext/wasm/GNUmakefile         index
         | 039dff410..554cf9cda 100644         --- ext/wasm/GNUmakefile
         | +++ ext/wasm/GNUmakefile         @@ -111,6 +111,7 @@ sqlite3.c
         | := $(dir.top)/sqlite3.c          sqlite3.h :=
         | $(dir.top)/sqlite3.h          SQLITE_OPT = \
         | -DSQLITE_ENABLE_FTS4 \         +  -DSQLITE_ENABLE_FTS5 \
         | -DSQLITE_ENABLE_RTREE \
         | -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
         | -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION \
         | 
         | I don't know why it's not in the default list of flags.
         | 
         | [1]: https://sqlite.org/fiddle/
         | 
         | [2]:
         | https://github.com/llimllib/wasm_sqlite_with_stats/tree/buil...
        
           | simonw wrote:
           | Huh, I wonder why FTS4 and not FTS5? I could understand
           | omitting both of them for reasons of size, but having the
           | older version but not the new one feels surprising to me.
        
             | sgbeal wrote:
             | > Huh, I wonder why FTS4 and not FTS5? I could understand
             | omitting both of them for reasons of size, but having the
             | older version but not the new one feels surprising to me.
             | 
             | It was an oversight on my part. It will be fixed in the
             | trunk momentarily.
        
       | jitl wrote:
       | This contains the beta release of the official WASM build of
       | SQLite https://sqlite.org/wasm/doc/trunk/index.md
        
         | dang wrote:
         | Related:
         | 
         |  _SQLite in the browser with WASM /JS_ -
         | https://news.ycombinator.com/item?id=33374402 - Oct 2022 (198
         | comments)
        
       | rychco wrote:
       | I love using SQLite. It is often my first & only choice when
       | reaching for an embedded database. That being said, are there any
       | compelling alternatives for embedded databases? I'm only aware of
       | DuckDB & Apache Parquet at the moment.
        
         | nix23 wrote:
         | >That being said, are there any compelling alternatives for
         | embedded databases?
         | 
         | https://firebirdsql.org/
        
       ___________________________________________________________________
       (page generated 2022-11-16 23:02 UTC)