Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 22:05:47 -0500, John Gabriele
 wrote:
>Just checked stackoverflow and found this:
>https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ . Might
>be what you're after.

Thanks. I'll try it, but judging from the screenshots, but it's
probably harder than using Excel.

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

Re: [sqlite] Windows user app to display input form + reporting?

[Gilles Ganault]

On Wed, 12 Mar 2014 19:05:01 +0100, big stone
 wrote:
>What don't you like in base solution that made you ask for other ideas ?

I just like SQLite's simplicity and speed, so wanted to make sure
there weren't alternatives.

Besides, it seemed a bit overkill to have her install and learn Base
while she'll keep Word/Excel for the rest of her work.

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

Re: [sqlite] Windows user app to display input form + reporting?

[Gilles Ganault]

On Wed, 12 Mar 2014 11:46:53 +, Simon Slavin
 wrote:
>Any GUI you see is provided by a third party.  There's no point in trying to 
>keep track of more than a hundred database management GUIs, many of which are 
>buggy, many of which interface with other database systems as well as SQLite.  
>The only result that would have is that if there is a bug in one of those 
>apps, someone would think the SQLite team is responsible, and word would get 
>passed around that SQLite is buggy.

Got it.

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

Re: [sqlite] Windows user app to display input form + reporting?

[Gilles Ganault]

On Wed, 12 Mar 2014 07:59:39 -0400, David Bicking
 wrote:
>Not exactly "lite" in size, but kexi does have most of the features of 
>Access and uses sqlite to store its data:
>
>http://kexi-project.org/

Thanks for the link. It's currently not available for Windows, but
I'll keep an eye on it.

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

Re: [sqlite] Windows user app to display input form + reporting?

[Gilles Ganault]

On Wed, 12 Mar 2014 10:29:43 +0100, Kees Nuyt
 wrote:
>Not what you asked for, but LibreOffice Base can use SQLite via ODBC:
>
>http://ch-werner.de/sqliteodbc/
>
>I have no experience with that solution, but at least the package is
>maintained and reasonably up to date.

Thanks guys. In addition, there's this tool:
www.rifin.co.za/software/sqlc/

I see that the wiki contains no document about GUIs:
www.sqlite.org/docs.html

Can non-admin users contribute to the wiki, so that users don't have
to ask in the mailing list?

Thank you.

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

[sqlite] Windows user app to display input form + reporting?

[Gilles Ganault]

Hello

A friend needs to move from Excel to a database. The school won't
pay for the full version of MS Office that includes Access, so
recommended that she use LibreOffice Base instead.

I just checked it out, and it seems to only be a front-end to the
HSQLDB database which is written in Java.

Before I check it out, I'd like to make sure there's no SQLite-based
lighter solution where...
1. I'll run the commands originally to build the DB + tables
2. The Windows application will either display forms for her to enter
data, or provide an easy way to import data from Excel
3. It will then display data through some reporting tool.

Is there a good SQLite-based alternative to LibreOffice Base?

I found this:
http://sqlitestudio.pl
http://www.valentina-db.com
http://www.navicat.com/products/navicat-for-sqlite

Thank you.

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Fri, 19 Apr 2013 16:41:53 -0700, "Joe Mistachkin"
 wrote:
>Actually, ALL the non-static packages on the download page require the MSVC
>runtime libraries of the appropriate version to be installed. 
>
>The download page does mention these requirements in each applicable
>download
>package section; however, perhaps there should be a more prominent notice on
>the top of the download page?

+1, since the origin of the error is not obvious and Google shows that
other users have struggle with this.

It might also be a good idea to add the following infos:

- what is the added-value is in the design-time components, which
requires downloading the Setup version

- when to choose the bundle vs. no-bundle version. The wiki seems a
bit abstract for non-.Net experts

- why should the static package intstead of the dynamic package; I
assume the dynamic version has the advantage of being indirectly
upgraded when the user upgrades the VC++ run-time

Thank you.

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Fri, 19 Apr 2013 23:42:19 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Thanks the tip. More testing in the IDE shows that it works OK even
>when editing the PATH, and I can no longer trigger the  "Unable to
>load DLL 'SQLite.Interop.dll': The specified module could not be
>found. (Exception from HRESULT: 0x8007007E)". Weird.

Got it: "Dependency Walker" shows that the (no-)bundle versions rely
on MSVCR110.DLL, which is part of the "Visual C++ Redistributable for
Visual Studio 2012 Update 1", available here:

www.microsoft.com/en-us/download/details.aspx?id=30679

Once installed, the error goes away.

Maybe the wiki should be edited accordingly.

Thank you.

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Thu, 18 Apr 2013 23:46:58 -0400, markus diersbock
 wrote:
>Since it worked, you can move the files to any final folder, and add a
>reference to System.Data.SQLite.dll
>
>And add your folder to PATH, to find SQLite.Interop.dll

Thanks the tip. More testing in the IDE shows that it works OK even
when editing the PATH, and I can no longer trigger the  "Unable to
load DLL 'SQLite.Interop.dll': The specified module could not be
found. (Exception from HRESULT: 0x8007007E)". Weird.

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Thu, 18 Apr 2013 13:36:54 -0400, markus diersbock
 wrote:
>Put SQLite.Interop.dll in the same folder as your VB assembly (ie
>/debug or /release)

Thanks for the tip.

But it's kind of a pain to have to copy SQLite.Interop.dll +
System.Data.SQLite.dll in \debug with every new project.

Why can't we just keep the two files in a central directory, and just
add a reference through "Project > Add Reference"?

Since the static-bundle version allows this, what is the added value
of the other two (bundle and no-bundle, with dynamic linking to the
VC++ runtime)?

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Thu, 18 Apr 2013 16:10:48 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>It did work finally by using
>
>sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip

I wanted to edit the FAQ to spare other newbies, but even after
logging on as "anonymous" and typing the one-time password, there's no
Edit link anywhere.

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

It doesn't work either with

 sqlite-netFx45-binary-bundle-Win32-2012-1.0.84.0.zip

whether System.Data.SQLite.dll is located in .\Externals or some other
location.

It did work finally by using

sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip

Could it be due to VC++ dependency?

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Thu, 18 Apr 2013 15:32:02 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Does it mean that we have to copy the two files in each and every
>application, instead of just putting them in eg. C:\Windows?

Still no go.

1. Per the FAQ
(http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8),
created .\Externals, and copied whole ZIP there:

===
\bin
\Externals
\My Project
\obj
Form1.resx
WindowsApplication1.vbproj.user
Form1.vb
Form1.Designer.vb
WindowsApplication1.vbproj
===

2. Added reference to "System.Data.SQLite.dll" in \Externals

3. Ran app: "Unable to load DLL 'SQLite.Interop.dll': The specified
module could not be found. (Exception from HRESULT: 0x8007007E)"

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

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

On Thu, 18 Apr 2013 09:27:00 -0400, Kevin Benson
 wrote:

>http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html

Thanks.

"In order for this to work successfully, it must be able to locate
that file at runtime, which means the "SQLite.Interop.dll" file must
reside in the binary directory itself or in the architecture-specific
sub-directory therein.  The download page also covers this setup in
more detail."

Does it mean that we have to copy the two files in each and every
application, instead of just putting them in eg. C:\Windows?

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

[sqlite] [SQLite.Net] Right way to install precompiled binaries?

[Gilles Ganault]

Hello,

I'm having a problem getting VB Express to find SQLite .Net:

1. I went to...
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip

2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\

3. Launched VB Express 2010 to create new Windows Form project

4. Project > Add Reference: Navigated to
"C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
System.Data.SQLite.dll

5. Wrote SQLite test code:

Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand

'Note: Non-admin app cannot write to c:\
SQLconnect.ConnectionString = "Data
Source=c:\users\fred\test.sqlite;"
SQLconnect.Open()

'SQLcommand = SQLconnect.CreateCommand

'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
(type)"
'SQLcommand.ExecuteNonQuery()

