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

[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 installed the SourceForge System.Data.SQLite adaptor... now
what?  Is there a set of instructions somewhere for Creating a VS/VB 2012
project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?

The instructions on these two pages do not work for me:
http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Help needed. Thanks in advance.


For information specific to the ADO.NET adapter for SQLite, start at:
  http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
.

How to create a VB project, use Visual Studio, or program using the 
ADO.NET APIs is off-topic here.  There is a wealth of information on the 
net regarding those topics.  You can find it.


I will add, (approaching the border of topicality here), that the 
adapter adheres closely to what the API designers had in mind and have 
documented, allowing me to take code which works with the SQL Server 
Compact Edition and use it nearly unchanged with SQLite.  The developers 
anticipate and well support such scenarios.


Cheers,
--
Larry Brasfield

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 as
well ask.

Thanks,
Rob

On Mon, Mar 18, 2013 at 12:20 PM, Rob Turpin  wrote:

> I understand it's still under development, but was curious about the
> difference.  I have commented out all of the debug defines and enabled
> -DNDEBUG=1 for the sqlite4 build.
>
>
> On Mon, Mar 18, 2013 at 12:00 PM, Simon Slavin wrote:
>
>>
>> On 18 Mar 2013, at 5:28pm, Rob Turpin  wrote:
>>
>> > With sqlite3 there's a large difference between the CPU time and wall
>> clock
>> > time.  No big deal, that's the I/O to disk.  But then I'm wondering why
>> the
>> > difference with sqlite4 is so small?
>>
>> You know that SQLite4 is Not Ready for Primetime, right ?  Might the
>> distribution you're using have a bunch of debugging stuff in ?
>>
>> Simon.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 System.Data.SQLite adaptor... now 
what?  Is there a set of instructions somewhere for Creating a VS/VB 2012 
project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?


The instructions on these two pages do not work for me:
http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Help needed. Thanks in advance.

-larry

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 used for sorting even if prior terms of the
index are constrained by IN operators in the WHERE clause.

I use SELECT's using IN's... but I'm not seeing any improved performance.

Anyone know exactly what is enhanced?  or how it now allows indices to
be used where they couldn't be before?

Thanks!!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do I write a query

[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 easiest way would be to query playersinleague for all
>> players and then query draftedplayers for all drafted players.
>
> That way should work.  And your schema looks good too apart from SQLite 
> having no 'double' type.  I recommend you store prices as integers instead.
>
>> But is it efficient? Is it fastest?
>
> Don't worry about either 'efficient' or 'fastest'.  Just worry about 'fast 
> enough'.  Generally speaking the best way to design your program is whatever 
> most resembles how you thought about solving the problem.  If the program 
> works the way you think, it'll be easier to program and easier to debug.
>
> If you write it, and it's annoyingly slow to use, then yes, go into heavy 
> hacking mode and program for 10 hours to save 2 seconds runtime.  But until 
> then it's wasted effort and hard to document.  In real life, most programs 
> spend most of their time waiting for humans to do something.  You can speed 
> something up by .84 seconds and nobody will ever notice.
>
>> I will probably need an index created on draftedplayers on the leagueid, 
>> right?
>
> Right.  When making indexes do not think about "What columns would be good to 
> index."  Instead think about "What kind of index would best suit that query 
> ?".  So perhaps wait until you know more about the SELECT you'll be doing, 
> because you might find that it has an ORDER BY clause you can put into the 
> same index and speed it up even more.

What do you mean by "put ORDER BY clause in the index"?
Could you clarify?

Thank you.

>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do I write a query

[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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: user-defined functions

[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 the middle of the
  pi() function.  We must be looking at different files or versions.

> >  This library also contains several string functions, but it is meant
> >  as a general extension library, not a math specific library.
> 
> I have my own set of Unicode aware string functions in another
> extension, so those were useless.

  Fair enough.  I can't say anything about how useful the string
  functions might be, I was simply pointing out that the library was
  intended as a general purpose extension library, not a math specific
  one.  From that viewpoint, it isn't that unusual that it includes
  both string and math functions.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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
> to get as far as creating the schema. Unfortunately, the url I got it from
> no longer has the code. but I'd be interested to know if it works.

You mean these?

http://alt.textdrive.com/svn/altdev/IMDB/Info.ddl
http://alt.textdrive.com/svn/altdev/IMDB/Info.lua

Yes, they work, as far as capturing the information schema goes.

Such queryable data dictionary  is not just to be cute, but rather to perform 
real work by easily introspecting the database.

Specifically, in this case, the data dictionary is use to automatically drive 
the ETL (Extract, Transform, Load) process to load the IMDB database [1]:

http://alt.textdrive.com/svn/altdev/IMDB/ETL.ddl
http://alt.textdrive.com/svn/altdev/IMDB/ETL.lua

The entire ETL is driven by introspecting the IMDB schema, courtesy of the data 
dictionary:

http://alt.textdrive.com/svn/altdev/IMDB/IMDB.ddl
http://alt.textdrive.com/svn/altdev/IMDB/IMDB.lua

So, for example, given the biographies.list.gz IMDB file, the ETL will 
automatically populate its corresponding person_biography table by:

(1) Extracting the raw biography data into an auto-generated staging table
(2) Transform all the appropriate foreign keys by populating their reference 
tables as needed
(3) Load the final person_biography table by automatically resolving all its 
references

Here is a typical run log:

2013-02-16 16:15:59 [IMDB.Process] Inflating 
/Volumes/Queens/IMDB/imdb/biographies.list.gz
2013-02-16 16:16:14 [IMDB.Process] Converting 
/Volumes/Queens/IMDB/imdb/biographies.list
2013-02-16 16:16:35 [IMDB.Process] Processing 
/Volumes/Queens/IMDB/imdb/biographies.list.txt
2013-02-16 16:16:35 [ETL.Extract] Inserting into person_biography_extract
2013-02-16 16:21:11 [ETL.Extract] Inserted 2,585,624 rows into 
person_biography_extract
2013-02-16 16:21:11 [ETL.Transform] Inserting into biography
2013-02-16 16:21:22 [ETL.Transform] Inserted 21 rows into biography
2013-02-16 16:21:22 [ETL.Description] Updating biography
2013-02-16 16:21:22 [ETL.Description] Updated 21 rows in biography
2013-02-16 16:21:22 [ETL.Transform] Inserting into person
2013-02-16 16:21:34 [ETL.Transform] Inserted 540,346 rows into person
2013-02-16 16:21:34 [ETL.Load] Inserting into person_biography
2013-02-16 16:22:23 [ETL.Load] Inserted 2,585,624 rows into person_biography

And that's that. All automated and (meta)data driven. Courtesy of a proper data 
dictionary. 

If only SQLite could provide such information schema out-of-the-box, now that 
would be value added :))


[1] http://www.imdb.com/interfaces

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: user-defined functions

[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 own set of Unicode aware string functions in another 
extension, so those were useless.



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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



https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 System.Data.SQLite to use with 
SQLite 3.7.16, or should 1.0.84.0 work fine?  I am using SQLite as a 
separate dll (not bundled) with the binaries found in 
sqlite-netFx35-binary-Win32-2008.


Thanks,

Nick

___
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

[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 either because I want to be able simply to issue a command
> like:-
> 
> app  
> 
> which will pop up a window with the editor ready to go, preferably in a
> grid format so I can see the existing data.
> 
> The tables to be edited only have a few columns so the app can show all
> the columns with no problem.
> 
> 
> What I'm after is simplicity when using the editor, no complex series of
> menus to navigate to reach the point where one is editing data, no reams
> of icons etc. in the GUI, just a line of boxes to enter the data.
> 
> 
> I'm quite happy to design it myself given a few tools, even a non-GUI
> approach would be acceptable if it's reasonably simple.
> 
> What I have tried so far (with some comments) are:-
> 
> kexi - it's almost there but you can't create a data entry form with
> a datagrid on it and you can't get it to edit sqlite3 tables created
> outside of kexi.
> 
> sqledit/sqlkit - it looks almost ideal but it seems to me that it's
> just a bit too buggy.  I've tried both plain sqledit (ready made
> app) and creating my own using sqlkit.
> 
> wxglade - a python GUI toolkit, this has been closest to success so
> far and I may eventually get to a good solution but it feels as if
> I'm having to reinvent the wheel in programming lots of things that
> someone must have done before.
> 
> 
> Surely there must be something close to what I want out there!  (By the
> way while I'm basically after a desktop application a web one would be
> acceptable as I run a full LAMP setup on my desktop machinee).

Try SQLWorkbench/J. Use the JDBC driver from:
https://bitbucket.org/xerial/sqlite-jdbc


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: user-defined functions

[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 for 'glob' is labelled 'man page' rather
> than 'glob.pdf'.  Still works fine, just inconsistent.

Fixed.  I had meant for all the pdf links to read "man page".  

> B) Whatever process you've used to get from man page to .pdf has made
> your apostrophes into directional quotes.  For example, if you look
> at your regex command example you see that the command line says
> 
> regex(??..$?, name)   not
> regex('?..$', name)

A consequence of switching to Bold font, which is Times Roman.  (The
process is groff output to Postscript and ps2pdf.)  

--jkl
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] MyJSQLView Version 3.44 Released

[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 standardize the connection
properties in the Connection Manager and proper close of memory connections
for those database that support such. The Login Frame now supports via
the database entry field the passing of parameters like, myDB;loglevel=1,
to more customize connections. Also included with this release comes
changes to the Query Frame UI, and enhancements to the HeatMapper plugin.

Dana M. Proctor
MyJSQLView Project Manager
http://dandymadeproductions.com/projects/MyJSQLView/

MyJSQLView provides an easy to use Java based user interface front-end
for viewing, adding, editing, or deleting entries in several mainstream
databases. A query frame allows the building of complex SQL statements
and a SQL Query Bucket for saving such. The application allows easy
sorting, searching, and import/export of table data. A plug-in framework
has allowed the inclusion of tools to visual build queries, profile and
plot data for analysis.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 25 March 2013 06: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 problem.
>
> Thanks,
> Moumita
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 Functions, User-Defined Aggregates, and 
Virtual Tables.  If your definition of a Stored-Procedure means an executable 
batch of SQL Statements akin to Transact-SQL or PL/SQL, or Stored Procedures as 
in modern DB2, then those are not supported by the SQLite database engine.

---
()  ascii ribbon campaign against html e-mail
/\  www.asciiribbon.org




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 problem.
>
> Thanks,
> Moumita
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
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

[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 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, there seems to be that problem with database editors.  They start
> off as little data editing utilities.  Then the authors add more features
> and them more features, until you have to pick 'editing' and an editing
> mode before you can do what the application was originally for.  Which is
> what you're trying to avoid.
>
> I ended up writing my own in JavaScript/PHP.  But you need to be a
> programmer to do that.  And my own editor is custom-designed for the way my
> databases work so it's not suitable for wide publication.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
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

[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, there seems to be that problem with database editors.  They start off as 
little data editing utilities.  Then the authors add more features and them 
more features, until you have to pick 'editing' and an editing mode before you 
can do what the application was originally for.  Which is what you're trying to 
avoid.

I ended up writing my own in JavaScript/PHP.  But you need to be a programmer 
to do that.  And my own editor is custom-designed for the way my databases work 
so it's not suitable for wide publication.

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

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

> 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 looking at custom code now.
> >
> Yes, though the end-user is mostly me so I'm not so fussed about data
> integrity.  It's very simple data, a date, a couple of columns with
> numbers in and a text column.  If it gets confused because I've
> mis-formatted a date I can simply correct the entry, it doesn't need
> heavyweight validation.
>
>
> > But, if you can trust the user(s), I'd STILL say don't reinvent, but just
> > use a something that is already written.
> >
> That's exactly where I'm coming from, I'm desperately trying not to
> re-invent the wheel but all I can find is complete bicycles!  :-)
>
> I want a simple application with low overheads (i.e. fast to load *and*
> with no DBMS extras not needed for data entry) and there really don't
> seem to be any out there.
>
> --
> Chris Green
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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

[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 looking at custom code now.
> 
Yes, though the end-user is mostly me so I'm not so fussed about data
integrity.  It's very simple data, a date, a couple of columns with
numbers in and a text column.  If it gets confused because I've
mis-formatted a date I can simply correct the entry, it doesn't need
heavyweight validation.


> But, if you can trust the user(s), I'd STILL say don't reinvent, but just
> use a something that is already written.
> 
That's exactly where I'm coming from, I'm desperately trying not to
re-invent the wheel but all I can find is complete bicycles!  :-)

I want a simple application with low overheads (i.e. fast to load *and*
with no DBMS extras not needed for data entry) and there really don't
seem to be any out there.

-- 
Chris Green

___
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

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

There are two quite separate and distinct requirements when using
databases:-

A way to create the database, handle relationships, column types,
backups, etc.  For this there seems to be lots of choice, I
personally use a mix of the command-line sqlite3 and sqlitebrowser
and sqliteman.

A way for users (mostly me in my case, but also sometimes other
people) to enter data into the database.  There don't seem to be
many good tools for doing this.  In particular there seems to be
very little that does a straightforward datagrid given the name of
the database and table to open.  

OK, in many cases designing a form for data entry makes sense and there
are tools for this (kexi comes to mind, though as I said earlier it has
significant limitations).  If I wanted to have a nice form to enter a
single record without being able to see the rest of the data I could
fairly easily get what I want.  However getting a grid view for data
entry where I can see the other records (often *very* useful) is a lot
more difficult.

Having to wade through the layers of a DBMS tool when all I want to do
is add one row of data to my table is painful.  This particular
application involves adding one row of data maybe once every ten days or
so.  Thus I want a quick 'click here and type in the row of data' type
approach and don't want to have to load a heavyweight application and
wade through a load of menus just to type in what is essentially a
single line of text.

-- 
Chris Green

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Merging databases

[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 to download
> big files. Disadvantage is that create queries is tricky. So here is my
> question. Is SQLite has some function for merging data? I'm wondering about
> ATTACH DATABASE, but maybe there is a better way?

You can indeed use attached databases to merge data:

ATTACH DATABASE 'day42.sqlite' AS 'day42';
INSERT INTO MyTable SELECT * FROM day42.MyTable;

If the data does not have a timestamp, you'd have to add it:

INSERT INTO MyTable(name, value, whatever, day)
SELECT name, value, whatever, 42 FROM day42.MyTable;


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Merging databases

[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 files. Disadvantage is that create queries is tricky. So here is my
question. Is SQLite has some function for merging data? I'm wondering about
ATTACH DATABASE, but maybe there is a better way?

Regards
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: user-defined functions

[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 test cycle.


Also I removed the string functions as they have no place in a math 
module and most of them didn't handle Unicode the way I needed.


--
j...@antichoc.net  


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ANN: user-defined functions

[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 in a more public place I might encourge others
> to help create an archive of such things for general use.  
> 
> I hope these serve as examples and fuel your imagination for what can
> be done with SQLite.  

Nicely done.  Notes:

A) The link for your PDF for 'glob' is labelled 'man page' rather than 
'glob.pdf'.  Still works fine, just inconsistent.

B) Whatever process you've used to get from man page to .pdf has made your 
apostrophes into directional quotes.  For example, if you look at your regex 
command example you see that the command line says

regex(’ˆ..$’, name)   not
regex('ˆ..$', name)

I'm not sure where the problem leaked in, but a user may find that a copypasted 
example from a PDF just won't work.  The man pages themselves look okay.  
(Problem also appears in /some/ places in other PDFs, not just regex.)

Simon.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users