Re: [sqlite] table backup

[dd]

Hi Roger,

  I don't have any clue. Two databases are corrupted. First one, while
inserting 20,000 records suddenly sqlite thrown disk io error at 4,000
record. No clue.

  Second database corrupted when my application crashed. But that time,
second database was not opened.

  So, I am planning to choose backup solution instead of investigating
corruption.

  I discussed this issue in my previous post.

  Any sample application for virtual table option.

Best Regards,
d


On Mon, Dec 10, 2012 at 9:09 PM, Roger Binns  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/12/12 21:44, dd wrote:
> > Sometimes, sqlite databse corrupts.
>
> That is the problem you need to fix.  If you have a system that is
> unreliable then it will also corrupt your backups.
>
> http://www.sqlite.org/lockingv3.html#how_to_corrupt
> http://www.sqlite.org/howtocorrupt.html
>
> > So, I want to take online backup of specific table. Not entire
> > database.
>
> Do you need to take a backup on every change, as part of the change or is
> it acceptable to make backups periodically and possibly lose intermediate
> versions of the data?
>
> For a periodic backup you can iterate over the table contents and output
> them in a convenient format for you, such as CSV or SQL statements.
>
> For saving all data you can use triggers to save historical values in a
> second table and then do a periodic backup.
>
> If it must be immediate then the only choice available is to use a virtual
> table and do the backup during writes/sync.
>
> This is all considerably more work than figuring out why you are getting
> corruption in the first place.
>
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAlDGF2IACgkQmOOfHg372QTo9gCfSQQwreSvsa9lrV/wj0YC2Fvj
> LT0AmwdZSaNvVJJuic3gLYmQfn9YX6x3
> =Gx1r
> -END PGP SIGNATURE-
> ___
> 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] Unql

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 10/12/12 19:01, dcharno wrote:
> What ever happened to Unql and is there any chance it will be revived?
> It seemed like it would have been incredible useful.

Warning: My opinion only

Unql seemed to be especially pointless.  Being somewhat compatible with
SQL syntax made no sense - SQL syntax and all the tools using it assume
the relational model and simple table like data layouts.  NoSQL databases
vary, but generally they are non-relational and schemaless, and JSON
interoperable ones have a structure completely different than SQL tables
(eg item nesting).

Every NoSQL database already has its own query mechanism so Unql would
always be a second class citizen if any of them ever adopted Unql.

NoSQL databases also tend to have looser consistency, have multiple
servers available and various other semantics very different than SQL
servers.  The native NoSQL interfaces expose and work with those semantics.

Cassandra did actually end up with something SQL inspired:

  http://cassandra.apache.org/doc/cql/CQL.html

Riak uses something like Google advanced searches (field:value):

  http://docs.basho.com/riak/latest/cookbooks/Riak-Search---Querying/

MongoDB uses JSON with extra magic operators:

  http://docs.mongodb.org/manual/applications/read/

Personally I like MongoDB approach where queries strongly resemble the
underlying stored data which means very little translation between the two.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlDGqEAACgkQmOOfHg372QQ8OACgxbOBcp1F5rADh9Uw5+0efsEe
5RQAn3sim96zcz6x2lKMXF+B7Sp20P1A
=OHFc
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Unql

[dcharno]

What ever happened to Unql and is there any chance it will be revived? 
It seemed like it would have been incredible useful.


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

Re: [sqlite] Foreign key constraint with m:n relationship

[Clemens Ladisch]

Kristine Peters wrote:
> Does sqlite3 support foreign key constraints with m:n relations?

In your logical model, you have a M:N relation.
In the phyiscal database, however, you implement this as a separate
table which can be seen as having two 1:N relations, so what you have
are two separate foreign keys with their own constraints.

> Once I initialize the database and set the pragma for foreign keys, I can
> update and/or delete with cascading, but when I add a PROJECT relation and a
> WORKS_ON relation that has two keys that act as foreign keys, one to
> EMPLOYEE and one to PROJECT, then I cannot change either EMPLOYEE ssn or
> PROJECT Pnumber without a foreign_key constraint error.