'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
('something')"
'SQLcommand.ExecuteNonQuery()

'SQLcommand.Dispose()
SQLconnect.Close()

6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
specified module could not be found. (Exception from HRESULT:
0x8007007E)"

What is the right way to install SQLite.Net so that applications can
find it?

Thank you.

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

Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

[Gilles Ganault]

On Mon, 25 Mar 2013 17:46:17 -0400,
 wrote:
>I installed slqite, its sqlite3 command line interface, and a GUI admin 
>console. Have built and populated a couple of databases. But what I really 
>want to do is to connect to sqlite databases from Visual Studio 2012 using 
>Visual Basic.
>
>Downloaded and installed the SourceForge System.Data.SQLite adaptor... now 
>what?  Is there a set of instructions somewhere for Creating a VS/VB 2012 
>project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?
>
>The instructions on these two pages do not work for me:
>http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
>http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Been there recently.

After installing the .Net SQLite package*, I simply created a new
VB.Net Form project, added a reference to the DLL (Project > Add
Reference), and typed some test code, eg.

www.kirupa.com/net/sqllite_vb_pg1.htm

HTH.

 * there are fundamentaly three of them at their new home
(http://system.data.sqlite.org/). As I didn't get an answer as to when
I would need the setup packages  ("intended to be installed only on
developer machines and then only when the design-time components for
Visual Studio are required"), I downloaded and unzipped the one that
seems recommended for most users, which is the Precompiled Binaries +
no-bundle "sqlite-netFx20-static-binary-Win32-2005-1.0.84.0.zip".

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Fri, 01 Mar 2013 18:08:43 +0100, Bernd Lehmkuhl
 wrote:
>I asked Joe Mistachkin a while back the same. Here's what he replied:
>
>Am 21.09.2012 00:35, schrieb Joe Mistachkin:
>> Bernd wrote:
>>>
>>> Could you elaborate on why I should avoid doing as I do at the moment?
>>>
>>
>> The mixed-mode assembly contains native code for one platform as well as
>> the managed code.  This prevents the same application from being easily
>> deployed on both x86 and x64.
>>
>> I suppose if you only ever deal with one processor architecture on all the
>> target machines, it's just fine to use the bundled packages.
>>
>> Also, mixed-mode assemblies are not supported by Mono or the .NET Compact
>> Framework.

Vielen Dank! Good to finally know what the difference is.

So it looks like the no-bundle is the better option.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Tue, 26 Feb 2013 19:45:27 -0500, Kevin Benson
 wrote:
>> Right, but while the first DLL will be found since it's now part of
>> the project (Project > Add Reference), the wiki doesn't say that this
>> doesn't take care of the other DLL.

>http://www.mail-archive.com/sqlite-users@sqlite.org/msg73039.html

Good to know, although creating an .\x86 or .\x64 doesn't seem to add
anything as compared to simply putting the two DLLs in the
application's directory.

>> Speaking of which, why is the no-bundle version (two DLLs) to be
>> prefered to the bundle version (single DLL)? It solves this issue.

I still didn't find any info on the web about what the difference is.

The wiki says: "All the "bundle" packages contain the
"System.Data.SQLite.dll" mixed-mode assembly. These packages should
only be used in cases where the assembly binary must be deployed to
the Global Assembly Cache for some reason (e.g. to support some legacy
application on customer machines). "

Anyone knows more?

Thank you.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Tue, 26 Feb 2013 18:44:28 -0500, Kevin Benson
 wrote:
>The directory doesn't *HAVE* to be called ...\Externals. You pick the name,
>any name, and then tell Visual Studio, that is all ;-)

Right, but while the first DLL will be found since it's now part of
the project (Project > Add Reference), the wiki doesn't say that this
doesn't take care of the other DLL.

Speaking of which, why is the no-bundle version (two DLLs) to be
prefered to the bundle version (single DLL)? It solves this issue.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Tue, 26 Feb 2013 13:09:10 -0500, Kevin Benson
 wrote:
>Because there are actually a number of different ways the (CLR)untime
>locates assemblies, I ~believe~ the FAQ only attempts to offer a general
>advisement about the "Externals" folder as a *HINT*. The rest is up to the
>programmer.

Thanks for the link to MSDN, but it doesn't mention \Externals, so the
application won't find the other DLL since it's neither in the
application directory nor in the PATH.

Unless there's a better way to install the contents of the non-bundle
ZIP, I think the wiki should simply say that 1) it  contains two DLLs
(the non-managed SQLite DLL, and a managed .Net wrapper), and the
non-managed DLL must be located in a directory that the application
can find.

http://msdn.microsoft.com/en-us/library/823z9h8w.aspx
>in your app.config file in the 

I'll check it out.

Thank you.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

Next, just to check, I reinstalled a fresh Windows7 + VS Express 201
to try the "Precompiled binaries no bundle" this time.

Even with the VC++ 2012 runtime, it still complained about
"SQLite.Interop.dll : The specified module could not be found".

Turns out the wiki is half-wrong: When using the "no bundle" package,
instead of using some "Externals" sub-directory,  it must be unpacked
in either the Debug\Release directory or some location that's part of
the PATH.

http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Tue, 26 Feb 2013 15:28:13 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>but it fails on the second line with "Type SQLiteCommand is not
>defined". Is there another component I need to install?

Got it: It just needs the following line at the top of the file:

Imports System.Data.SQLite

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

After installing "Visual Studio Express 2012 for Windows Desktop", I
downloaded and ran "Setups for 32-bit Windows (.Net Framework 4.5)
bundle 1.0.84.0".

I left the default option checked "Generate native images for the
assemblies and install the images in the native image cache", and
didn't check the other option ("Install the assemblied into the global
assembly cache" + "Install the designer components for Visual Studio
2012") since the design-time component is no longer supported for
Express editions.

Next, I created a new Windows Forms project, and tried adding a
reference to SQLite, but it wasn't listed in Assemblies >
Framework/Extension. So I tried running SQLite's installer.exe:
"Cannot continue, the "confirm" option is not enabled"

So, I used Project > Add Reference, hit "Browse", and pointed to
"System.Data.SQLite.DLL". Seemed OK.

Next, I ran the the following code, which worked OK:
=
Dim SQLconnect As New SQLite.SQLiteConnection()

SQLconnect.ConnectionString = "Data
Source=c:\users\joe\test.sqlite;"
SQLconnect.Open()
SQLconnect.Close()
=

Finally, I tried this code:
=
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand

SQLconnect.ConnectionString = "Data
Source=c:\users\fred\test.sqlite;"
SQLconnect.Open()
SQLcommand = SQLconnect.CreateCommand
SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
('something')"
SQLcommand.ExecuteNonQuery()
SQLcommand.Dispose()
SQLconnect.Close()
=

but it fails on the second line with "Type SQLiteCommand is not
defined". Is there another component I need to install?

Thank you.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Tue, 26 Feb 2013 04:08:26 -0500, Kevin Benson
 wrote:
>*(8) How do I install System.Data.SQLite on a development machine?*

Thanks, but I still want to understand what the difference is between
all the options in the Downloads page

>Strictly speaking, there is no need to install System.Data.SQLite on any
>development machine (e.g. via the setup).

Is "the setup" =  sqlite-netFx40-setup-??-x86-2010-1.0.84.0.exe?

If so, what is the Setup file for, then? Only if we want the
design-time components?

Also, the Bundle packages contain the "System.Data.SQLite.dll
mixed-mode assembly", which is the SQLite C code + the .Net wrapper
built into a single file, to be copied into the GAC.
The wiki says that this is needed "to support some legacy application
on customer machines". Why/when should I worry about other
applications?

>   - Add a reference to the "System.Data.SQLite" assembly from the
>   "Externals" directory.

Should I run the installer.exe that the ZIP contains, so that SQLite
is  registered and available from VB.Net Express?

>*(9) How do I install System.Data.SQLite on end-user machines?*
>
>[...] Installing the assemblies into the Global Assembly Cache
> is not recommended as it may cause conflicts with other
>applications installed on the machine.

Because those other applications might still depend on the Phoenix
version, which is incompatible with the new SQLite version?

Thank you.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Mon, 25 Feb 2013 22:32:26 +, Simon Slavin
 wrote:
>There is no particular version of SQLite installed on your computer, and you 
>don't have to worry about downloading the latest version of SQLite.

I installed it to use SQLite with VB.Net, and would like to upgrade to
the latest version now that SQLite.Ado.Net is handled by the SQLite
team.

I'll uninstall the one from Phoenix Software Solutions, but I'm
puzzled at which package to install from here:

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

Which package should I use for...
- a development host
- a user host
?

Thank you.

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

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

On Mon, 25 Feb 2013 15:18:17 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>When do we need the design-time components? Which package should I use
>for development + deployment onto users' host?

I'm not clear about which package to install on a development host,
and which to install on a customer's host.

1. Here's what I thought I understood:

- Setups: Includes design-time component for VS 2005, and Visual C++
2005 SP1 runtime
- Precompiled Binaries:  The Visual C++ 2012 RTM runtime is not
included
- Precompiled Statically-Linked: The Visual C++ 2005 SP1 runtime for
x86 is statically linked

Setups should only be installed on developer's host, and only if we
actually need the design-time components.
The Precompiled binaries should be  installed on the customer's host
through xcopy.
Use the static packages if the customer doesn't have admin rights to
install the VC++ runtime

Each package is available in two versions:
- bundle = "mixed-mode assembly + all the binaries"; mixed-mode
assembly only necessary when the binary assembly must be installed in
the GAC
- no-bundle = "all the binaries"

2. And here are the questions:
- What does the design-time component offer?

- What applications rely on the binary assembly in the GAC, and hence,
require installing the bundle packages?

3. Am I correct in understanding that the "no-bundle Precompiled
binaries" are usually the right choice, provided the customer can
install the VC++ runtime?

Thank you.

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

[sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

[Gilles Ganault]

Hello

I'm running the 32-bit version of XPSP3, whose "Add and Remove
Programs" show that I have "QQLite ADO.NET 2*0/3.5 Provider 1.065.0"
from Phoenix Software Solutions, LLC (http://sqlite.phxsoftware.com).

Now that SQLite.Ado.Net is handled by www.slite.org, what is the right
way to upgrade to the latest and greatest? 

The wiki says:

"1. The setup packages are intended to be installed only on developer
machines and then only when the design-time components for Visual
Studio are required. In theory, they can be installed on customer
machines as well; however, this type of deployment is not recommended.

2. The binary packages are intended to be used by developers in order
to obtain the assembly binaries necessary for development and
deployment of their applications onto customer machines via XCOPY
deployment. [...]
Using XCOPY deployment in conjunction with the native library
pre-loading feature, especially for customer machines, is highly
recommended."
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

When do we need the design-time components? Which package should I use
for development + deployment onto users' host?

Thank you.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
 wrote:
>It's probably a good way to get something working, but you loose the
>cross-platform

I know, but Windows is 95% of the market for end-users, cross-platform
is a pain to write, they take longer to load and always look/act funny
anyway :-)

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
 wrote:
>There are lots of people who manipulate data that way, but they tend to export
> their data from the SQLite database into their favourite spreadsheet app,
> do the manipulation there, then reimport to SQLite.
> This prevents them from having to use an app which doesn't have
> all the facilities they expect from their spreadsheet app.
>
>The SQLite shell tool (free) makes the export and import processes easy (can 
>be done in one command).

I'll see if there's a good datagrid + SQLite connector for .Net so I
can combine the two and see how it goes.

Thanks all.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt
 wrote:
>The only thing remaining for a decent workflow, which in
>the end is based on SQLite-storage, would then be a small
>batch-program or -script, which ensures the SQLite-To-CSV
>conversion (the sqlite-commandline-tool could do that) -
>accompanied by a second batch-file which ensures the
>back-conversion from CSV to SQLite-DBTable (and maybe
>also already the direct upload to a given WebServer).

Thanks for the idea. I actually do the opposit when I need to sort
data: Export from spreadsheet as CVS > import into SQLite, and run
some SQL commands.

That's why I thought there could be a need for a datagrid that would
save data in SQLite and provide basic sort/search functions.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black"
 wrote:
>Generally speaking database and spreadsheet functionality are not similar
>enough to combine.

Thanks for the input. Indee, maybe the two concepts are just too
different.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin
 wrote:
>If you think you can make money by providing a basic app, write one and market 
>it.
>
>People don't want one.  If they have already paid for and learned to use 
>Excel, they'll use that.
> If they haven't, they'll use anything that's free.  They don't care whether 
> the data engine is SQLite or anything else.

Yup.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 09 Dec 2012 00:04:40 +0100, Olaf Schmidt
 wrote:
>If no such special Formatting is needed, then the
>term "DataGrid" is the more common one, since
>"real SpreadSheet functionality" is usually associated
>with the extended requirements (at individual cell-level)
>I've listed above.

Thanks for the input. Indeed, a datagrid looks more like what I had in
mind, since people using Excel just to build lists probably don't need
that much control.

OTOH, whoever writes that application could always provide two
version: Basic (datagrid) and Pro (spreadsheet).

SQLite being such a great tool, I just find it sad/odd that no one has
come up with a datagrid/spreadsheet for non-techies that saves data in
an SQLite DB. Currently, it's either Excel for most people although
it's not a DB, or Access for the few (or Libre/OpenOffice + ODBC/JDBC,
which is just as hard or harder than Access).

Thank you.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 09 Dec 2012 00:49:03 +0100, Jean-Christophe Deschamps
 wrote:
>What are those $20 suppose to pay for? 

Licenses by users interested in buying that utility optimized to build
lists and sort data much better than in Excel (which isn't meant for
that, but people use it anyway since they don't know any better).

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sat, 08 Dec 2012 23:30:09 +0100, Jean-Christophe Deschamps
 wrote:
>Either use a full-blown SQLite DB manager (e.g. the free version of 
>SQLite Expert among others) or develop a simple script based on an 
>ad-hoc ListView and SQLite functions using something like AutoIt.
>
>In the latter case it can be tailored exactly to your needs, hiding 
>everything too tech-savvy yet giving you full control of how the 
>application would evolve.
>
>Can be made in a couple of hours with AutoIt, providing a stand-alone 
>executable freely distributable and for free.

Thanks, but I was not looking for a hack, but rather an actual
application meant for regular people.

Let's see.

100.000 licenses @ $20 = $2.000.000

Cayman S = $65.000
www.gizmag.com/porsche-cayman/25260/

=> 30 cars.

Kim Dotcom! :-)

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sat, 8 Dec 2012 22:34:28 +, Simon Slavin
 wrote:
>Google 'sqlite database editor'

Thanks. I'll check 'em out, although it's very likely those are meant
for computer people, not regular folks.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sat, 8 Dec 2012 20:58:17 +, Simon Slavin
 wrote:
>On the other hand, if you put in the great amount of effort to write
>a general tool and clean it up so other people can use it,
>it requires enough time that you'll want to charge for your work. 
>Hence the large number of tools out there that aren't free.

Ok, but where are the large number of tools that would do that?

Features:
- very fast, very basic spreadsheet (not based on Excel or
Libre/OpenOffice)
- saves data in SQLite
- very easy to create new tables + columns
- lets the user edit rows/columns as easily as in Excel
- data can be sorted by any column
- access to SQL a plus, but must not be required, as the app is meant
to non-techies

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sat, 8 Dec 2012 09:49:09 -0800, Peter Haworth
 wrote:
>As others have mentioned, there are several third party products out there
>that will do something similar to what you want.  My SQLiteAdmin tool has a
>grid view of data in a table.  You can't edit directly in the table but
>below the table is an area that you could think of as something like an
>Excel form where you can insert and update entries.  I have an enhancement
>request pending to allow direct input to the grid for insert and update
>purposes.

