Re: [Varnamproject-discuss] Bug 40714 : without rowid

[Kevin Martin]

I was able to reproduce it once. But not again. I will look into this and file a bug if I can figure out why this happens. Meanwhile, how can I try out sqlite3 3.8.3 with varnam? Needs it to use the without rowid feature. How can I change the embedded sqlite?

On Thu, Mar 20, 2014 at 11:47 AM, Navaneeth K N <address@hidden> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hello,

`libvarnam` embeds SQLite. It won't use the system version. Primarily
because SQLite does lots of performance improvements to each versions
and system packages won't get updates all the time. For example, in
Debian, updates are very rare.

This makes `libvarnam`'s performance dependent on system's installed
SQLite package. To avoid that, libvarnam compiles SQLite statically. In
fact, that is the preferred way of using SQLite.

On 3/20/14 11:34 AM, Kevin Martin wrote:
> I'm trying to use sqlite 3.8.2 with libvarnam to see if 'without rowid' is
> helpful. However using without rowid throws me a syntax error when I use it
> with libvarnam. I can create tables without rowid in sqlite 3. I noticed a
> file sqlite3.c in deps/ . libvarnam is not using the libsqlite3-dev package
> in the system? If sqlite3.c is written for sqlite3 < 3.8.2, without rowid
> will not work.
>
> Another curious thing is that I tried building libvarnam after removing
> sqlite3 from my system. The build was successfull, even though
> transliteration did not work ('kevin' was transliterated to 'kevin' instead
> of the malayalam pattern). Wouldn't it be nice if we can add a few checks
> to see if sqlite3 is installed?

Transliteration should work because `libvarnam` is not dependent on
system's SQLite package. Do you have the VST file available in the
search path? Can you reproduce the behavior?

>

- --
Cheers,
Navaneeth
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org

iQEcBAEBCgAGBQJTKof9AAoJEHFACYSL7h6kKTIIAM1si4ko1QHFWFUl3LBq4eCk
Np0TO5NN3LYuP3nKbGSiQGAucX2YeHf7W2tqLLREwRHWkWPPqmntcKfdl42byEFa
VDwM7dLbo2P4RCjCDJGX8GE6CtpVlX2TL+qkKHzIj5VnLLHEXMtQ5jjzw+XZx3xE
3JKhMwkxCx02RmUtvBk0QmM98E0Ab6+KPAOjG1ieOo7fWVWnC6WMqLbaMt9fb/zP
QAkzXQw9xhX5PDffZKxdEXWyuc3t07PmTPUXvzrzZ4ZzXwSagqvRX8uJb80cOLhY
T1FHEN8JgN8CJiIsOnLYNp5mhMbEp93IWRpKiMi4I86oXR/U24q0pjXjJZ7MsiE=
=ESMp
-----END PGP SIGNATURE-----