Re: [sqlite] Changing Date Format

On Wed, Oct 27, 2010 at 8:09 AM, jose isaias cabrera wrote: > > What I would like to do is a call that can fix the dates to the correct > format, ie. -MM-DD, so that the final data looks like this, > > How about UPDATE Table1 Set d1=Replace(Replace(d1, "-", "-0"),

Re: [sqlite] Changing Date Format

On 27/10/2010, at 3:09 PM, jose isaias cabrera wrote: > I know I can do a bunch of sets, such as this one, > > UPDATE table1 set d1 = '2010-01-01' > where > d1 = '2010-1-1'; > > but that is a lot of coding. Perhaps something like: create table table1 ( id integer primary key ,

[sqlite] Changing Date Format

Greetings and salutations. I have this data entry problem, that I have placed a fix for the users, but I have entries in the DB that have the wrong date format. There are dates entered in this format, 2010-1-1 instead of 2010-01-01. Say that I had this table, table1. id,st,ca,d1,d2

Re: [sqlite] Multiple databases vs. Multiple tables.

On boot up the device will discover the servers and enumerate what they have, then when it is done it will just wait for updates from the servers. I do not know how big the servers are, each server/media library may be different. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Multiple databases vs. Multiple tables.

On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Queries will be done across the servers to aggregate the content. I am > concern about the locking mechanism, if I write to the single database and > I represent the servers as tables I will have no access to read the other > servers/tables, but if

Re: [sqlite] SQLite install error

On 26 Oct 2010, at 11:59am, Dasa wrote: > When i tried to install new version on sqlite in my mac, i got this > error ... > > dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib > Referenced from: /users/dasaanand/Downloads/sqlite3_analyzer > Reason: image not found Please do not try to

Re: [sqlite] Multiple databases vs. Multiple tables.

Queries will be done across the servers to aggregate the content. I am concern about the locking mechanism, if I write to the single database and I represent the servers as tables I will have no access to read the other servers/tables, but if I distribute the servers across different DBs I can

Re: [sqlite] Multiple databases vs. Multiple tables.

On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Only one user (the browser). The DB is on a device the same place where > the user (Browser) is. A process will collect the information about the > servers and their contents and story it to the DB at the same time the > user may ask for the

Re: [sqlite] Multiple databases vs. Multiple tables.

Only one user (the browser). The DB is on a device the same place where the user (Browser) is. A process will collect the information about the servers and their contents and story it to the DB at the same time the user may ask for the contents to display on the screen. -Original

Re: [sqlite] Doubt about SQLite and its UTF-8 encoding format.

nhar...@gmail.com wrote: > Say, suppose I write a SQLite query to insert Japanese text which is encoded > in EUC-JP, in to a table in SQLite database (UTF-8 encoding). Don't. SQLite doesn't know anything about EUC-JP. Any string you pass to SQLite must be in UTF-8 or UTF-16. SQLite will convert

Re: [sqlite] Multiple databases vs. Multiple tables.

On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > in your opinion is it better (performance, maintainability etc...) to > have multiple databases or multiple tables. The problem I am facing is as > follows. I have many media servers containing a large amount of images > music and videos, let's

[sqlite] Multiple databases vs. Multiple tables.

Question, in your opinion is it better (performance, maintainability etc...) to have multiple databases or multiple tables. The problem I am facing is as follows. I have many media servers containing a large amount of images music and videos, let's assume 5. I would like to gather the

Re: [sqlite] Doubt about SQLite and its UTF-8 encoding format.

Hi All, *Ignore my previous email, Please. I am sorry for that SPAM email.* While referring the SQLite documentation, about the database encoding in the pages - http://www.sqlite.org/datatype3.html http://www.sqlite.org/pragma.html#pragma_encoding I learnt that

Re: [sqlite] Doubt about SQLite and its UTF-8 encoding format.

nhar...@gmail.com wrote: > While refering the SQLite documentation, about the database encoding in the > pages - > > >http://www.sqlite.org/datatype3.html So, what seems to be the problem? What exactly do you find unclear in this document? -- Igor Tandetnik

[sqlite] Doubt about SQLite and its UTF-8 encoding format.

Hi All, While refering the SQLite documentation, about the database encoding in the pages - http://www.sqlite.org/datatype3.html -- ¡Gracias! Harsha Reddy ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] BUG

Yes, I was wrong. Phisical order of records is equal to the useless sort condition in the view... Your examples can help me, thanks! -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] query help

Thank You. On 26 October 2010 13:14, Igor Tandetnik wrote: > Paul Sanderson wrote: >> I have two tables, table b is a subset of table a. both tables have >> the same primary key >> >> I want to update the rows from table a with a single column

Re: [sqlite] query help

Paul Sanderson wrote: > I have two tables, table b is a subset of table a. both tables have > the same primary key > > I want to update the rows from table a with a single column from table > b, what sql command would be most efficient for this? update a set

Re: [sqlite] BUG

Alexey Pechnikov wrote: > 2010/10/26 Dan Kennedy > >> The sorting happens after the grouping. And it is while processing >> the GROUP BY clause that SQLite is forced to select an arbitrary >> record from the user_record table. >> >> See here: >>

[sqlite] SQLite install error

When i tried to install new version on sqlite in my mac, i got this error ... dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib Referenced from: /users/dasaanand/Downloads/sqlite3_analyzer Reason: image not found what does it mean ?? ___

[sqlite] query help

I have two tables, table b is a subset of table a. both tables have the same primary key I want to update the rows from table a with a single column from table b, what sql command would be most efficient for this? Thanks ___ sqlite-users mailing list

Re: [sqlite] BUG

Richard, with "PRAGMA reverse_unordered_selects = 1;". it's returns count(*)=0. This is strange for me and not help for development. 2010/10/26 Richard Hipp > On Mon, Oct 25, 2010 at 4:06 PM, Alexey Pechnikov >wrote: > > > > The result of the view

Re: [sqlite] BUG

2010/10/26 Dan Kennedy > The sorting happens after the grouping. And it is while processing > the GROUP BY clause that SQLite is forced to select an arbitrary > record from the user_record table. > > See here: > > http://www.sqlite.org/lang_select.html#resultset > >

Re: [sqlite] BUG

On Oct 26, 2010, at 2:22 PM, Alexey Pechnikov wrote: >> But view_user statement makes no attempt to select the last >> version. It > picks some arbitrary random version. You might want to consider > something > like this: > > Why you wrote about "some arbitrary random version" when we have

Re: [sqlite] BUG

> But view_user statement makes no attempt to select the last version. It picks some arbitrary random version. You might want to consider something like this: Why you wrote about "some arbitrary random version" when we have sorting by "ts"?.. CREATE TABLE user ( id INTEGER PRIMARY KEY );

Re: [sqlite] Memory Resident Database

Hai, I am using SQLite with c.To increase the performance I am using inmemory Database. How Can I view the contents stored in the inmemory database? Please help me. Regards, B.Durgadevi marcglennjamon wrote: > > Hello guys, > > Is there an option in SQLite to make the database file