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
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
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
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
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
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
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
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
>
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
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?
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
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
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
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
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
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
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
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
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,
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:
>
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
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
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.
>
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
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
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
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
27 matches
Mail list logo