sqlite3: insert multiple values

[Edward Ruggeri]

sqlite doesn't allow multiple values to be inserted in the usual way:
(http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-
multiple-rows-at-a-time-in-an-sqlite-database).

Korma generates the usual SQL, with predictable results when trying to
insert multiple values to a sqlite db: SQLException. It might be nice
if Korma noticed sqlite and generated something it could handle.

In the meantime, I decided to use postgres.

-- Ned Ruggeri

[Edward Ruggeri]

I wrote a patch to handle this. Not the prettiest, but seems to work.

-- Ned Ruggeri

[Edward Ruggeri]

Let me know what I can do to possibly merge this upstream.

-- Ned Ruggeri

[Chris Granger]

Hey Ned,

It's currently a non-goal to abstract away all the differences between SQL implementations in Korma. To do so would require a great deal of thought to prevent thousands of little changes like this from stacking up into the monstrosity that a lot of database layers end up being :) At its core would be something robust enough to compile queries where certain parts might be swapped out based on db types.

If you wanted, you could start trying to establish a base that would enable such a system to be built. korma.incubator would be a good place to try it out: https://github.com/ibdknox/korma.incubator

Cheers,
Chris.

[Edward Ruggeri]

Thanks, Chris; makes sense. Korma's been working out great for me;
thanks so much for your work.

-- Ned Ruggeri

On Jan 26, 11:05 am, Chris Granger <ibdk...@gmail.com> wrote:
> Hey Ned,
>
> It's currently a non-goal to abstract away all the differences between SQL
> implementations in Korma. To do so would require a great deal of thought to
> prevent thousands of little changes like this from stacking up into the
> monstrosity that a lot of database layers end up being :) At its core would
> be something robust enough to compile queries where certain parts might be
> swapped out based on db types.
>
> If you wanted, you could start trying to establish a base that would enable
> such a system to be built. korma.incubator would be a good place to try it
> out:https://github.com/ibdknox/korma.incubator
>
> Cheers,
> Chris.
>