Re: [sqlite] Simple SQLite-based spreadsheet?

On Fri, Dec 7, 2012 at 12:49 PM, Gilles Ganault wrote: > 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 datab

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 >application (portable to linux

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 http://sqlite.org:8080/cgi-bin/mailman/listi

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 I'm just looking at >data).

[sqlite] Subject: Re: 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 Sqlite to host the data > - make it very easy to add a table anc columns (possibly several > related table

Re: [sqlite] Simple SQLite-based spreadsheet?

Why not use LibreOffice or OpenOffice with the odbc driver for SQLite? I do it with Excel a lot and just confirmed you can access it with these open source tools, too. On Fri, Dec 7, 2012 at 10:15 AM, Rob Richardson wrote: > There's several GUI-based SQLite tools available now. Maestro was alre

Re: [sqlite] Simple SQLite-based spreadsheet?

There's several GUI-based SQLite tools available now. Maestro was already mentioned. 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'

Re: [sqlite] Simple SQLite-based spreadsheet?

Le 7/12/2012 18:49, Gilles Ganault a écrit :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

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 he doesn't have to >develop himse

Re: [sqlite] dates and optimizations

On 12/7/2012 11:35 AM, Simon Slavin wrote: most of my systems store dates as strings in this format "MMDD". Better still (IMHO), integers in the format MMDD (e.g. 20121207). Integers are stored a bit more compactly by SQLite, and are compared slightly faster. And you

Re: [sqlite] BUG:"insert or replace" doesn't works for External Content FTS4 Tables

On 12/07/2012 11:17 PM, Alexey Pechnikov wrote: What does the following: SELECT * FROM view_address_exists WHERE rowid=64402; sqlite>SELECT "sys_title:hash" FROM view_address_exists WHERE rowid=64402; "sys_title:hash" e9b4d0bcb5 But what does "SELECT * FROM ..." return? According to

Re: [sqlite] dates and optimizations

> > > But do you really do things like run a search on "invoices made ​​on a Monday > in February" ? Yes. For example, in a store, it is useful to have sales statistics by day of the week, or by time slot, etc.. > Most of the time I store a date I'm storing it for three purposes: > > A) t

Re: [sqlite] dates and optimizations

On 7 Dec 2012, at 4:24pm, Paxdo Presse wrote: > select invoice.date from invoice where strftime('%m', invoice.date)='02' and > strftime('%w', invoice.date)='1' > > For invoices made ​​on a Monday in February. > From your experience, these requests are they fast? 'fast' is the wrong question.

[sqlite] dates and optimizations

Hello, To search and sort the dates in SQLite, the SQL methods (strftime and date) are they fast enough on long dates (as '2012-12-07 01:48:45')? Or would you prefer to store separately the day, year, etc..? example: select invoice.date from invoice where strftime('%m', invoice.date)='02' a

Re: [sqlite] BUG:"insert or replace" doesn't works for External Content FTS4 Tables

> What does the following: > > SELECT * FROM view_address_exists WHERE rowid=64402; > sqlite> SELECT "sys_title:hash" FROM view_address_exists WHERE rowid=64402; "sys_title:hash" e9b4d0bcb5 About documented "When a row is deleted from an external content FTS4 table, FTS4 needs to retrieve the

Re: [sqlite] Simple SQLite-based spreadsheet?

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 so

Re: [sqlite] Simple SQLite-based spreadsheet?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Freitag, 7. Dezember 2012 16:38:05, David Bicking wrote: >> From: 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 P

Re: [sqlite] Simple SQLite-based spreadsheet?

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

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 list sqlite-users@sqlite.or

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, preserving the semantics of

Re: [sqlite] disk image malformed

On 7 Dec 2012, at 1:36pm, dd wrote: > Thank you Simon. > > So I have to stop using database when error between 1 to 26. You have to stop when you get any code you do not have specific logic to handle. Here is the list of result codes: You can expe

Re: [sqlite] Simple SQLite-based spreadsheet?

http://www.sqlmaestro.com May do what you want... Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sql

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 that no one had already

Re: [sqlite] Simple SQLite-based spreadsheet?

On Fri, Dec 7, 2012 at 7:04 AM, Gilles Ganault wrote: > 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

Re: [sqlite] Simple SQLite-based spreadsheet?

On 7 Dec 2012, at 1:34pm, Gilles Ganault wrote: > 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. Oh, I thought you were specifically asking fo

Re: [sqlite] disk image malformed

Thank you Simon. So I have to stop using database when error between 1 to 26. If I use new database connection (sqlite3*) for every query, will it cause disk io error? I am encrypting database with secret key. I changed page size also. Can sqlite handle encrypted database and different page size

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 in a basic spreadsheet just t

Re: [sqlite] Simple SQLite-based spreadsheet?

Maybe you can achieve this if you use ODBC connectors and Excel Tables. *Jonas Malaco Filho* 2012/12/7 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 >

Re: [sqlite] Simple SQLite-based spreadsheet?

On 7 Dec 2012, at 12:04pm, Gilles Ganault wrote: > Namely, a basic, no brainer MS Access relying on SQLite. Have you see this ? http://sqlite.awardspace.info/syntax/sqliteodbc.htm Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

[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 s

Re: [sqlite] BUG:"insert or replace" doesn't works for External Content FTS4 Tables

On 12/07/2012 06:17 PM, Alexey Pechnikov wrote: "insert or replace" doesn't trigger updating of the FTS index but only 'rebuild' do it: sqlite> .s address_fts0 CREATE VIRTUAL TABLE "address_fts0" USING fts4(content="view_address_exists", "sys_title:hash"); sqlite> select rowid,"sys_title:hash

[sqlite] BUG:"insert or replace" doesn't works for External Content FTS4 Tables

"insert or replace" doesn't trigger updating of the FTS index but only 'rebuild' do it: sqlite> .s address_fts0 CREATE VIRTUAL TABLE "address_fts0" USING fts4(content="view_address_exists", "sys_title:hash"); sqlite> select rowid,"sys_title:hash" from address_fts0 where "sys_title:hash" match 'e7

Re: [sqlite] compiler warnings (was: AsyncIO fails with current 3.7.15 trunk)

Lucky you ;) With GCC set to "max. bitchiness" and when compiling individual sources I need to add the following flags (not all may be currently necessary, but were so in the past). SQLite still works though :))) alter= -Wno-cast-qual -Wno-write-strings -Wno-sign-compare

Re: [sqlite] AsyncIO fails with current 3.7.15 trunk

Ralf Junker wrote: > > 1. > > ext/async/README.txt spells "superceded" which is apparently a common > misspelling of "superseded". http://en.wiktionary.org/wiki/supercede > > 2. > > ext/async/sqlite3async.h defines these two prototypes without void which > causes my compiler to issue warnings:

Re: [sqlite] AsyncIO fails with current 3.7.15 trunk

On 07.12.2012 00:19, Joe Mistachkin wrote: > Could you please try the changes in: > > http://www.sqlite.org/src/info/c507ca4a8e > > and then let us know if this clears the issue you are seeing? Yes, this clears my issues. Many thanks for the quick fix! Looks like it updates AsyncIO to s

Re: [sqlite] Tracing latencies

On Fri, Dec 7, 2012 at 3:28 PM, Keith Chew wrote: > > We can see the times taken to do the syscalls are fast, so what is > causing the delay between the seek and write? I had a look at the > code, and found the method seekAndWrite(), which looks pretty straight > forward. The only time it could be