[IPython-dev] SQLite kernel
mgadbois at gmail.com
Mon May 5 13:55:28 EDT 2014
Wow that was there but not found by Google... nice! I will take a close
On Mon, May 5, 2014 at 11:52 AM, Jessica B. Hamrick
<jhamrick at berkeley.edu>wrote:
> Hi all,
> 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 itself?
>>> IPython-dev mailing list
>>> IPython-dev at scipy.org
>> 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