In my test, updates and deletes in the two parent tables cascade just fine.

> CREATE TABLE WORKS_ON(
> EssnCHAR(9)NOT NULL,
> PnoINTNOT NULL,
> HoursDECIMAL(3,1)NOT NULL,
> PRIMARY KEY(Essn, Pno),
> FOREIGN KEY(Essn) REFERENCES EMPLOYEE(Ssn),
> FOREIGN KEY(Pno) REFERENCES PROJECT(PNUMBER)
> );

I hope in your tests you had "ON UPDATE CASCADE" etc. there?


Regards,
Clemens


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

[sqlite] Foreign key constraint with m:n relationship

[Kristine Peters]

Does sqlite3 support foreign key constraints with m:n relations?

I can get cascade update/delete to work with 1:n relations, but not m:n.

Example, this schema works: (yes, it¹s from the Elmasri text; it shows a 1:n
relationship between EMPLOYEE and DEPARTMENT; also the 1:N relationship to
the weak entity DEPENDENT)
CREATE TABLE EMPLOYEE (
FnameVARCHAR(15)NOT NULL,
MinitCHAR, 
LnameVARCHAR(15)NOT NULL,
SsnCHAR(9)NOT NULL,
BdateDATE,
Address VARCHAR,
SexCHAR,
Salary  DECIMAL(10,2),
Super_Ssn  CHAR(9),
DnoINTDEFAULT 99,
CONSTRAINT EMPPK
PRIMARY KEY (Ssn),
CONSTRAINT EMPDEPTFK
FOREIGN KEY (Dno) REFERENCES DEPARTMENT (Dnumber)
ON DELETE SET DEFAULTON UPDATE CASCADE
);
CREATE TABLE DEPARTMENT(
DnameVARCHAR (15) NOT NULL,
Dnumber INTNOT NULL,
Mgr_SsnCHAR(9)NOT NULLDEFAULT '88866',
Mgr_start_dateDATE,
CONSTRAINT DEPTPK
PRIMARY KEY (Dnumber),
CONSTRAINT DEPTSK
UNIQUE (Dname)

);
CREATE TABLE DEPENDENT(
EssnCHAR(9)NOT NULL,
Dependent_NameVARCHAR(15)NOT NULL,
SexCHAR,
BdateDATE,
RelationshipVARCHAR(8),
PRIMARY KEY (Essn, Dependent_Name),
FOREIGN KEY (Essn) REFERENCES EMPLOYEE(Ssn)
ON DELETE CASCADE  ON UPDATE CASCADE
);

Once I initialize the database and set the pragma for foreign keys, I can
update and/or delete with cascading, but when I add a PROJECT relation and a
WORKS_ON relation that has two keys that act as foreign keys, one to
EMPLOYEE and one to PROJECT, then I cannot change either EMPLOYEE ssn or
PROJECT Pnumber without a foreign_key constraint error. See below for the
two relations.

CREATE TABLE PROJECT(
PnameVARCHAR(15)NOT NULL,
PnumberINTNOT NULL,
PlocationVARCHAR(15),
DnumINTNOT NULL,
PRIMARY KEY(Pnumber),
UNIQUE (Pname),
FOREIGN KEY(Dnum) REFERENCES DEPARTMENT(Dnumber)
);
CREATE TABLE WORKS_ON(
EssnCHAR(9)NOT NULL,
PnoINTNOT NULL,
HoursDECIMAL(3,1)NOT NULL,
PRIMARY KEY(Essn, Pno),
FOREIGN KEY(Essn) REFERENCES EMPLOYEE(Ssn),
FOREIGN KEY(Pno) REFERENCES PROJECT(PNUMBER)
);

Thanks for any help,
Kris Peters
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] table backup

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 09/12/12 21:44, dd wrote:
> Sometimes, sqlite databse corrupts.

That is the problem you need to fix.  If you have a system that is
unreliable then it will also corrupt your backups.

http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://www.sqlite.org/howtocorrupt.html

> So, I want to take online backup of specific table. Not entire
> database.

Do you need to take a backup on every change, as part of the change or is
it acceptable to make backups periodically and possibly lose intermediate
versions of the data?

