Re: [sqlite] Simple Select from IN - from a newbie.

CTEs seems like another magic ball. I just read up a little bit about them. The bag of tricks is getting more colorful. I would love to use this new feature, sadly the version of Sqlite is 3.7.7.1, you mentioned views, is this something that I can use for the version of Sqlite that I'm on.

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/22 17:25, Humblebee wrote: Oops back sooner than I thought. I would like to order the grouping of the Persons in a particular order. So the sequence of the result is based on the TeamPersonTable's order field. First a word of warning - Please do not use column names that are the

Re: [sqlite] Problem in query planner?

On Thu, May 22, 2014 at 5:34 PM, Abramo Bagnara wrote: > $ sqlite3 > SQLite version 3.8.4.3 2014-04-03 16:53:12 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create

Re: [sqlite] Release date of Windows Phone 8.1 SQLite

Klemen Forstneric wrote: > > is there a release date for the Windows Phone 8.1 version of SQLite (the > one available here: > http://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2a f75d1b) > The current plan is to release it when SQLite 3.8.5 is released. -- Joe

[sqlite] Problem in query planner?

$ sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t(a, b, c); sqlite> create index t_ab on t(a, b); sqlite> create index t_ac on t(a, c);

[sqlite] Release date of Windows Phone 8.1 SQLite

Hey everyone, is there a release date for the Windows Phone 8.1 version of SQLite (the one available here: http://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2af75d1b) ? Cheers, Klemen Forstnerič ___ sqlite-users mailing list

Re: [sqlite] Simple Select from IN - from a newbie.

Oops back sooner than I thought. I would like to order the grouping of the Persons in a particular order. So the sequence of the result is based on the TeamPersonTable's order field. TeamTable +---+ | id | name | +---+ | 1 | blue| | 2

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 4:55 PM, Dominique Devienne wrote: > On Thu, May 22, 2014 at 3:26 PM, Noel Frankinet > wrote: > > I propose Musqlar, the Mighty universal sql Archiver :-) > > Sounds like Musk-lar, so you loose the S.Q.L. of sqlar which

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 3:26 PM, Noel Frankinet wrote: > I propose Musqlar, the Mighty universal sql Archiver :-) Sounds like Musk-lar, so you loose the S.Q.L. of sqlar which sounds to me like C-quel-ar ;) ___ sqlite-users

Re: [sqlite] Load time performance

On 22 May 2014, at 1:12pm, Hadashi, Rinat wrote: > The first time I access a database takes significantly more time than > subsequent accesses. > I am looking for ideas to shorten the time required for the first access. Access it before you need it. You understand

Re: [sqlite] Suggestion for shell .IMPORT improvement

I propose Musqlar, the Mighty universal sql Archiver :-) On 22 May 2014 15:22, Dominique Devienne wrote: > On Thu, May 22, 2014 at 1:51 PM, Richard Hipp wrote: > > How about "sqlar" for "SQL Archive"? http://www.sqlite.org/sqlar > > I like it! Sounds

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 1:51 PM, Richard Hipp wrote: > How about "sqlar" for "SQL Archive"? http://www.sqlite.org/sqlar I like it! Sounds ominous when pronounced out loud :). Much better name IMHO, and no negative connotation in French that I know of. --DD

Re: [sqlite] Load time performance

You shouldn't access a SQLite database remotely, except maybe for read only access, but that could come under fire. Any network file action can't guarantee that write locks happen. If you attempt to access a file in READ-ONLY mode, you'll be greeted with a 1-5 second delay (I don't remember what

Re: [sqlite] Simple Select from IN - from a newbie.

RSmith, Two thumbs up for your super kind help. I will study the queries that you gave and try them backwards and forwards to better understand the magic. Hope you don't mind if I ask more newbie questions in the future. Cheers to the many nice people in this Great list. On 5/22/14, fantasia

Re: [sqlite] Simple Select from IN - from a newbie.

I'm very happy to have taken the advice of the Awesome people on this list to add an additional table and make the data normalized. From today, I learned that the word Normalized -> Magic. On 5/22/14, fantasia dosa wrote: > Ah yes, you are correct. > > It was my typo.

Re: [sqlite] Simple Select from IN - from a newbie.

Ah yes, you are correct. It was my typo. Works perfectly. On 5/22/14, RSmith [via SQLite] wrote: > > > I'm trying to understand the grouping magic and testing the first and > last query. > Only thing is for some reason, I'm not getting any result for the

Re: [sqlite] Simple Select from IN - from a newbie.

I'm trying to understand the grouping magic and testing the first and last query. Only thing is for some reason, I'm not getting any result for the last query. Perhaps i'm doing something wrong. Works perfectly for me, are you sure you have it exactly so? Check the table names correspond to

Re: [sqlite] Simple Select from IN - from a newbie.

I'm trying to understand the grouping magic and testing the first and last query. Only thing is for some reason, I'm not getting any result for the last query. Perhaps i'm doing something wrong. On 5/22/14, RSmith [via SQLite] wrote: > > > > On 2014/05/22

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/22 14:28, Humblebee wrote: Thanks for your answers. Wow, I just tried the "Group" thing and it's truly magic. Big Bang ! The first query gave the Exact answer I was looking for. It even assembled a string. Amazing how this works. I agree :) Is the last query the equivalent of