Thanks Peter. I'll add it to the list of things to check. Maybe what I
had in mind was harder to develop, or simpy no one had any need for
it.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 07 Dec 2012 19:01:27 +0100, "noel.frankinet"
 wrote:
>The best route is tcl/tk + sqlite I think, tcl and sqlite works 
>naturally together and tcl/tk has a nice table widget to edit data. 
>Everything can be bundled together with a tclkit. Et voilà, a killer 
>application (portable to linux and macOs too by the way).

Thanks for thip. TCL/TK + SQLite has been mentioned further up in the
thread. I'll check it out.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 20:22:56 -0500,
da...@dandymadeproductions.com wrote:
>Or perhaps MyJSQLView
>Be sure to install Xerial JDBC jar in jre/lib/ext/
>
>http://myjsqlview.org
>http://www.xerial.org

Thanks for the tip. Java + JDBC + SQLite seems a bit heavy, though.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 16:37:51 -0800, Tom Lynn
 wrote:
>Why not use LibreOffice or OpenOffice with the odbc driver for SQLite?

Too heavy just to make a list.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 18:15:11 +, Rob Richardson
 wrote:

>My favorite is SQLiteSpy because it's fast, even though you can't insert or
> update data in its grid view (you have to write insert or update queries
>to do that, which I admit is a pain, but most of the time I'm just looking at 
>data). 
>There are others.  What would this new tool do that those don't?

We could run this experiment: Take basic Excel users, and ask them to
build a list using SQLiteSpy, and see how they fare.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 16:02:13 +, "Duquette, William H (318K)"
 wrote:
>I don't think the OP really cares about linking SQLite to a spreadsheet.
>If I'm reading him correctly, he's just looking for an easy way to
>populate SQLite database tables using a simple GUI he doesn't have to
>develop himself, and doesn't have to pay a lot of money for.  In other
>words, he wants something that's as easy to use as stashing your data in
>an Excel table, but has the power of SQLite.

Exactly. With hundreds of millions of Excel users who actually use
Excel to keep lists, I guess there's a market for a basic/pro Windows
application do that without to invest time and money on Office suites.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 13:43:03 +, "Black, Michael (IS)"
 wrote:
>http://www.sqlmaestro.com
>May do what you want...

Thanks. I'll check that their SQLite tool does.
www.sqlmaestro.com/products/sqlite/

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 08:39:07 -0500, Kevin Benson
 wrote:
>http://sqliteforexcel.codeplex.com/
>
>This project, *SQLite for Excel*, is a lightweight wrapper to give access
>to the SQLite3 library from VBA. It provides a high-performance path to the
>SQLite3 API functions, preserving the semantics of the SQLite3 library
>calls and allowing access to the distributed SQLite3.dll without
>recompilation.

Thanks for the link. It requires buying MS Office, and I don't know if
it provides an easy way for non-techies to create tables and edit
rows. I'll check it out.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 13:37:45 +, Simon Slavin
 wrote:
>Use the free SQLite shell tool downloadable from the SQLite site.
>
>Write your own interface in PHP using the sqlite3 interface which does exactly 
>what you want.

Thanks but before I build my own, I wanted to check that no one had
already built a Windows application with SQLite embedded, available
either as free- or share-ware.

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

Re: [sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Fri, 7 Dec 2012 11:27:57 -0200, Jonas Malaco Filho
 wrote:
>Maybe you can achieve this if you use ODBC connectors and Excel Tables.

Thanks for the info, but having to buy MS Office and install/configure
ODBC is a bit on the heavy site. I for one would be interested in a
basic spreadsheet just to create a table and enter data.

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

[sqlite] Simple SQLite-based spreadsheet?

[Gilles Ganault]

Hello

I need to enter a bunch of items into a table that I can later read
from a web app.

I was wondering if someone had come up with a Windows application that
would...
- use Sqliteto host the data
- make it very easy to add a table anc columns (possibly several
related tables)
- display a spreadsheet to make it easy to add data
?

Namely, a basic, no brainer MS Access relying on SQLite. Considering
so many people use Excel as poor man's database because anyone can use
it while Access takes some learning... I think there's an opportunity
here.

Thank you.

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

Re: [sqlite] Compute percentage?

[Gilles Ganault]

On Wed, 29 Jun 2011 13:21:21 +0200, Roger Andersson
 wrote:
>:) No CAST needed
>SELECT round((COUNT(rowid))/(SELECT COUNT(*)*0.01 FROM people),2) FROM 
>people WHERE zip="12345";

Thanks everyone.

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

Re: [sqlite] Compute percentage?

[Gilles Ganault]

On Wed, 29 Jun 2011 11:33:15 +0200, Roger Andersson
 wrote:
>SELECT (COUNT(rowid)*100)/(select count(*) from people) FROM people WHERE 
>zip="12345";

Thanks, that worked:

SELECT COUNT(*) FROM people;
400599

SELECT COUNT(*) FROM people WHERE zip="12345";
12521

SELECT (COUNT(rowid)*100)/(SELECT COUNT(*) FROM people) FROM people
WHERE zip="12345";
3

Is it possible to display the number with decimals instead of an
integer?

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

[sqlite] Compute percentage?

[Gilles Ganault]

Hello

Using a table that lists people and the zipcode where they live, I
need to compute the percentage of those living in, say, NYC.

I googled for this, but I'm not sure how to do this in SQLite.

I wonder if it's done through a sub-query or maybe some temporary
variable?

This computes the absolute:
SELECT COUNT(rowid) FROM people WHERE zip="12345";

Thank you.

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

Re: [sqlite] Using Unicode to display data?

[Gilles Ganault]

On Tue, 28 Jun 2011 07:48:09 -0400, Richard Hipp
 wrote:
>SQLite uses only unicode (utf8 by default, but it also works with utf16).
>Probably your DBF file was exported as MBCS.  You need to convert the MBCS
>from the export into utf8 or utf16 prior to import into SQLite.

Thanks for the tip. I'll check if the DBD-to-SQLite converter can
export in Unicode.

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

[sqlite] Using Unicode to display data?

[Gilles Ganault]

Hello

After importing DBF files into SQLite, it looks like data are in
Unicode, so I get funny characters when running sqlite3.exe in a DOS
box on Windows:

sqlite> select * from varmod_stent2010 limit 5;
A10|BE|Industrie manufacturiFre, industries extractives et autres
A10|FZ|Construction
A10|GI|Commerce de gros et de dTtail, transports, hTbergement et
restauration
A10|JZ|Information et communication
A10|KZ|ActivitTs financiFres et d'assurance

I typed ".help", but it doesn't seem to include a way to change the
character set. Is there a solution within sqlite3.exe, or is the only
way to write a quick PHP script?

Thank you.

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

Re: [sqlite] Best solution to import big DBF file?

[Gilles Ganault]

On Mon, 27 Jun 2011 18:05:41 +0200, Dominique Pellé
 wrote:
>Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp.

Thanks for the info. I'm not sure I understand what Spatialite is
("The SpatiaLite extension enables SQLite to support spatial data too
[aka GEOMETRY], in a way conformant to OpenGis specifications")  but
I'll give it a shot.

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

Re: [sqlite] Best solution to import big DBF file?

[Gilles Ganault]

On Mon, 27 Jun 2011 17:14:52 +0400, Alexey Pechnikov
 wrote:
>1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite
>http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf

Thanks Alexey, worked the first time:

# dpkg -i sqlite3-dbf_2010.08.16_i386.deb
# sqlite3-dbf myfile.dbf | sqlite3 myfile.sqlite

Thanks everyone.

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

Re: [sqlite] Best solution to import big DBF file?

[Gilles Ganault]

On Mon, 27 Jun 2011 14:22:43 +0100, Carlos Rocha
 wrote:
>I think you'll find what you need here
>http://www.vlsoftware.net/

Thanks for the link.

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

Re: [sqlite] Best solution to import big DBF file?

[Gilles Ganault]

On Mon, 27 Jun 2011 14:57:31 +0200, Stephan Beal
 wrote:
>Google suggests several:

Yes, but I'd like to save time by not having to evaluate them if
someone's done this recently.

There are only two converters listed on the site, and they seem to
require FoxPro for DOS
www.sqlite.org/cvstrac/wiki?p=ConverterTools

I tried opening the 87MB file in OpenOffice, but it still wasn't done
after running for 5mn :-/

>As Simon said, the sqlite3 shell can import structured text files.

But I need to first convert the DBF file into CSV, right?

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

Re: [sqlite] Best solution to import big DBF file?

[Gilles Ganault]

On Mon, 27 Jun 2011 13:42:33 +0100, Simon Slavin
 wrote:
>Dump the contents as text and use the SQLite command-line shell to import it.

Thanks for the tip, but I don't have the DBase application, just the
file (it's actually three files: Two small ones with the column
definitions and their possible values, and the big one with the data).

Is there a way to open a DBF file and get a text dump?

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

[sqlite] Best solution to import big DBF file?

[Gilles Ganault]

Hello

I have a 87MB file in DBF format that I'd like to import into SQLite.

What is the best tool for this, free or affordable?

Thank you.

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

Re: [sqlite] [3070601] Makefile to cross-compile?

[Gilles Ganault]

On Fri, 15 Apr 2011 09:23:10 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>I need to write a Makefile to cross-compile amalgamation-3070601 to
>generate the static and shared libraries.

For the benefit of other newbies who might need this:

BASE=/opt/toolchain
CC=bfin-linux-uclibc-gcc
AR=bfin-linux-uclibc-ar rcu
RANLIB=bfin-linux-uclibc-ranlib

CFLAGS=-O2 -Wall -DSQLITE_THREADSAFE=0 -I.
-I$(BASE)/uClinux-dist/linux-2.6.x/include
LDFLAGS=-Wl,-E -L$(BASE)/uClinux-dist/root/lib -L.

all:
@echo "No target specified."

object:
$(CC) $(CFLAGS) -c sqlite3.c -o sqlite.o

static:
$(CC) $(CFLAGS) -c sqlite3.c -o sqlite3.o
$(AR) libsqlite3.a sqlite3.o
$(RANLIB) libsqlite3.a

shared:
$(CC) $(CFLAGS) $(LDFLAGS) -shared -Wl,-soname,libsqlite3.so
-o libsqlite3.so sqlite3.c

cli: static
$(CC) -static $(CFLAGS) $(LDFLAGS) -o sqlite3 shell.c
-lsqlite3 -ldl

clean:
-rm -rf *\.a *\.o *\.so sqlite3

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

[sqlite] [3070601] Makefile to cross-compile?

[Gilles Ganault]

Hello

I need to write a Makefile to cross-compile amalgamation-3070601 to
generate the static and shared libraries.

Is this the right way?

==
#Path added to PATH
CC=bfin-linux-uclibc-gcc
AR=bfin-linux-uclibc-ar rcu
CFLAGS=-O2 -Wall -I/usr/src/baps/uClinux-dist/linux-2.6.x/include
LDFLAGS=-L/usr/src/baps/uClinux-dist/lib

libsqlite3:
#static
$(CC) $(CFLAGS) -static $(LDFLAGS) -c sqlite3.c -o sqlite.o
$(AR) $@.a sqlite.o

#shared
$(CC) $(CFLAGS) -shared -Wl,-soname,$@.so $(LDFLAGS) -o $@.so
sqlite3.c

clean:
-rm *\.o *\.so
==

Thank you.

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

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

At 22:38 02/12/2010, Mike Frysinger wrote:
>that doesnt really make sense.  just build sqlite in the dist and 
>look at how configure is run.

If I got it right, the SQLite package that lives in the uClinux-dist 
uses the GNU build system 
(http://en.wikipedia.org/wiki/GNU_build_system).
 
Wikipedia tells me it's a richer tool than plain Makefile, but it's 
also harder to follow for newbies like me. That's why I prefered to 
start from a very basic solution and learn how to compile it manually.

>that isnt the blackfin dist

It is (uClinux-dist-2009R1.1-RC4.tar.bz2), but I used the 2007 
toolchain (blackfin-toolchain-07r1.1) to try and compile SQLite 
because that's the one that is used by the device to compile uClinux 
and packages. I figured it wasn't a good idea to compile applications 
using two different releases of the toolchain.

All is fine now, I learned a lot, I can start the Lua interpreter, 
load the LuaSocket module and the LuaSQL module, and create an SQLite 
database. Thanks to everyone in this list for the great help.  

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

Re: [sqlite] EXTERNAL:Re: Cross-compiling SQLite forBlackfin+uClinux?

[Gilles Ganault]

On Thu, 2 Dec 2010 15:17:28 -0500, Eric Smith
 wrote:
>You can do it on the command line -- just try it.  

Sorry guys for being dense: After rereading the above, it clicked: The
"-lpthread" option must be put on the line when linking the three
object files to create the final .so file:

#config
LDFLAGS=-lpthread

#Makefile
src/$(LIBNAME): $(OBJS)
$(CC) $(CFLAGS) $(LDFLAGS) $(LIB_OPTION) -o $@ $(OBJS)
/usr/src/sqlite-3.7.3/preprocessed/libsqlite3.o

I'm surprised, though, that I don't first need to cross-compile the
pthread library before the linker includes it in the final binary
(sqlite3.so).

>gcc == command line tool for preprocessing/compiling/linking C 
>programs.  
>
>GCC == GNU Compiler Collection, a suite of tools for compiling tons of 
>different languages.  See http://gcc.gnu.org.  

Thanks for pointing out the difference.

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

Re: [sqlite] EXTERNAL:Re: Cross-compiling SQLite forBlackfin+uClinux?

[Gilles Ganault]

On Thu, 2 Dec 2010 13:50:30 -0600, "Black, Michael (IS)"
 wrote:
>The -lpthread goes on the FINAL link you do with your OBJS.

Sorry about that :-/ Apparently, gcc will compile and link in one go.
Is a Makefile required to add the -lpthread switch, or can this be
done on the command line?
This is just to learn more. I don't mind whiping off a small Makefile
to do this.

BTW, am I correct in understanding that originally, gcc stood for "GNU
C compiler", while now, gcc is just a language-neutral front-end that
can compile different source files (C, C++, Fortran, etc.) and is
smart enough to guess what type of source files it is handed and call
the right compiler accordingly?

Thank you.

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

Re: [sqlite] EXTERNAL:Re: Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

On Thu, 2 Dec 2010 12:38:18 -0600, "Black, Michael (IS)"
 wrote:
>If you need threadsafe just add -lpthread to your final link

I get an error when using "-lpthread", which I guess makes sense,
since I don't have the pthread library cross-compiled:

=
# bfin-linux-uclibc-gcc -v -O2 -Wall -fpic -lpthread -c -o
libsqlite3.o sqlite3.c
...
bfin-linux-uclibc-gcc: -lpthread: linker input file unused because
linking not done
=

I don't intend to access SQLite through multiple threads anyway, so
it's OK to compile it with "-DSQLITE_THREADSAFE=0".

>The .a and .so file allow your linker to only extract the routines it needs 
>and not the whole thing you would get from the .o file.

Thanks a lot for the education.

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

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

On Thu, 2 Dec 2010 08:06:13 -0600, "Black, Michael (IS)"
 wrote:
>You're linking your two .o into the shared library instead of sqlite3.o
>
>src/$(LIBNAME): $(OBJS)
>$(CC) $(CFLAGS) $(LIB_OPTION) $(DRIVER_LIBS) -o $@ sqlite3.o

Thanks a bunch, problem solved :-) I can now access SQLite from Lua
through LuaSQL on the Blackfin + uClinux device.

However, to get things working, I had to...

1. Recompile SQLite with "-DSQLITE_THREADSAFE=0",or get the following
error:

=
> ./lua
Lua 5.1.4  Copyright (C) 1994-2008 Lua.org, PUC-Rio
> require "luasql.sqlite3"
./lua: can't resolve symbol '_pthread_mutexattr_init'
=

For those interested, here's the command I used:

cd /usr/src/sqlite-3.7.3

#Unpacked the Blackfin toolchain in /opt
/opt/uClinux/bfin-linux-uclibc/bfin-linux-uclibc/bin/gcc
-DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION -v -O2 -Wall -fpic
-c -o libsqlite3.o sqlite3.c

2. LuaSQL's Makefile had to include the two LuaSQL object files and
the SQLite object file:

=
src/$(LIBNAME): $(OBJS)
$(CC) $(CFLAGS) $(LIB_OPTION) -o $@ $(OBJS)
/usr/src/sqlite-3.7.3/preprocessed/libsqlite3.o

$(OBJS):
$(CC) $(CFLAGS) $(INCS) $(DRIVER_INCS) -c $*.c -o $@
=

Just out of curiosity, I was wondering...

1. Why does GAS display "/../../../" when compiling SQLite?

=
...
Compiler executable checksum: ca267839d6237ba3b9dd06cf21e83f67

/opt/uClinux/bfin-linux-uclibc/lib/gcc/bfin-linux-uclibc/4.1.1/../../../../bfin-linux-uclibc/bin/as
-v -mfdpic -o libsqlite3.o /tmp/ccdSXIe3.s
GNU assembler version 2.17 (bfin-linux-uclibc) using BFD version 2.17
=

Is it because I'm not using a Makefile, and GCC has to look around to
located the assembler?

2. I'm confused about the difference between .o and .a: Why do I need
to use a .a when compiling a static library into an executable, while
I had to use the .o to compile SQLite into the LuaSQL shared library?

Thanks again.

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

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

At 17:47 01/12/2010, Mike Frysinger wrote:
>why dont you consult the Blackfin uclinux-dist to see how it's doing it ?

I did, but it's the same code as from www.sqlite.org so doesn't 
contain infos on what parameters to pass "configure" to compile for 
the Blackfin.

After cd'ing to /usr/src/uClinux-dist/lib/sqlite/sqlite-3.6.14.1/, I 
tried the following, which seems to have successfully compile SQLite3 
as a static library:

./configure 
CC="/opt/uClinux/bfin-linux-uclibc/bfin-linux-uclibc/bin/gcc" 
CFLAGS="-v -O2 -Wall -fpic" --host=bfin

make

.libs/libsqlite3.a is 387.668 bytes

Thank you. 

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

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

On Wed, 1 Dec 2010 11:10:54 -0600, "Black, Michael (IS)"
 wrote:

>I don't think you need to do the LDFLAGS thing...
> 
>gcc -O2 -fpic -shared -Wl,-soname,sqlite3.so -o sqlite3.so sqlite3.c
> 
>Works fine for me.  Though I'm not using the Blackfin compiler...

Thanks Michael for the tip. The compiling seems to work... but the
final sqlite3.so is not usable: "./lua: can't resolve symbol
'_sqlite3_open'"

Here's what I did:

http://pastebin.com/NeW7vW62

The LuaSQL for Sqlite3 with SQLite statically compiled is only 38.172
bytes, and when I try to "require "luasql.sqlite3"", I get "can't
resolve symbol '_sqlite3_open'".

Obviously, I'm doing something wrong here.

Any tip much appreciated.

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

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

On Wed, 01 Dec 2010 17:28:29 +0100, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>Any help appreciated on cross-compiling SQLite using the Autoconf
>tool.

Without necessarily knowing what I'm doing, the following does compile
without errors:

CC="/opt/uClinux/bfin-linux-uclibc/bfin-linux-uclibc/bin/gcc"
CFLAGS="-pedantic -Wall -O2 -fpic" LDFLAGS="-shared -fpic
-Wl,-soname,sqlite3.so" ./configure --host=bfin --disable-readline

However, while .libs/libsqlite3.a (508.402 bytes) and ./sqlite3
(603.161 bytes) look nice, ./sqlite3.so is only 9308 bytes. There's
something fishy :-/

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

[sqlite] Cross-compiling SQLite for Blackfin+uClinux?

[Gilles Ganault]

Hello

I need to cross-compile SQLite on an x86 Ubuntu host for a device
using the Blackfin CPU and the uClinux distribution.

I downloaded sqlite-amalgamation-3.7.3.tar.gz, since it's "the
recommended source distribution for all Unix and Unix-like platforms".

Then, I read the README and INSTALL, but am a bit lost at wether to
use both the --build and --host variables, and what to use as
settings. "config.sub" contains a reference to "bfin". Likewise, I
don't really know what variables to pass to ./configure.

Any help appreciated on cross-compiling SQLite using the Autoconf
tool.

Thank you.

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

Re: [sqlite] Sync SQLite with smartphones?

[Gilles Ganault]

On Sun, 3 Oct 2010 17:07:04 +0100, Simon Slavin
 wrote:
>There are several tools around to synchronise specific databases,
>and they depend on knowing how those specific databases work
> and what the data means.  But devising a general synch tool that
> would be useful for every database is far more difficult.

Thanks for the feedback.

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

[sqlite] Sync SQLite with smartphones?

[Gilles Ganault]

Hello

I was wondering if someone came up with a tool to sync an SQLite
database with smartphones (Blackberry, iPhone, Android, etc.)?

I've read about SyncML and OpenSync, but they seem to be still under
development.

Thank you.

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

Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

[Gilles Ganault]

On Tue, 27 Jul 2010 22:56:23 -0700, Roger Binns
 wrote:
>You can if you quote it.  Note use double quotes to quote table & column
>names, single quotes for strings.  You can also quote names using square
>brackets - eg [table name].

Thanks Roger for the tip.

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

Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

[Gilles Ganault]

On Tue, 27 Jul 2010 14:40:11 +0200, Gilles Ganault
<gilles.gana...@free.fr> wrote:
>I'm having a problem with this PHP5 script running under Nginx +
>PHP5-FPM and PDO-SQLite3

Found it: For newbies like me... "table" is a reserved name so cannot
be used as a name to table:


#BAD $dbh->exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255))"); 
#BAD $dbh->exec("INSERT INTO table (name) VALUES ('dummy')");

$dbh->exec("CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY
AUTOINCREMENT, name VARCHAR(255))"); 
$dbh->exec("INSERT INTO mytable (name) VALUES ('dummy')");


HTH,

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

[sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

[Gilles Ganault]

Hello

I'm having a problem with this PHP5 script running under Nginx +
PHP5-FPM and PDO-SQLite3:
=
exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255))"); 
$dbh->exec("INSERT INTO table (name) VALUES ('dummy')");

$dbh = null;
  } catch(PDOException $e) { 
  echo $e->getMessage();
  }
?> 
=

The script successfully creates the database file... but it remains
empty, with no error message reported.

FWIW, Nginx spawns child processes (threads?) as www-data, PHP5-FPM
does the same, and the www directory is owned by www-data:

=
# ps aux | grep -i -e nginx -e php5 | grep -v grep

root   nginx: master process /usr/sbin/nginx
www-data   nginx: worker process

root   /usr/bin/php5-fpm --fpm-config /etc/php5/fpm/php5-fpm.conf
www-data   /usr/bin/php5-fpm --fpm-config /etc/php5/fpm/php5-fpm.conf
=
# ll /var/www/nginx-default/

drwxr-xr-x  6 www-data www-data 4096 2010-07-27 14:24 ./
drwxr-xr-x  3 root root 4096 2010-07-27 13:00 ../

-rw-r--r--  1 www-data www-data0 2010-07-27 14:21 dummy.sqlite

-rw-r--r--  1 www-data www-data  565 2010-07-27 14:24
sqlite3_pdo_test.php
=

Thank you for any hint.

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

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

[Gilles Ganault]

On Sat, 24 Jul 2010 18:50:05 +0200, Kees Nuyt
 wrote:
>There's also pdo_sqlite_external which uses the sqlite3.dll
>the user provides, so you can use the latest and greatest
>sqlite version without having to wait for incorporation in
>PHP or PDO itself.

