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

2014-03-12 Thread 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

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-12 Thread Joe Mistachkin
Stefano Ravagni wrote: > > i use a code like this: > > If Dati.HasRows = True Then > sorgente.DataSource = Dati > . > . > end if > > If Dati.HasRows = True then > . make something others > end if > My reading of MSDN indicates that the

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-12 Thread Joe Mistachkin
Stefano Ravagni wrote: > > i encounter problem with datareader hasrows properties... > Do you have some example code that demonstrates the issue? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] very slow fdsync() calls

2014-03-12 Thread Jono Poff
Thankyou both for the suggestions. I set locking_mode=EXCLUSIVE and journal_mode=PERSIST but sqlite still fsyncs the directories. I'll try building with SQLITE_DISABLE_DIRSYNC, but hoping for a config only fix :) I'll post another question to the list when I've explored these options a bit

Re: [sqlite] Exception when querying a range index

2014-03-12 Thread St. B.
Ok, I have updated my database with analyze so that stat1 and stat4 tables have been created. I also have added an index to a table, in order to get rid a an auto index warning after each query. It seems that now out of some "Database locked" errors, I am not getting the original error message

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

2014-03-12 Thread big stone
Hi Gilles, Only Base and Access seem to fit your broad requirements. With SQliteStudio.pl you can feed a sqlite database, but won't have form and reports. What don't you like in base solution that made you ask for other ideas ? ___ sqlite-users

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

2014-03-12 Thread David Bicking
On 03/12/2014 08:05 AM, Gilles Ganault wrote: 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

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.4.1-1 for Cygwin/Cygwin64

2014-03-12 Thread Jan Nijtmans
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine Changes since 3.8.3.1-1 = * Updated to upstream 3.8.4.1 release. See: * Two new Cygwin

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-12 Thread Keith Christian
Jan, Good catch: I was in the tea/ directory, building the DLL for use with TEA on Cygwin at the outset of this thread. When I ran my test TCL script with the 'load libsqlite3.8.4.dll "SQLite3"' line, the dll was there, but sqlite3.exe wasn't. So, I started looking over things to see why the

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

2014-03-12 Thread 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

[sqlite] Problem in substituting tcl variable in sqlite

2014-03-12 Thread rr27
Hello all, I am writing a tcl script with sqlite commands. I have a tcl list having many members. I want to pass this list and make each list member as column name in sqlite table. List :$column_id using db eval {CREATE TABLE t1 (step)} foreach i $column_id{ db eval {ALTER TABLE t1 ADD COLUMN $i}

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

2014-03-12 Thread 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

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

2014-03-12 Thread David Bicking
On 03/11/2014 07:31 PM, Gilles Ganault wrote: 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

Re: [sqlite] Slow select from database

2014-03-12 Thread Simon Slavin
On 12 Mar 2014, at 10:38am, Георгий Жуйков wrote: > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In

Re: [sqlite] Slow select from database

2014-03-12 Thread Niall O'Reilly
At Wed, 12 Mar 2014 14:38:15 +0400, Георгий Жуйков wrote: > > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In case of record

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

2014-03-12 Thread Simon Slavin
On 12 Mar 2014, at 11:00am, Gilles Ganault wrote: > I see that the wiki contains no document about GUIs: > www.sqlite.org/docs.html Because they're not SQLite. SQLite is the SQLite API, which is written for programmers to use. That's what the SQLite web site is

Re: [sqlite] Slow select from database

2014-03-12 Thread Valentin Davydov
On Wed, Mar 12, 2014 at 02:38:15PM +0400, Георгий Жуйков wrote: > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In case of record

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

2014-03-12 Thread 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

[sqlite] Slow select from database

2014-03-12 Thread Георгий Жуйков
1 . We have a database of measurements: time DATETIME, name TEXT, value NUMERIC indexes: 'tags_name_index' ON 'TAGS' ('NAME' ASC) 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) In case of record auto_vacuum=INCREMENTAL flag is used C#.NET of 4.0 application. Used

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

2014-03-12 Thread Kees Nuyt
On Wed, 12 Mar 2014 00:31:03 +0100, Gilles Ganault wrote: >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

Re: [sqlite] What does SQLITE_OS_WINRT mean

2014-03-12 Thread Joe Mistachkin
> > What does the macro SQLITE_OS_WINRT mean? > When it is set to non-zero, it means that the SQLite core library is being built specifically for the Windows Runtime (present on Windows 8.x): https://en.wikipedia.org/wiki/Windows_Runtime -- Joe Mistachkin

[sqlite] What does SQLITE_OS_WINRT mean

2014-03-12 Thread 张一帆
What does the macro SQLITE_OS_WINRT mean? Just for windows runtime including win95 ,win98 and WinNT? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users