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

2013-03-25 Thread Larry Brasfield
larrygauthier at charter.net writes: 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

Re: [sqlite] sqlite3 and sqlite4 disk I/O

2013-03-25 Thread Rob Turpin
Dan, I haven't heard anything more about this. I was wondering if you also think the CPU performance for sqlite4 should be better? Maybe you could help me with where I could focus my attention in looking into this. I know that's probably a big question to a potentially complex issue, but might

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

2013-03-25 Thread larrygauthier
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

[sqlite] New Optimizations in 3.7.16 -- Explain please?

2013-03-25 Thread Patrick Herbst
Can someone give me a case where the new changes make a difference in relation to the following two changes: (from http://www.sqlite.org/releaselog/3_7_16.html) - Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. - Allow indices to be

Re: [sqlite] How do I write a query

2013-03-25 Thread Igor Korot
Hi, Simon, On Sat, Mar 23, 2013 at 10:22 PM, Simon Slavin wrote: > > On 24 Mar 2013, at 5:03am, Igor Korot wrote: > >> When application starts I need to retrieve first all available players >> and then all players that are drafted. >> >> Probably the

Re: [sqlite] How do I write a query

2013-03-25 Thread Igor Tandetnik
On 3/25/2013 3:59 PM, Igor Korot wrote: What do you mean by "put ORDER BY clause in the index"? Could you clarify? For example, if you often need to run a query like "select * from T where A = ? order by B;", it would benefit from an index on T(A, B). -- Igor Tandetnik

Re: [sqlite] ANN: user-defined functions

2013-03-25 Thread Jay A. Kreibich
On Mon, Mar 25, 2013 at 08:32:12PM +0100, Jean-Christophe Deschamps scratched on the wall: > At 15:46 25/03/2013, you wrote: > > > The sqrt() function takes only one argument, at least. > > It checks assert( argc==2 ); at line 503 AFAIK. Line 503 of the version up on the website is in

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-25 Thread Petite Abeille
On Mar 21, 2013, at 6:41 PM, Peter Haworth wrote: > I found the code in the two attached files (are they allowed on this list?) > on the web a while back. The claim was that it created an information > schema database from an sqlite db. I know nothing about Lua but I managed >

Re: [sqlite] ANN: user-defined functions

2013-03-25 Thread Jean-Christophe Deschamps
At 15:46 25/03/2013, you wrote: ´¯¯¯ The sqrt() function takes only one argument, at least. It checks assert( argc==2 ); at line 503 AFAIK. This library also contains several string functions, but it is meant as a general extension library, not a math specific library. I have my

Re: [sqlite] System.Data.SQLite version for SQLite 3.7.16

2013-03-25 Thread Bernd Lehmkuhl
Am 25.03.2013 18:37, schrieb Nicolas Rivera: Hi, The latest version of System.Data.SQLite in the download page is 1.0.84.0, which appears to have been done for SQLite version 3.7.15.2. Is that correct? If so, is there a plan to update System.Data.SQLite with the latest SQLite version?

[sqlite] System.Data.SQLite version for SQLite 3.7.16

2013-03-25 Thread Nicolas Rivera
Hi, The latest version of System.Data.SQLite in the download page is 1.0.84.0, which appears to have been done for SQLite version 3.7.15.2. Is that correct? If so, is there a plan to update System.Data.SQLite with the latest SQLite version? Do Ineed to wait for a later version of

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread Walter Hurry
On Sat, 23 Mar 2013 15:53:14 +, cl-RxdKpHOThMg wrote: > I'm looking for a straightforward way to edit the *data* in sqlite > tables, or at least a simple GUI for creating forms to edit sqlite > tables. > > I don't need *any* database management and I don't want it in this > application

Re: [sqlite] ANN: user-defined functions

2013-03-25 Thread James K. Lowden
On Mon, 25 Mar 2013 08:33:53 + Simon Slavin wrote: > > On 25 Mar 2013, at 3:54am, James K. Lowden > wrote: > > > http://www.schemamania.org/sql/sqlite/udf/ > > Nicely done. Thanks for the notes, Simon. > A) The link for your PDF

[sqlite] MyJSQLView Version 3.44 Released

2013-03-25 Thread danap
MyJSQLView Version 3.44 Released The MyJSQLView project is pleased to release v3.44 to the public. The release's main composition is for the support of an additional database, but in so doing expands the capability to use external data sources for plugins. Modifications have been coded in to

Re: [sqlite] How to write store-procedure in SQLite.net

2013-03-25 Thread Mike King
SQLite doesn't have stored procedures. If you are using a .Net language such as C# then you can create your own custom functions which may do what you want. See the link below for an example. http://stackoverflow.com/questions/172735/create-use-user-defined-functions-in-system-data-sqlite On

Re: [sqlite] How to write store-procedure in SQLite.net

2013-03-25 Thread Keith Medcalf
On Monday, 25 March, 2013, at 00:06, Moumita Banerjee said: > I am trying to write a store-procedure in SQLite.net , but I am unable to > do so. Please help me solve this problem. What is your definition of a stored-procedure? SQLite supports triggers, User-Defined

Re: [sqlite] How to write store-procedure in SQLite.net

2013-03-25 Thread Noel Frankinet
Hello, I think that sqlite does not support stored procedure, but it does support triggers. Noël On 25 March 2013 07:05, Moumita Banerjee wrote: > Hi, > > I am trying to write a store-procedure in SQLite.net , but I am unable to > do so. Please help me solve this

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread Noel Frankinet
Back in the old time there was dbase.I'm always dreaming of a sqlite based dbase. One can be done with tcl + tk sqlite, but I find tcl and tk way too big today. On 25 March 2013 14:17, Simon Slavin wrote: > > On 25 Mar 2013, at 11:35am, c...@isbd.net wrote: > > > I don't

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread Simon Slavin
On 25 Mar 2013, at 11:35am, c...@isbd.net wrote: > I don't want to load/use a DBMS *when I'm editing the data*. Of course > a database management program is an excellent tool for managing the > database, but they're generally rubbish at making it easy to enter data > into the database. Yeah,

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread Noel Frankinet
I once developped a simple table viewer using WTL and windows ListView. Very lighweight and very speedy. Of course it was windows only and read only. I suppose that a modern editable version using Qt would be even easier to develop ? Noël On 25 March 2013 12:41, wrote: >

[sqlite] How to write store-procedure in SQLite.net

2013-03-25 Thread Moumita Banerjee
Hi, I am trying to write a store-procedure in SQLite.net , but I am unable to do so. Please help me solve this problem. Thanks, Moumita ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread cl
Stephen Chrzanowski wrote: > Reading further on, I see that you're looking at end-user. This changes > things a bit. Now you're looking at trying to make things user-proof, > maintain data integrity (Who said 1<>one?), validate data, so on and so > on. You're probably

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

2013-03-25 Thread cl
Stephen Chrzanowski wrote: > > I know you said you didn't want a DBMS, but really, when you're saying > you're willing to write an application to manage the data, you're writing a > DBMS. Save time, don't reinvent the wheel unless you're going on a > learning adventure. >

Re: [sqlite] Merging databases

2013-03-25 Thread Clemens Ladisch
Krzysztof wrote: > I have daemon on server which each day create new sqlite database. Client > application can download and present these databases. For example: User > want to see data from last week so client application download 7 > files. Advantage of this defragmentation is that it don't need

[sqlite] Merging databases

2013-03-25 Thread Krzysztof
Hi, I have daemon on server which each day create new sqlite database. Client application can download and present these databases. For example: User want to see data from last week so client application download 7 files. Advantage of this defragmentation is that it don't need to download big

Re: [sqlite] ANN: user-defined functions

2013-03-25 Thread Jean-Christophe Deschamps
At some point in time I needed a few math functions and tried to use the contributed maths extension. I found a couple of mistakes, mostly sqrt() requiring two arguments, and something else I can't remember right now. That by itself may indicate that the math functions never went into full

Re: [sqlite] ANN: user-defined functions

2013-03-25 Thread Simon Slavin
On 25 Mar 2013, at 3:54am, James K. Lowden wrote: > http://www.schemamania.org/sql/sqlite/udf/ > > When I started looking into this, I didn't find many examples around > the Web, and there's no HOWTO document on the SQLite website. I > thought by posting some