Re: [sqlite] Simple SQLite-based spreadsheet?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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"

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

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?

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

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/d

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

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] [SQLite.Net] Right way to install precompiled binaries?

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

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

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

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

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? >>> >> >>

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

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.

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

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

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

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

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

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

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

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: Impo

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

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

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

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

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

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

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

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 whic

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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. >

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

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

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

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

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

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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

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

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.

Re: [sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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,

Re: [sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Simple SQLite-based spreadsheet?

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

[sqlite] Simple SQLite-based spreadsheet?

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

Re: [sqlite] Compute percentage?

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

Re: [sqlite] Compute percentage?

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

[sqlite] Compute percentage?

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

Re: [sqlite] Using Unicode to display data?

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

[sqlite] Using Unicode to display data?

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

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

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

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

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

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

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

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

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

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

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

[sqlite] Best solution to import big DBF file?

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

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

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-u

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

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

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

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

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

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

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

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

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

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: = #

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

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,

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

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

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

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

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

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/

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

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

Re: [sqlite] Sync SQLite with smartphones?

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

[sqlite] Sync SQLite with smartphones?

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

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

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.

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

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:

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

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;

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

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

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

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)

[sqlite] Building OpenWrt-style ipkg package?

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

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

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

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

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: >

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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. >>

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

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

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

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

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

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

Re: [sqlite] what languages

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

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

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

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

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

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

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:

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

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

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

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

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

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

[sqlite] What languages can include SQLite statically?

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.

Re: [sqlite] Accessing SQLite from PHP5?

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

  1   2   3   >