Well, like I mentioned, I do have the basic functionality that I want in an
existing C# application. Unfortunately it works in the opposite direction
that I was hoping...meaning it implements Sqlite and not Sqlite
implementing it. The functionality would be more generally usable if Sqlite
could implement that logic as an extension.
And maybe I could leverage that experience into developing a window
extension...row_number over( partition by/order by ). Couple years ago I
was seeking said functionality from Sqlite but none existed. And now that
I think about it, I probably can't avoid said C# application because of the
lack of windowing. I needed at that time some kind of compiled language
because I could not get the i/o performance I need from a scripting
language.
[it's been a day since I drafted the above email. but now these thoughts
have crossed my mind]
Has anyone else attempted writing a window extension for Sqlite? With
enough people requesting it, what difficulties are involved such that it is
low on a development list? What negatives does a window extension impose
that make it undesirable. What am I in for and what advice can you provide?
I probably can get away with a scripting language controlling my process. A
lot of the effort can be handed off to Sqlite in batch, handling the
queries of 20mm rows. The final result set that needs to be windowed is
typically 5/10m rows, which should be pretty manageable...performance wise.
dvn - just the ramblings of a simple mind.
On Fri, Mar 25, 2016 at 4:48 PM, James K. Lowden <jklowden at schemamania.org>
wrote:
> On Fri, 25 Mar 2016 06:49:22 -0500
> Don V Nielsen <donvnielsen at gmail.com> wrote:
>
> > I have a need for something that can parse and load into sqlite tables
> > fixed length data.
>
> Insert your own separators.
>
> $ cat input
> 12345678910111213141516171819202122232425
>
> Print two 5-byte ranges separated by ", ".
>
> $ awk '{ OFS=", "; print substr($0, 1, 5), substr($0, 6, 5); }' \
> input
> 12345, 67891
>
> --jkl
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
