Re: [sqlite] Licensing of SQLIte

Thank you all Great thanks for the numerous suggestions and explanations. Thanks and Regards, Sen On 4/26/2010 11:01 AM, Simon Slavin wrote: > On 26 Apr 2010, at 6:19am, Navaneeth Sen B wrote: > > >>> If you feel like you really have to purchase a license for SQLite, >>> Hwaci

Re: [sqlite] page_size

ah - good to know. that is what i was looking for. thanks tom On Apr 25, 2010, at 10:21 PM, Dan Kennedy wrote: > The page formats use 16-bit unsigned integers to store various offsets > (in bytes) to cells and free-blocks within a page. So it definitely > won't work with greater than 64KB pages

Re: [sqlite] Licensing of SQLIte

On 26 Apr 2010, at 6:19am, Navaneeth Sen B wrote: >> If you feel like you really have to purchase a license for SQLite, >> Hwaci , the company that employs the architect >> and principal developers of SQLite, will sell you one >>

Re: [sqlite] page_size

On Apr 26, 2010, at 11:09 AM, Tom Broadbent wrote: > > thanks for the replies. > > understood. i was informed that our underlying (EMMC??) FS will do > this w/ FS pages, i.e. read the entire 256k FS page, modify some > small portion of it, and write it out again. i'm higher in the > stack

Re: [sqlite] Licensing of SQLIte

Hello All, > > > Obtaining An Explicit License To Use SQLite > > Even though SQLite is in the public domain and does not require a > license, some users want to obtain a license anyway. Some reasons for > obtaining a license include: > > * You are using SQLite in a jurisdiction that does

Re: [sqlite] Licensing of SQLIte

On 26 Apr 2010, at 5:43am, Navaneeth Sen B wrote: > I just have some doubts on the licensing issues of SQLite. > > 1. Being open-source, is my company liable to post back > changes/modifications to > SQLite? What are the licensing terms & conditions? > 2. As our present development

Re: [sqlite] Licensing of SQLIte

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/25/2010 09:43 PM, Navaneeth Sen B wrote: > I just have some doubts on the licensing issues of SQLite. SQLite doesn't have a license - it is public domain - copyright has been waived. (Some countries claim you can't do this - allegedly Germany i

[sqlite] Licensing of SQLIte

Hello All, I just have some doubts on the licensing issues of SQLite. 1. Being open-source, is my company liable to post back changes/modifications to SQLite? What are the licensing terms & conditions? 2. As our present development is on a Linux variant, are there any pres

Re: [sqlite] values containing dash - not evaluated

> I don't know about SQLite2, but SQLite3 always expects strings in UTF-8 or > UTF-16 (depending on what API function you use: those that want UTF-16 > usually have "16" somewhere in their names). If you have a string in some > other encoding, you need to convert it to UTF-{8,16} before passing it

Re: [sqlite] values containing dash - not evaluated

jason d wrote: >> Even though I could not run your test, I believe you may be on to something > here. I suspected that encoding is a problem but I cannot seem to get > anything that explains this behaviour until you mention this. Does Sqlite2 > have anyway of specifying character encoding during IN

Re: [sqlite] page_size

thanks for the replies. understood. i was informed that our underlying (EMMC??) FS will do this w/ FS pages, i.e. read the entire 256k FS page, modify some small portion of it, and write it out again. i'm higher in the stack so i don't understand the underlying FS mechanisms; i've simply ask

Re: [sqlite] values containing dash - not evaluated

On Mon, Apr 26, 2010 at 11:50 AM, Igor Tandetnik wrote: > jason d wrote: > > On Mon, Apr 26, 2010 at 11:28 AM, Igor Tandetnik >wrote: > >> What does this statement return: > >> > >> select name, hex(name) from Groups > >> where name like '%jean%'; > >> > >> My guess is, you either have leading an

Re: [sqlite] values containing dash - not evaluated

jason d wrote: > On Mon, Apr 26, 2010 at 11:28 AM, Igor Tandetnik wrote: >> What does this statement return: >> >> select name, hex(name) from Groups >> where name like '%jean%'; >> >> My guess is, you either have leading and/or trailing whitespace around the >> value, or the dash in the middle i

Re: [sqlite] values containing dash - not evaluated

On Mon, Apr 26, 2010 at 11:28 AM, Igor Tandetnik wrote: > jason d wrote: > > I believe you misunderstood my problem. Its not that records dont exist. > and > > select statement for Bob does work. a select * does display all the data. > > its the names with dashes that dont shows up. and i have 40,

Re: [sqlite] values containing dash - not evaluated

jason d wrote: > I believe you misunderstood my problem. Its not that records dont exist. and > select statement for Bob does work. a select * does display all the data. > its the names with dashes that dont shows up. and i have 40,000 records. > any with dashes do not give any result on a pure sel

Re: [sqlite] values containing dash - not evaluated

On Mon, Apr 26, 2010 at 11:01 AM, Simon Slavin wrote: > On Mon, Apr 26, 2010 at 10:32 AM, Simon Slavin > wrote: > > > >> SELECT * FROM names WHERE name = 'bob' > > On 26 Apr 2010, at 3:54am, jason d wrote: > > > Hello Simon, > > First , thank you for responding. > > You're welcome. New text bel

Re: [sqlite] values containing dash - not evaluated

On Mon, Apr 26, 2010 at 10:32 AM, Simon Slavin wrote: > >> SELECT * FROM names WHERE name = 'bob' On 26 Apr 2010, at 3:54am, jason d wrote: > Hello Simon, > First , thank you for responding. You're welcome. New text below the text you're quoting, please. English is read top to bottom. > Ye

Re: [sqlite] values containing dash - not evaluated

Hello Simon, First , thank you for responding. Yes maybe in the email i used double quotes, but I have actually tried every quote/ quoteless combination. In fact initially the SQL was in single quotes. It does not work as expected, no results are returned an no error is thrown. Jason On Mon,

Re: [sqlite] values containing dash - not evaluated

On 26 Apr 2010, at 3:17am, jason d wrote: > when I use > > Select * from names where "name" = "bob"; > > it works fine. but whenever I use "name" = "diana-rogers" SQLite uses single quotes for strings, not double quotes. And the thing 'name' is meant to be the name of a column, not a fixed s

[sqlite] values containing dash - not evaluated

Hi there everyone, its very hard to find sqlite users so I am glad I joined this mailing list. Recently it seems a lot of people are using sqlite which I dont get but anyways. I am still using sqlite2 as the libraries I use do not support sqlite3 (yet). I am using it for web development. I ran in

Re: [sqlite] Searching with like for a specific start letter

On Sun, 25 Apr 2010 21:39:43 +0100, Alberto Simões wrote: >Hello > > I am running on the fly a query to count the number of > words starting with one of the 26 letters. > > I am doing the usual SELECT COUNT(term) from dictionary WHERE normword > LIKE "a%" (for the 26 letters) > >normword is the

Re: [sqlite] Searching with like for a specific start letter

On 25 Apr 2010, at 9:39pm, Alberto Simões wrote: > One idea is to add a column named 'letter' and SELECT COUNT(letter) > from dictionary WHERE letter = 'a'. That will be the simplest way to make a fast lookup, though it will slow down your INSERT function. You could speed it up a tiny bit more

Re: [sqlite] Searching with like for a specific start letter

Alberto Simões wrote: > I am running on the fly a query to count the number of words starting > with one of the 26 letters. > > I am doing the usual SELECT COUNT(term) from dictionary WHERE normword > LIKE "a%" (for the 26 letters) > > normword is the term normalized without accents and the like

[sqlite] Searching with like for a specific start letter

Hello I am running on the fly a query to count the number of words starting with one of the 26 letters. I am doing the usual SELECT COUNT(term) from dictionary WHERE normword LIKE "a%" (for the 26 letters) normword is the term normalized without accents and the like Is there any way to make t

Re: [sqlite] Search multiple columns AND extra coparator

Igor Tandetnik wrote: > > > Define "didn't work". What results did this query return, and how do these > results differ from your expectations? > >> it is not giving me any results at the moment. > > Well, do you actually have any records that match all the conditions? Show > a sample of you

Re: [sqlite] Search multiple columns AND extra coparator

flakpit wrote: >> SELECT * FROM sitelist >> WHERE > sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes > LIKE >'%wik%' >> AND category='Bundled Software' >> AND owner='Gary' >> ORDER BY sitename > > Hello Simon, that's what I tried first (yes, the '7' was a typo, sor

Re: [sqlite] [csv extension] feedback

On Apr 19, 2010, at 10:32:13 PDT, Shane Harrelson wrote: > Thanks for the report. The extension is still very a much a > work-in-progress and any feedback is greatly appreciated. > > -Shane Just in case you haven't already seen this, there is a published CSV spec for the text/csv MIME type: ht

Re: [sqlite] Search multiple columns AND extra coparator

>Just add your AND and ORDER by clauses on after the '%wik%'. But I don't know why there's a '7' at >the end of your original line. I don't think it does anything. Perhaps a typo when you made the post ? >SELECT * FROM sitelist >WHERE sitename||username||password||serialnum||misc1||misc2||misc

Re: [sqlite] Search multiple columns AND extra coparator

On 25 Apr 2010, at 2:44pm, flakpit wrote: > Using the first part of this query works fine to return data by searching > the multiple concatenated columns, very happy with that. > > SELECT * FROM sitelist > WHERE > sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes

[sqlite] Search multiple columns AND extra coparator

Hello folks, sorry to bother you. You must admit I take 6 months or more to ask questions:):) Using the first part of this query works fine to return data by searching the multiple concatenated columns, very happy with that. SELECT * FROM sitelist WHERE sitename||username||password||serialnum||

Re: [sqlite] Is there any memory leak in the normal routine?

Thank you very much! I test my code enough time, and the memory using indeed stop increases when the process's memory using is 3524 RES. And I try to "PRAGMA default_cache_size=100". Then the memory is just 1324 and stop increase. Black, Michael (IS) wrote: > > I confirmed your "memory lea