title: Sqlite load extension disabled?
body: <p>I'm trying to use this <a href="http://www.sqlite.org/contrib/download/extension-functions.c?get=25" rel="nofollow noreferrer">sqlite extension</a> to calculate stdev in Sqlite dbs, on Linux, I use this command to compile the lib </p>
  
  <blockquote>
    <p>gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so</p>
  </blockquote>
  
  <p>but seems that the .load command is not in the sqlite .help command list, and I got error:</p>
  
  <blockquote>
    <p>unknown command or invalid arguments:  "load". Enter ".help" for help</p>
  </blockquote>
  
  <p>Same thing happens when I use the command:</p>
  
  <pre><code> sqlite&gt; SELECT load_extension('./libsqlitefunctions.so');
  </code></pre>
  
  <blockquote>
    <p>SQL error: no such function: load_extension</p>
  </blockquote>
  
  <p>I tried to use this instruction to compile sqlite:</p>
  
  <pre><code>0. untar latest sqlite3 source code in a new directory
  
  1. cd to the newly untarred sqlite directory
  
  2. Comment out the line in Makefile.in to enable loadable extensions:
  
       # TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1
  
  3. ./configure LIBS=-ldl &amp;&amp; make sqlite3
  
  4. export LD_LIBRARY_PATH="`pwd`:$LD_LIBRARY_PATH"
  
  5. gcc -I`pwd` -shared src/test_loadext.c -o half.so
  
  6. ./sqlite3
  </code></pre>
  
  <p>But couldn't find the line "TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1" in the newest Sqlite source code.</p>