[IPython-dev] SQLite kernel
Jessica B. Hamrick
jhamrick at berkeley.edu
Mon May 5 11:52:40 EDT 2014
I jut wanted to throw out there a link to the SQL magic, which may be
I know it's not a whole kernel, but may be a good starting place for at
least seeing what other people have been thinking about along the same
UC Berkeley, Department of Psychology
Computational Cognitive Science Lab
On Mon, May 5, 2014 at 8:28 AM, Doug Blank <doug.blank at gmail.com> wrote:
> On Mon, May 5, 2014 at 11:00 AM, Martin Gadbois <mgadbois at gmail.com>wrote:
>> I would like to develop a SQLite kernel for IPython.
>> Keyword, table and column completion would help building queries, and a
>> dynamic output could resize text columns and have a proper notebook table
>> To achieve that, I see two main directions:
>> 1- Have an external kernel (like
>> coded in Python since there are no 0MQ bindings for SQLite.
>> 2- Extend IPython itself to support SQLite, since I will need to write
>> Python code anyway to support SQLite.
> I've wanted something like this for a while! I would like to incorporate
> SQL as a language that could easily be used in a variety of educational
> settings and other open source projects. But the utility of such a project
> lies in the details of implementation.
> There are pros and cons to both approaches. But you could perhaps develop
> it in a manner that could be used in either situation. What would generally
> be useful would be to replicate the SQLite shell. It would be great if the
> parser was written in pure Python, and had an interpreter, also as much
> written in pure Python as possible. That is, it would be great if the
> low-level C-based sqlite API was limited, and could be swapped out.
> That would allow other implementations of Python (Jython, PyPy,
> IronPython) could use it with their own sqlite wrappers. But also, that
> might make it useful for interfacing other data storages (for example, CSV
> files, Django databases, etc.)
> The SQLite shell is actually a bit hairy. Here is a port of the C code to
> C# for example:
> You could also use the simple-kernel  as a way of quickly turning a
> Python program into a kernel. (simple-kernel was just updated by Min, so
> now it is correct; thanks, Min!)
> This might also have connections to the ADODB API ... they have worked
> hard to make their connections be Python-implementation agnostic.
> Looking forward to see what you develop!
>  https://github.com/dsblank/simple_kernel
>  https://sourceforge.net/projects/adodbapi
>> What would this list recommend as an implementation strategy?
>> Any example of creating an external kernel by reusing a subset of IPython
>> IPython-dev mailing list
>> IPython-dev at scipy.org
> IPython-dev mailing list
> IPython-dev at scipy.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IPython-dev