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

[Navaneeth K N]

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

Hello,

On 3/20/14 9:35 PM, Kevin Martin wrote:
> 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?

Download a new amalgamation from SQLite website and put it inside the
deps directory. Both .h and .c file. Compile and test.

> 
> 
> On Thu, Mar 20, 2014 at 11:47 AM, Navaneeth K N <address@hidden> wrote:
> 
> 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

iQEcBAEBCgAGBQJTKzBKAAoJEHFACYSL7h6kBRUH/2dBnqZOLJUyuReYuKSsi4ed
wj2rz4LjWxPIJu9S5MZ0RsXUqOHtZjStkT+Mf4WluJolUgGJ5bqtUTEPQk5FmkC3
pnI7L1kmRJ6l14bypdHpJgw2jyXlpoA8qQvJwnrMsPTZ3jgu2u1xO8Jb4XlDNbzY
S4mift+kc8BbhiDvNdS/S/iYAIs0GWxcetAHeQ9z68oQAXMFQMx/dR5adqekz5BH
TQtGqEtRioihlnl4Wn3/PxcXSthZfaxsjjrPVQI63MYl6hQWCeMJeHRULGzjTNkj
UHVQqa7mywgWknfqkVI3DTufYIzBc/gP6gjpfQiD1K/Xvhrc7ZdHb9l2duhf65Y=
=h7yb
-----END PGP SIGNATURE-----