For a periodic backup you can iterate over the table contents and output
them in a convenient format for you, such as CSV or SQL statements.

For saving all data you can use triggers to save historical values in a
second table and then do a periodic backup.

If it must be immediate then the only choice available is to use a virtual
table and do the backup during writes/sync.

This is all considerably more work than figuring out why you are getting
corruption in the first place.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlDGF2IACgkQmOOfHg372QTo9gCfSQQwreSvsa9lrV/wj0YC2Fvj
LT0AmwdZSaNvVJJuic3gLYmQfn9YX6x3
=Gx1r
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [Abwesenheitsnotiz] sqlite-users Digest, Vol 60, Issue 10

[Carl Slowinski]

Hallo,

vielen Dank für Ihre Nachricht.

Ich bin in der Zeit vom 10.12. bis 11.12.2012 im Urlaub und werde mich nach 
meiner Rückkehr bei Ihnen melden.
Ihre Nachricht wird nicht weitergeleitet. 

Mit freundlichen Grüßen

Carl Slowinski 
oxando GmbH 

Konrad-Zuse-Ring 12 
D-68163 Mannheim 
Germany 
Tel.:   +49-621-860 860 18 
Fax:   +49-621-860 860 29
Mobil: +49-151-29 26 41 01
Email: carl.slowin...@oxando.com


Sitz der Gesellschaft/Registered Office: Konrad-Zuse-Ring 12, 68163 Mannheim.
Geschäftsführer: Thomas Holtkotte, Andreas Schmidt, Tobias Zug
Registergericht Mannheim HRB 701956.

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige 
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich 
erhalten haben, ist Ihnen eine Vervielfältigung oder Weitergabe der E-Mail 
ausdrücklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen 
Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or otherwise 
confidential information. If you have received this e-mail in error, you are 
hereby notified that any review, copying, or distribution of it is strictly 
prohibited. Please inform us immediately and destroy the original transmittal. 
Thank you for your cooperation. 

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

Re: [sqlite] SQLite logo usage

[Richard Hipp]

On Mon, Dec 10, 2012 at 11:04 AM, Bruno Kim Medeiros Cesar <
brunokim...@gmail.com> wrote:

> Thanks for your answer.
>
> Is it explicit somewhere in the site, or should it be? I guessed to be the
> case, but there's no notice as we see on NASA images, for example.
>

There is no notice on the website.  But you are right, there should be.
I'll try to add a notice for the next release, coming up in a few days.


>
> Bruno Kim Medeiros Cesar
> Eng. de Computação 2008 - EESC - USP
> brunokim...@gmail.com
> Skype: bkim.cesar
>
> 2012/12/10 Richard Hipp 
>
> >
> > You are welcomed to use a copy of the logo from the website, scaled to
> > whatever size you need but otherwise unaltered, and to use the SQLite
> name
> > as long as you do not imply that your product or service is officially
> > endorsed by the SQLite developers.
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> > ___
> > 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
>



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

Re: [sqlite] SQLite logo usage

[Bruno Kim Medeiros Cesar]

Thanks for your answer.

Is it explicit somewhere in the site, or should it be? I guessed to be the
case, but there's no notice as we see on NASA images, for example.

Bruno Kim Medeiros Cesar
Eng. de Computação 2008 - EESC - USP
brunokim...@gmail.com
Skype: bkim.cesar

2012/12/10 Richard Hipp 

>
> You are welcomed to use a copy of the logo from the website, scaled to
> whatever size you need but otherwise unaltered, and to use the SQLite name
> as long as you do not imply that your product or service is officially
> endorsed by the SQLite developers.
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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] SQLite logo usage

[Richard Hipp]

On Mon, Dec 10, 2012 at 9:40 AM, Simon Slavin  wrote:

>
> On 10 Dec 2012, at 2:38pm, Richard Hipp  wrote:
>
> > The "SQLite" name and the new SQLite Logo are registered trademarks.
>
> Let's ask it a different way.  If I write something and want to list
> SQLite as one of the technologies in it, how would you like me to list
> SQLite ?  Is there any small image to go with it which will encourage brand
> recognition ?
>

You are welcomed to use a copy of the logo from the website, scaled to
whatever size you need but otherwise unaltered, and to use the SQLite name
as long as you do not imply that your product or service is officially
endorsed by the SQLite developers.


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



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

Re: [sqlite] SQLite logo usage

[Tim Streater]

On 10 Dec 2012 at 14:40, Simon Slavin  wrote: 

> On 10 Dec 2012, at 2:38pm, Richard Hipp  wrote:
>
>> The "SQLite" name and the new SQLite Logo are registered trademarks.
>
> Let's ask it a different way.  If I write something and want to list SQLite as
> one of the technologies in it, how would you like me to list SQLite ?  Is
> there any small image to go with it which will encourage brand recognition ?

And in my case I want to document my app and list SQLite in an appendix.

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

Re: [sqlite] String not valid DateTime

[Tim Streater]

On 10 Dec 2012 at 14:05, William Drago  wrote:

> I am using SQLite with C# and am having trouble with SQLite
> DATETIME types. The following error occurs when trying to
> read rows from a table that contains dates (e.g. "12/09/2012
> 22:51:24"). (I am using a SQLiteDataReader to put query
> results into a C# DataTable.)
>
> "String was not recognized as a valid DateTime."
>
> Apparently SQLite stores dates as strings while C# is
> expecting an object of some sort. Any thoughts or solutions?
> As a work-around I changed all my DATETIME types to VARCHARs.

Suggest the OP reads this also:

http://sqlite.org/datatype3.html

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

Re: [sqlite] SQLite logo usage

[Simon Slavin]

On 10 Dec 2012, at 2:38pm, Richard Hipp  wrote:

> The "SQLite" name and the new SQLite Logo are registered trademarks.

Let's ask it a different way.  If I write something and want to list SQLite as 
one of the technologies in it, how would you like me to list SQLite ?  Is there 
any small image to go with it which will encourage brand recognition ?

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Noel Frankinet]

Lets agree to disagree, sqlite is completely cross-plaform. You could
develop a cross plate-form solution  in the same time (Qt or Tcl/tk). The
95% market does not hold if you think smart-phone and tablet (a good target
for a simple data entry application). If you only want windows, why not
uuse Access in the first place? But anyway...


On 10 December 2012 15:33, Gilles Ganault  wrote:

> On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
>  wrote:
> >It's probably a good way to get something working, but you loose the
> >cross-platform
>
> I know, but Windows is 95% of the market for end-users, cross-platform
> is a pain to write, they take longer to load and always look/act funny
> anyway :-)
>
> ___
> 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] SQLite logo usage

[Richard Hipp]

On Mon, Dec 10, 2012 at 8:57 AM, Bruno Kim Medeiros Cesar <
brunokim...@gmail.com> wrote:

> Hello.
>
> Is there a policy on how to use the SQLite logo? Is it copyrighted or in
> public domain? I found it as an SVG in a non-official site, and was
> wondering if it is free to edit and modify.
>


The "SQLite" name and the new SQLite Logo are registered trademarks.


>
> I would like to do a little homage to SQLite, and have inserted the
> blessing within the blue box as in the attached image. I wonder if it is ok
> to publish it.
>
> Thanks for your attention,
>
> Bruno Kim Medeiros Cesar
> Eng. de Computação 2008 - EESC - USP
> brunokim...@gmail.com
> Skype: bkim.cesar
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
 wrote:
>It's probably a good way to get something working, but you loose the
>cross-platform

I know, but Windows is 95% of the market for end-users, cross-platform
is a pain to write, they take longer to load and always look/act funny
anyway :-)

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

Re: [sqlite] just a test

[Adam DeVita]

Gmail users: You can set a Filter to ensure the Igor's messages are
delivered to your in-box.  I did this last week and since then his
messages do not end up in my SPAM folder.
If you search   
"This message may not have been sent by..." warning in Gmail help,
there are instructions.

Adam

On Mon, Dec 10, 2012 at 8:09 AM, Ryan Johnson
 wrote:
> Clearly, Igor is too helpful and responds to too many messages... *rolls
> eyes*
>
> I'm not on gmail, so I didn't know this was even a problem, but hopefully it
> gets sorted out soon.
>
> Ryan
>
>
> On 09/12/2012 2:01 AM, dd wrote:
>>
>> Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT
>> SPAM.
>>
>>
>> On Sun, Dec 9, 2012 at 9:33 AM, Gabor Grothendieck
>> wrote:
>>
>>> I am still having problems with Igor's gmail messages being marked as
>>> spam in gmail but after the upteenth time declaring them not to be
>>> spam google finally asked me if I wanted to report it to their gmail
>>> team so hopefully they will fix it soon.
>>>
>>> On Mon, Dec 3, 2012 at 11:59 PM, Clive Hayward 
>>> wrote:

 Igor's messages sometimes get marked as spam by gmail.

 --
 Clive Hayward


 On 2012-12-03, at 7:57 AM, e-mail mgbg25171 
>>>
>>> wrote:
>
> I've posted a couple of mails lately...I'm not getting them via the
>>>
>>> list or
>
> any responses.
> Admin says Igor responded to one of them...Thanks Igor!
> This is just a test to see if the mail is coming to me (as a member of
>>>
>>> the
>
> list).
> Therefore please just ignore this.
> ___
> 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
>>>
>>>
>>>
>>> --
>>> Statistics & Software Consulting
>>> GKX Group, GKX Associates Inc.
>>> tel: 1-877-GKX-GROUP
>>> email: ggrothendieck at gmail.com
>>> ___
>>> 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-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
VerifEye Technologies Inc.
905-948-0015x245
151 Whitehall Dr, Unit 2
Markham ON, L3R 9T1
Canada
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] String not valid DateTime

[Clemens Ladisch]

William Drago wrote:
> I am using SQLite with C# and am having trouble with SQLite DATETIME
> types.

In SQLite, the DATETIME type is interpreted in the same way as the
FLUFFY_BUNNIES type, i.e., it is not recognized at all.  Due to
SQLite's dynamic typing, values in that column have the same type that
they were inserted as: .

> The following error occurs when trying to read rows from a table that
> contains dates (e.g. "12/09/2012 22:51:24").

Is that ninth December or twelfth September?

Date/times are can be stored as number or strings; strings should have
the format '-mm-dd hh:mm:ss':



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

Re: [sqlite] String not valid DateTime

[Igor Tandetnik]

William Drago  wrote:
> I am using SQLite with C# and am having trouble with SQLite
> DATETIME types. The following error occurs when trying to
> read rows from a table that contains dates (e.g. "12/09/2012
> 22:51:24"). (I am using a SQLiteDataReader to put query
> results into a C# DataTable.)

Change your date format to '2012-12-09 22:51:24'. For more details, see

http://sqlite.org/lang_datefunc.html

"Time Strings" section.
-- 
Igor Tandetnik

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Noel Frankinet]

It's probably a good way to get something working, but you loose the
cross-platform


On 10 December 2012 14:47, Gilles Ganault  wrote:

> On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
>  wrote:
> >There are lots of people who manipulate data that way, but they tend to
> export
> > their data from the SQLite database into their favourite spreadsheet app,
> > do the manipulation there, then reimport to SQLite.
> > This prevents them from having to use an app which doesn't have
> > all the facilities they expect from their spreadsheet app.
> >
> >The SQLite shell tool (free) makes the export and import processes easy
> (can be done in one command).
>
> I'll see if there's a good datagrid + SQLite connector for .Net so I
> can combine the two and see how it goes.
>
> Thanks all.
>
> ___
> 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] String not valid DateTime

[William Drago]

All,

I am using SQLite with C# and am having trouble with SQLite 
DATETIME types. The following error occurs when trying to 
read rows from a table that contains dates (e.g. "12/09/2012 
22:51:24"). (I am using a SQLiteDataReader to put query 
results into a C# DataTable.)


"String was not recognized as a valid DateTime."

Apparently SQLite stores dates as strings while C# is 
expecting an object of some sort. Any thoughts or solutions? 
As a work-around I changed all my DATETIME types to VARCHARs.


Thanks,
Bill


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

[sqlite] SQLite logo usage

[Bruno Kim Medeiros Cesar]

Hello.

Is there a policy on how to use the SQLite logo? Is it copyrighted or in
public domain? I found it as an SVG in a non-official site, and was
wondering if it is free to edit and modify.

I would like to do a little homage to SQLite, and have inserted the
blessing within the blue box as in the attached image. I wonder if it is ok
to publish it.

Thanks for your attention,

Bruno Kim Medeiros Cesar
Eng. de Computação 2008 - EESC - USP
brunokim...@gmail.com
Skype: bkim.cesar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
 wrote:
>There are lots of people who manipulate data that way, but they tend to export
> their data from the SQLite database into their favourite spreadsheet app,
> do the manipulation there, then reimport to SQLite.
> This prevents them from having to use an app which doesn't have
> all the facilities they expect from their spreadsheet app.
>
>The SQLite shell tool (free) makes the export and import processes easy (can 
>be done in one command).

I'll see if there's a good datagrid + SQLite connector for .Net so I
can combine the two and see how it goes.

Thanks all.

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

Re: [sqlite] just a test

[Ryan Johnson]

Clearly, Igor is too helpful and responds to too many messages... *rolls 
eyes*


I'm not on gmail, so I didn't know this was even a problem, but 
hopefully it gets sorted out soon.


Ryan

On 09/12/2012 2:01 AM, dd wrote:

Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT
SPAM.


On Sun, Dec 9, 2012 at 9:33 AM, Gabor Grothendieck
wrote:


I am still having problems with Igor's gmail messages being marked as
spam in gmail but after the upteenth time declaring them not to be
spam google finally asked me if I wanted to report it to their gmail
team so hopefully they will fix it soon.

On Mon, Dec 3, 2012 at 11:59 PM, Clive Hayward 
wrote:

Igor's messages sometimes get marked as spam by gmail.

--
Clive Hayward


On 2012-12-03, at 7:57 AM, e-mail mgbg25171 

wrote:

I've posted a couple of mails lately...I'm not getting them via the

list or

any responses.
Admin says Igor responded to one of them...Thanks Igor!
This is just a test to see if the mail is coming to me (as a member of

the

list).
Therefore please just ignore this.
___
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



--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
___
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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Simon Slavin]

On 10 Dec 2012, at 11:00am, Gilles Ganault  wrote:

> That's why I thought there could be a need for a datagrid that would
> save data in SQLite and provide basic sort/search functions.

There are lots of people who manipulate data that way, but they tend to export 
their data from the SQLite database into their favourite spreadsheet app, do 
the manipulation there, then reimport to SQLite.  This prevents them from 
having to use an app which doesn't have all the facilities they expect from 
their spreadsheet app.

The SQLite shell tool (free) makes the export and import processes easy (can be 
done in one command).

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt
 wrote:
>The only thing remaining for a decent workflow, which in
>the end is based on SQLite-storage, would then be a small
>batch-program or -script, which ensures the SQLite-To-CSV
>conversion (the sqlite-commandline-tool could do that) -
>accompanied by a second batch-file which ensures the
>back-conversion from CSV to SQLite-DBTable (and maybe
>also already the direct upload to a given WebServer).

Thanks for the idea. I actually do the opposit when I need to sort
data: Export from spreadsheet as CVS > import into SQLite, and run
some SQL commands.

That's why I thought there could be a need for a datagrid that would
save data in SQLite and provide basic sort/search functions.

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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Gilles Ganault]

On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black"
 wrote:
>Generally speaking database and spreadsheet functionality are not similar
>enough to combine.

Thanks for the input. Indee, maybe the two concepts are just too
different.

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

[sqlite] Link pragma.html#pragma_user_version invalid

[Ralf Junker]

In the list of PRAGMAs in

  pragma.html

the "PRAGMA user_version" documentation link to

  http://www.sqlite.org/pragma.html#pragma_user_version

is invalid. It should point to

  http://www.sqlite.org/pragma.html#pragma_schema_version

instead.

This is also present in today's documentation draft.

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