Thanks guys for the input. I'll check when sqlite_busy_timeout() is
added to the SQLite3 in PHP5, and use PDO if it doesn't come out soon
enough.

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

[sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

[Gilles Ganault]

Hello

I'm using the pre-compiled PHP5-FPM/FastCGI (www.php-fpm.org) which
seem to contain the following DB connectors:

PDO drivers mysql, sqlite, sqlite2
pdo_mysql 5.1.48
pdo_sqlite 3.6.22

SQLite 2.8.17
sqlite3 3.6.22

So from the above, it looks like this binary supports access to
MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented
modes.

If that's correct, and provided the application doesn't need to be
DB-agnostic... why should I choose PDO instead of the procedural
functions to SQLite3?

Thank you.

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

[sqlite] Building OpenWrt-style ipkg package?

[Gilles Ganault]

Hello

Using the script below to build an ipkg package for OpenWrt, I need to
add the command-line exe, ie. sqlite3.exe on Windows:

=
# cat sqlite3.mk 
#
# sqlite3 for the Blackfin 
# David Rowe March 2008
#
# usage: make -f sqlite3.mk sqlite3-package
#
# Thanks OpenWRT for build options

include rules.mk

SQLITE3_VERSION=3.5.6
SQLITE3_DIRNAME=sqlite-$(SQLITE3_VERSION)
SQLITE3_DIR=$(BUILD_DIR)/$(SQLITE3_DIRNAME)
SQLITE3_SITE=http://www.sqlite.org
SQLITE3_SOURCE=sqlite-$(SQLITE3_VERSION).tar.gz
SQLITE3_CONFIGURE_OPTS = --host=bfin-linux-uclibc \
--prefix=$(TARGET_DIR) \
--enable-shared \
--disable-static \
--disable-tcl \
--libdir=$(STAGING_LIB)

TARGET_DIR=$(BUILD_DIR)/tmp/sqlite3/ipkg/sqlite3
PKG_NAME:=sqlite3
PKG_VERSION:=$(SQLITE3_VERSION)
PKG_RELEASE:=1
PKG_BUILD_DIR:=$(BUILD_DIR)/tmp/sqlite3

STAGING_INC=$(STAGING_DIR)/usr/include
STAGING_LIB=$(STAGING_DIR)/usr/lib
export CFLAGS=-mfdpic -Os -I$(STAGING_INC)
export LDFLAGS=-L$(STAGING_LIB)

$(DL_DIR)/$(SQLITE3_SOURCE):
mkdir -p dl
wget -P $(DL_DIR) $(SQLITE3_SITE)/$(SQLITE3_SOURCE)

$(SQLITE3_DIR)/.unpacked: $(DL_DIR)/$(SQLITE3_SOURCE)
zcat $(DL_DIR)/$(SQLITE3_SOURCE) | tar -C $(BUILD_DIR) -xf -
touch $(SQLITE3_DIR)/.unpacked

$(SQLITE3_DIR)/.configured: $(SQLITE3_DIR)/.unpacked
cd $(SQLITE3_DIR); ./configure $(SQLITE3_CONFIGURE_OPTS)
touch $(SQLITE3_DIR)/.configured

sqlite3: $(SQLITE3_DIR)/.configured
cd $(SQLITE3_DIR); make install

mkdir -p $(TARGET_DIR)/bin
mkdir -p $(TARGET_DIR)/lib
cp $(STAGING_LIB)/libsqlite3.so.0.8.6 $(TARGET_DIR)/lib
ln -sf libsqlite3.so.0.8.6 $(TARGET_DIR)/lib/libsqlite3.so 
ln -sf libsqlite3.so.0.8.6 $(TARGET_DIR)/lib/libsqlite3.so.0
$(STRIP) $(TARGET_DIR)/lib/libsqlite3.so.0.8.6

# mv include files to staging

cp $(TARGET_DIR)/include/* $(STAGING_INC)
rm -Rf $(TARGET_DIR)/include

# doc

mkdir -p $(TARGET_DIR)/usr/doc
cp doc/sqlite3.txt $(TARGET_DIR)/usr/doc

touch $(PKG_BUILD_DIR)/.built

all: sqlite3

dirclean:
rm -rf $(SQLITE3_DIR)

define Package/$(PKG_NAME)
  SECTION:=utils
  CATEGORY:=Utilities
  TITLE:=SQLite (v3.x) database engine
  DESCRIPTION:=\
SQLite is a small C library that implements a self-contained,
\\\
embeddable, zero-configuration SQL database engine.
  URL:=http://www.sqlite.org/
endef

# post installation

define Package/$(PKG_NAME)/postinst
endef

# pre-remove
define Package/$(PKG_NAME)/prerm
endef

$(eval $(call BuildPackage,$(PKG_NAME)))

sqlite3-package: sqlite3
$(PACKAGE_DIR)/$(PKG_NAME)_$(VERSION)_$(PKGARCH).ipk
=

I have no experience with this sort of thing: If someone's already
done this, would you tell me what to add to the above script?

Thank you.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Tue, 1 Jun 2010 15:13:57 -0400, Doug Currie
 wrote:
>You may find eLua interesting.  http://www.eluaproject.net/ 
>The supported platforms are heavily ARM based, but in the same performance 
>class as Blackfin.

Thanks very much for the link. I'll go check if it can be compiled for
the Blackfin.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Tue, 1 Jun 2010 11:33:36 -0400 (EDT), Rob Sciuk
 wrote:
>As you may be aware, SQLite and Tcl/Tk have an affinity which was not 
>entirely accidental.  There are threads which discuss compiling Tcl for
>Arm/Linux:
>
>(http://objectmix.com/tcl/15449-how-cross-compile-tcl8-4-tk8-4-arm-linux.html)
>
>And you might find some binaries in various places:
>
>(http://www.evolane.com/)
>
>If your Arm platform is a full blown Linux with the development 
>environment, the problem is further reduced to a simple ./configure ; make 
>; make install (or two) rather than a cross compilation using a Canadian 
>Cross (tricky).

Actually, it's a Blackfin processor, and since it's an embedded
environment, RAM and storage (NAND) are an issue.

I'll check if it's possible to compile EvoWeb for that platform.

Thank you.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov
 wrote:
>For Delphi I successfully used files from http://www.aducom.com to
>statically link sqlite files compiled with bcc (Borland command-line c
>compiler freely available now) with Delphi. Also the components of
>aducom.com will allow you to use all the power of Delphi database components
>with the sqlite without necessity to provide any additional dlls.

Thanks for the tip on Delphi + Aducom, but as I definitely need a
cross-platform solution, I guess that won't do it.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque
 wrote:
>Look for C++ QT framework! http://qt.nokia.com/ 

Thanks, I'll check it out.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Tue, 1 Jun 2010 11:57:29 +0100, Simon Slavin
 wrote:
>The obvious solution is to use PHP, and have it use one of the three 
>avaialable sets of SQLite calls.

Can I compile a PHP script + modules into something that will run on
embedded devices? They don't have enough RAM to run eg. Apache +
mod_php.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Tue, 1 Jun 2010 05:49:27 -0500, "Black, Michael (IS)"
 wrote:
>About the only thing you'll find cross-platform + embedded is C/C++

Yes, it looks like it's pretty much it. I'll check Lua, though, to see
whether the modules I need are either in Lua, or are writte in C and
can be compiled to whatever CPU I need.

Thanks for the tip on Code::Blocks.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov
 wrote:
>For Delphi I successfully used files from http://www.aducom.com to
>statically link sqlite files compiled with bcc (Borland command-line c
>compiler freely available now) with Delphi. Also the components of
>aducom.com will allow you to use all the power of Delphi database components
>with the sqlite without necessity to provide any additional dlls.

Thanks for the tip. The problem is that I'd like a cross-platform
solution so that the HTTP + SQLite solution runs on Windows and Linux
(and in the case of Linux, ideally, should also compile on platforms
other than x86 such as embedded devices).

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

Re: [sqlite] [Windows] Application to let end-users handle records?

[Gilles Ganault]

On Tue, 18 May 2010 17:03:17 +0100, Bart Smissaert
 wrote:
>This is a VB6 procedure (in an ActiveX dll) that handles this.
>Obviously there are a lot of secondary routines that you don't have,
>but I think you will get the general idea of what is going on here.

Thanks a lot for the source code.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Sat, 22 May 2010 14:09:18 +0200, Peter Rodwell
 wrote:
>Take a look at REALbasic (http://www.realsoftware.com/), now called
>REALStudio. It has SQLite support built in (and support for other
>dabases such as MySQL). The same source code can be compiled simultaneously
>for Windows (32-bit only for now), Linux and Mac.

Thanks for the tip. However, it's proprietary and a bit pricey, so I'd
rather investigate writing an HTTP + SQLite combo before choosing that
solution.

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

Re: [sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as not signed"

[Gilles Ganault]

On Fri, 21 May 2010 21:32:13 -0400, Rich Rattanni
 wrote:
>BloodShed Dev-C++ and ming?  My choice for windows development.
>
>On Fri, May 21, 2010 at 11:01 AM, Richard Hipp  wrote:
>> This appears to be a bug in your compiler.  The compiler is segfaulting.
>> Can you use a different compiler?

Sure, I'll try DevC++ and Ming. Thank you.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 14:34:56 +0200, "A.J.Millan"
 wrote:
>Not to say that in PHP you can't link any thing. But perhaps respond to your 
>condition of a simpler language than C that would still be able to include 
>SQLite.
>
>There you end with a single script, not an stand alone executable.

Right, but PHP would require a lot more bagage than a stand-alone
executable. I'll try the different solutions provided in this thread.

Thank you.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 07:13:48 -0500, "Black, Michael (IS)"
 wrote:
>I took a look at freebasic and sqlite3 support is already included
>./examples/libraries/DB/sqlite3_test.bas
>
>And it worked for me on my Linux system.
> 
>You need to just compile sqlite3.c into a linkable library or add sqlite3.o to 
>your compile line.
> 
>So you can do
>fbc sqlite3_test.bas -lsqlite3
>Or
>fbc sqlite3_test.bas sqlite3.o
> 
>You didn't say what plafform you're running on so I assume 32-bit Windows?

Thanks a lot. I'll try to compile a prototype in FB for Windows and
see how it goes.

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

Re: [sqlite] Fw: What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 14:46:50 +0200, "A.J.Millan"
 wrote:
>Some time ago I used DevC++ with SQLite (it is a Ligth API that uses the GNU 
>tool chain), but if your planned target is M$, the definitive choice is 
>Visual Studio Express.

OK, I'll try to install MS VS Express on a test host.

Thanks everyone.

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

Re: [sqlite] what languages

[Gilles Ganault]

On Fri, 21 May 2010 15:23:13 +0200, Jean-Christophe Deschamps
 wrote:
>AutoIt, while a scripting language can be seen and used as a RAD 
>platform.  It enjoys good support, up to date SQLite embedding and 
>executables produced can include any file your application needs, like 
>a DB, help files.  In case you need no-installation executables and 
>mono-threaded general purpose platform for Windows with easy to lear 
>Basic-like language and a huge library, this can be a very good choice.

I'll check it out along with MS VS Express. Thank you.

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

Re: [sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as notsigned"

[Gilles Ganault]

On Fri, 21 May 2010 09:23:58 -0400, Pavel Ivanov
 wrote:
>C language wasn't changed so much for the last 2 years. I'd say it
>wasn't changed at all. So I believe any even 5- or 10-year-old
>compiler will be able to do that.

I should have meant: Will this compiler include whatever libraries
SQLite might require for a successful compiling.

Or maybe the error I got with Lcc32 isn't due to some absent
dependency but is due to something else.

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

Re: [sqlite] Fw: What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 14:23:04 +0200, "A.J.Millan"
 wrote:
>Due the fact that you already know C and as my 2 cents to the question, 
>depending on your requirements, perhaps would have a look to PHP.
>
>As far as I know, you can use directly SQLite from that language and perhaps 
>you find it simple to use; easy to port between platforms and direct and 
>easy to debug.

Thanks but I'd like to pack the main application and SQLite into a
single executable, so languages like Python, PHP, etc. aren't good
solutions.

Is MS Visual Studio the recommended solution to compile present-day
SQLite, or are there lighter, open-source compilers that I could use
instead?

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

Re: [sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as notsigned"

[Gilles Ganault]

On Fri, 21 May 2010 06:49:08 -0500, "Black, Michael (IS)"
 wrote:
>I would recommend Code::Blocks which will give you a GUI to work with too
>http://www.codeblocks.org/

Thanks for the link. Apparently, Code::Blocks hasn't been updated in
two years:
http://www.codeblocks.org/downloads/binaries

Would this be a problem when trying to compile and link the latest
SQLite source code?

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

[sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as not signed"

[Gilles Ganault]

Hello

I'm a C newbie, and would like to compile a small C project that will
include a main.c along with sqlite3.c and sqlite3.h (ie. the
amalgamated version of the SQLite source code). This is an alternative
to trying to use SQLite from an another language while still being
able to pack both the main app and SQLite into a single EXE.

After successfully building and running the "Hello, world" to make
sure Lcc32 was correctly installed, I simply added sqlite3.h and
sqlite3.c to the project, without any "include" since I just wanted to
check that it compiled OK:

=
int main(void)
{
printf("Hello\n");
return 0;
}
=

But when hitting "Compiler > Make" in the Wedit IDE, I get the
following errors:
=
Warning c:\lcc\projects\sqlite\sqlite3.c: 12365  Statement has no
effect
Warning c:\lcc\projects\sqlite\sqlite3.c: 12379  Statement has no
effect
Warning c:\lcc\projects\sqlite\sqlite3.c: 12393  Statement has no
effect
Error c:\lcc\projects\sqlite\sqlite3.c 12462 Compiler error (trap).
Stopping compilation
=

Google didn't return information on this error. Does someone know what
the problem is, and if not, what other open-source C compiler for
Windows I should use for this small, one-off project?

Thank you.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 06:28:20 -0500, "Black, Michael (IS)"
 wrote:
>It looks like FreeBasic should work
>http://www.freebasic.net/
> 
>You just have to build the include file -- hopefully that's not too hard for 
>you as you probably only need a few of the functions.

I'll give it a try. Thanks everyone.

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

Re: [sqlite] What languages can include SQLite statically?

[Gilles Ganault]

On Fri, 21 May 2010 12:11:39 +0200, Jean-Denis Muys
 wrote:
>Well the answer is: any language with an external interface to the C ABI can
>link to the SQLite compiled C object code

Thanks for the explanation. Ideally, the executable should be a
simpler language than C that would still be able to include SQLite so
that I would end up with a single executable.

Apparently, there are two solutions:
- use C/C++, and just include sqlite.c + sqlite.h in the project
- compile the SQLite source code into OBJ, compile this OBJ with the
executable, and somehow call the SQLite functions from the main
program.

Does someone know of a BASIC-like language (ie. with an easy syntax
like Python, Lua, etc.) that can include the SQLite OBJ file?

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

[sqlite] What languages can include SQLite statically?

[Gilles Ganault]

Hello

My C skills are very basic. I was wondering: After compiling SQLite
into an .OBJ or .LIB file, what languages can be used to include this
output into a main program, so we end up with a single EXE.

I assume we have the choice of:
- C
- C++
- Delphi (?)
- Other?

Thank you.

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

Re: [sqlite] Accessing SQLite from PHP5?

[Gilles Ganault]

On Thu, 20 May 2010 11:42:31 +0100, Simon Slavin
 wrote:
>Releases of SQLite are far more frequent than new releases of PHP, so the 
>answer won't help you much.

Thanks a bunch for the links.

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