Re: [sqlite] Simple Select from IN - from a newbie.

Thanks for your answers. Wow, I just tried the "Group" thing and it's truly magic. Big Bang ! The first query gave the Exact answer I was looking for. It even assembled a string. Amazing how this works. Is the last query the equivalent of the first query? On 5/22/14, RSmith [via SQLite]

[sqlite] Load time performance

Hi The first time I access a database takes significantly more time than subsequent accesses. I am looking for ideas to shorten the time required for the first access. I work on Linux, my db. file is "somewhere" in the file system, not locally on the machine from which I am running sqlite3

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/22 13:39, Humblebee wrote: TeamTable +---+ | id | name | +---+ | 1 | blue| | 2 | green | +---| PersonTable +--+ | id | name | +--+ | 4 | john | | 5

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 7:46 AM, Richard Hipp wrote: > > > > On Thu, May 22, 2014 at 7:36 AM, Dominique Devienne > wrote: > >> On Thu, May 22, 2014 at 12:39 PM, Richard Hipp wrote: >> > Hyperlink has changed. It is now called "sfa"

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 7:36 AM, Dominique Devienne wrote: > On Thu, May 22, 2014 at 12:39 PM, Richard Hipp wrote: > > Hyperlink has changed. It is now called "sfa" instead of "sar": > > I can't read "sfa" w/o remembering tv ads [1] for the toilet >

Re: [sqlite] Simple Select from IN - from a newbie.

select p.id,p.name from TeamPersonTable tp join PersonTable p on (p.id = tp.personId) where tp.teamId = 1; -Ursprüngliche Nachricht- Von: Humblebee [mailto:fantasia.d...@gmail.com] Gesendet: Donnerstag, 22. Mai 2014 13:40 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Simple Select

Re: [sqlite] Simple Select from IN - from a newbie.

TeamTable +---+ | id | name | +---+ | 1 | blue| | 2 | green | +---| PersonTable +--+ | id | name | +--+ | 4 | john | | 5 | bill | +-+---+

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 12:39 PM, Richard Hipp wrote: > Hyperlink has changed. It is now called "sfa" instead of "sar": I can't read "sfa" w/o remembering tv ads [1] for the toilet equivalent to a sink garbage disposal :) Some acronyms don't cross language barriers w/o harm,

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/22 13:02, Humblebee wrote: @RSmith, Very much appreciate you taking the time to write such a detailed and awesome explanation of how the string and list works in SQL. I had no idea what goes on there. It is my pleasure, sadly I know exactly how it feels to be under the wrong

Re: [sqlite] Simple Select from IN - from a newbie.

To be more clear. So now I have 3 tables. Person Team Person_Team Query: 1. Get all persons that belongs to a certain team. The output should be: persons = "name1,name2,name3" personIds = "id1,id2,id3" So in other words, each field is a string delimited by a comma. On 5/22/14, fantasia

Re: [sqlite] Simple Select from IN - from a newbie.

@RSmith, Very much appreciate you taking the time to write such a detailed and awesome explanation of how the string and list works in SQL. I had no idea what goes on there. I also liked the car-jacking example, very funny - that made the entire thing very clear. You're right, I wouldn't

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/22 11:39, Humblebee wrote: Thank you everyone for your kind input and suggestions. That is quite a lot to consider. I didn't realize it would be so difficult for a Select statement to return a string. Out of curiosity, when I do: SELECT * FROM Person WHERE id IN(2,2,3,3) It

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Thu, May 22, 2014 at 4:22 AM, Kees Nuyt wrote: > On Sun, 18 May 2014 01:06:42 +0300, wrote: > > > PS. By the way, any progress on the shell enhancement to load/save blobs? > > This will make the shell capable of handling any database without the > need > >

Re: [sqlite] Simple Select from IN - from a newbie.

Looks like all roads are pointing to creating a Normalized table structure. So if I were to add another table Person_Team table and not use the string as everyone is suggesting, then how would the SQL statement look to retrieve the data. On 5/22/14, Hick Gunter [via SQLite]

Re: [sqlite] Simple Select from IN - from a newbie.

No. The internal table stores only unique keys. -Ursprüngliche Nachricht- Von: Humblebee [mailto:fantasia.d...@gmail.com] Gesendet: Donnerstag, 22. Mai 2014 11:39 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Simple Select from IN - from a newbie. Thank you everyone for your kind

Re: [sqlite] Simple Select from IN - from a newbie.

Thank you everyone for your kind input and suggestions. That is quite a lot to consider. I didn't realize it would be so difficult for a Select statement to return a string. Out of curiosity, when I do: SELECT * FROM Person WHERE id IN(2,2,3,3) It doesn't seem to give back 4 rows, only 2.

Re: [sqlite] Suggestion for shell .IMPORT improvement

On Sun, 18 May 2014 01:06:42 +0300, wrote: > PS. By the way, any progress on the shell enhancement to load/save blobs? > This will make the shell capable of handling any database without the need > for external programs. I think SQLite File Archiver comes very close: