Build sqlite3 json1 extension as shared library on OS X

json1.dylib: json1.lo  
    $(LTCOMPILE) -c $(TOP)/ext/misc/json1.c  
    $(TCC) -shared -o json1.dylib json1.o  
$ python
Python 2.7.11 (default, Jan 22 2016, 08:28:37) 
[GCC 4.2.1 Compatible Apple LLVM 7.0.2 (clang-700.1.81)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> con = sqlite3.connect(':memory:')
>>> con.enable_load_extension(True)
>>> con.execute("select load_extension('./json1')")
<sqlite3.Cursor object at 0x100e81650>
>>> con.execute("SELECT json(1)").fetchone()

Now read this

accessing digital cert with javascript

How can we get access to the digital certificate for the page that our browser just loaded using javascript? It’s not possible in Chrome, but we can do it using an extension in Firefox. This stackoverflow question goes into more details.... Continue →