Re: [sqlite] Efficient usage of sqlite

On 2 Jan 2012, at 7:35am, Baruch Burstein wrote: > On Sun, Jan 1, 2012 at 8:12 PM, Simon Slavin wrote: > >>> First, don't worry about inefficient. What you need to worry about is >>> not-efficient-enough. For instance, your app taking 1/10th of a second >>> slower is

Re: [sqlite] Efficient usage of sqlite

On Sun, Jan 1, 2012 at 8:12 PM, Simon Slavin wrote: > > On 1 Jan 2012, at 5:27pm, Baruch Burstein wrote: > > > I need a file format to hold a bunch of resources for my program. I > thought > > of using SQLite. However, I am debating two formats. The > > more convenient one

Re: [sqlite] Is it bug? or need to enable any pragma for not null and unique while creating table

On 2 Jan 2012, at 5:25am, Durga D wrote: > "create table if not exists durtree (id integer primary key autoincrement, > c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5 > varchar[260], c6 varchar[260], c7 varchar[260], c8 varchar[260], c9 > varchar[260], c10 varchar[260],

Re: [sqlite] How to insert control characters into a table

Kai Peters wrote: > Hi, > > how can I insert a control character like carriage return? > > Something like: > > update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2 update ... 'Male' || X'0D' || 'Female' ... ___ sqlite-users mailing

Re: [sqlite] search

Dear Aris, Wish you a happy new year. I agree. I think, it may not support for search with wild chars. like vil* Can I get wild char search in leaf node or parent node with XML? Thanks, Durga. On Fri, Dec 30, 2011 at 8:05 PM, Aris Setyawan wrote: > Hi

Re: [sqlite] Is it bug? or need to enable any pragma for not null and unique while creating table

Thanks for your responses. Wish you a Happy new year. I tested with below query to create a table: "create table if not exists durtree (id integer primary key autoincrement, c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5 varchar[260], c6 varchar[260], c7 varchar[260],

Re: [sqlite] Transcoding?

On 1 Jan 2012, at 7:40pm, Zbigniew wrote: > Reading the contents of the blog > http://milky.manishsinha.net/2009/03/30/sqlite-with-c/ tried to follow > the tips to access SQLite database from C, but there's a problem: > actually database should keep UTF-8 encoded data. No problem, when > one's

[sqlite] Transcoding?

Reading the contents of the blog http://milky.manishsinha.net/2009/03/30/sqlite-with-c/ tried to follow the tips to access SQLite database from C, but there's a problem: actually database should keep UTF-8 encoded data. No problem, when one's using LATIN1 - but I tried LATIN2 strings, and they

Re: [sqlite] Efficient usage of sqlite

On 1 Jan 2012, at 5:27pm, Baruch Burstein wrote: > I need a file format to hold a bunch of resources for my program. I thought > of using SQLite. However, I am debating two formats. The > more convenient one for me would put every few resources in > a separate table. However, this would result

Re: [sqlite] Efficient usage of sqlite

2012/1/1 Baruch Burstein : > I need a file format to hold a bunch of resources for my program. I thought > of using SQLite. However, I am debating two formats. The > more convenient one for me would put every few resources in > a separate table. However, this would result in

[sqlite] Efficient usage of sqlite

I need a file format to hold a bunch of resources for my program. I thought of using SQLite. However, I am debating two formats. The more convenient one for me would put every few resources in a separate table. However, this would result in small tables. Am I right that this is very inefficient in

Re: [sqlite] How to insert control characters into a table

On Sat, 31 Dec 2011 13:16:58 -0800, Kai Peters wrote: > >Hi, > >how can I insert a control character like carriage return? > >Something like: > >update fielddefs > set choices = 'Male' || '\r' || 'Female' where id = 2 Line endings can be included in text literals: