Re: [sqlite] SQLite.so dynamic library-linux

[Doug]

> and buying a load of hardware isn't really viable

I can't help with the .so, but you could load up a virtual machine with one
of the free VM engines (VMWare Server is free for example -- I'm sure
Microsoft must have one too) and put Linux on it.  That would give you the
benefit of being able to test one of your targets too.

Doug

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Udon Shaun
Sent: Friday, March 18, 2011 11:47 PM
To: Pavel Ivanov; SQLite
Subject: Re: [sqlite] SQLite.so dynamic library-linux

@Pavel
Apologies. I just hit reply and thought it would have gone to the right
place.

 A 3rd party company doesn't compile my code. It's an API interface to the
SQLite library so people can use SQLite in LabVIEW. I don't have linux
(never had linux) and buying a load of hardware isn't really viable just to
compile 1 SO in an open source distribution.

But to answer your question. more fully.LabVIEW is cross platform (MAC,
Win,VXWorks & Linux). Therefore the API I provide can (and does) work under
all those systems (and ,many users have been using it in those OSs for some
time) - you just need the SQLite library compiled for the particular OS. MAC
comes with it already. I can already compile for Windows and VXWorks, so
that just leaves Linux (which I used to download from the SQLite site).

So I'm posting under this forum to try and get the last OS library (linux)
and find some help in cross-compiling the SO in windows so that I can
support it myself for future updates seeing as it's no longer provided. If
it was still posted on the SQLite site (as it was prior to 3.7.4) , I
wouldn't be here aslking!. The alternative is that I just drop linux. But I
at least want to make the effort for my users.



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unique index versus unique constraint

[Simon Slavin]

On 19 Mar 2011, at 7:52am, Paul van Helden wrote:

> It actually makes sense to never drop any automatic index (!). My question
> should have been how to reliably determine whether an index is automatic or
> not. Unless someone can come up with a compelling reason not to test for
> "sqlite_autoindex_" in pragma index_list, I'd prefer to stick to that.
> 
> Now I'm wondering if in future a situation could arise where the SQL will be
> provided for automatic indexes... Eg. to aid in exporting DDL

I'm not sure why you'd want it.  You can't do anything with automatic indexes 
anyway: they can't be dropped.  The only indexes you can DROP are the ones 
which have their own listing in the sqlite_master table.

If you're trying to figure out the TABLE's contraints, you can't use indexes 
anyway.  You have to do it by looking at the column definition and the foreign 
keys, and these have their own entries in sqlite_master.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLlite3 error

[Eugene N]

Hi

In the old day, people used to bring up a debugger and find what function
was misbehaving at this particular offset. As to the cause
of the error, it can be a version-mismatch perhaps?

Eugene

2011/3/19 

> Hey fellows,
> I m new to sql3 users list and i m not sure if the question will be
> considered as one that fits the place here ,but i need to ask anyway.
> I m experiencing an sql3 error in the Google Adwords Editor
> application and whenever i open it it shuts down just after the
> interface appears on the screen giving a message that says:
>
> AppName: adwords_editor.exe  AppVer: 1.9.0.4029  ModName:
> sqlite3.dll
> ModVer: 0.0.0.0  Offset: 00019ff8
>
> I don`t know if this error ocurs due to an application error or there
> is an error in my pc.I know nothing about sqllite ,but it seems to me
> that my pc cannot open the app without error ,because something is
> missing.
> Does anyone has any previous experience with this situation?
> I appreciate any answers in advance.
>
> Thanks
> Mathaios
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unique index versus unique constraint

[Paul van Helden]

>
> Automatic indexes have no "SQL" entry in the SQLite_Master table, so you
> can use that to see if you can drop it. eg:
>
> select Name from SQLite_Master where type = 'index' and SQL is null
>
> will give you the name of all the automatic indexes, which can't be
> dropped.
>

Thanks Tom,

It actually makes sense to never drop any automatic index (!). My question
should have been how to reliably determine whether an index is automatic or
not. Unless someone can come up with a compelling reason not to test for
"sqlite_autoindex_" in pragma index_list, I'd prefer to stick to that.

Now I'm wondering if in future a situation could arise where the SQL will be
provided for automatic indexes... Eg. to aid in exporting DDL.


>
> Yes, we definitely need more extensive schema introspection facilities in
> SQLite.
>

A simple "autoindex" field in pragma index_list would be a good start :-)


>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLlite3 error

[support]

Hey fellows,
I m new to sql3 users list and i m not sure if the question will be  
considered as one that fits the place here ,but i need to ask anyway.
I m experiencing an sql3 error in the Google Adwords Editor  
application and whenever i open it it shuts down just after the  
interface appears on the screen giving a message that says:

AppName: adwords_editor.exe  AppVer: 1.9.0.4029  ModName: sqlite3.dll
ModVer: 0.0.0.0  Offset: 00019ff8

I don`t know if this error ocurs due to an application error or there  
is an error in my pc.I know nothing about sqllite ,but it seems to me  
that my pc cannot open the app without error ,because something is  
missing.
Does anyone has any previous experience with this situation?
I appreciate any answers in advance.

Thanks
Mathaios

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users