[sqlite] Memory leak?

I tried to call sqlite3_release_memory() after > every database command. Same result. > > Best regards > > Matthias Schmitt > > magic moving pixel s.a. > 23, Avenue Grande-Duchesse Charlotte > L-3441 Dudelange > Luxembourg > Phone: +352 54 75 75 > http://www.mmp.lu > > > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Gregory Moore thewatchfulone at gmail.com

[sqlite] Split Function for SQLite?

I need to split up a list of items in a single row so they each have their own row. Basically I need to take this: Key. Code -- 1. V1, v2, v3 And convert it to this: Key. Code -- 1. V1 1. V2 1. V3 After much googling I'm thinking I need a split

[sqlite] Split Function for SQLite?

I need to split up a list of items in a single row so they each have their own row. Basically I need to take this: Key. Code -- 1. V1, v2, v3 And convert it to this: Key. Code -- 1. V1 1. V2 1. V3 After much googling I'm thinking I need a split

Re: [sqlite] Split Function for SQLite?

Thanks for answering! Can this not be added as a function? On Aug 22, 2011, at 10:43 PM, Igor Tandetnik wrote: > Gregory Moore <thewatchful...@gmail.com> wrote: >> I need to split up a list of items in a single row so they each have >> their own row. >>

Re: [sqlite] Split Function for SQLite?

: http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx Would that work with SQLite? On Aug 24, 2011, at 8:40 PM, Igor Tandetnik wrote: > On 8/24/2011 9:36 PM, Gregory Moore wrote: >> Thanks for answering! Can this not

Re: [sqlite] Split Function for SQLite?

would run the risk of messing up my SQLite "installation." Thanks! On Aug 24, 2011, at 9:35 PM, J.M. Royalty wrote: > On 8/24/2011 9:05 PM, Gregory Moore wrote: >> I'm thinking it's parameters would be the name of a column and a character >> to designate where the string

Re: [sqlite] SQLite on a Mac: PHP doesn't know about :-(

It was my understanding that any version of SQLite is written using the C programming language which happens to be a procedural language (as in not OOP) so I'm not sure why OOP is even part of the discussion. Or maybe I just need to be educated further. :-) Greg Moore thewatchful...@gmail.com

Re: [sqlite] [EXTERNAL] Number of rows in answer set

Are you using SQLite from within an application? Here are some things I do: 1. Put query results into an array and get the count of items in the array. 2. For some tables, store the record count of the table into another table. Then just read that value when you need it. I use triggers to help

Re: [sqlite] Database Variable

>> On Jan 2, 2018, at 1:49 PM, Gregory Moore <thewatchful...@gmail.com> wrote: >> >> I was poking around in FMDB’s source code on github. FMDB is a widely used >> Objective-C wrapper around SQLite. I was looking to see what they do out of >> curiosi

[sqlite] Database Variable

Hi I have an Objective-C iPhone application developed using Xcode. I have a singleton object which serves as the database controller. I use the SQLite C APIs to interact with the database. It works really well but I’m curious about something. In my app, I declare my database instance variable

[sqlite] Database Variable

Hi I sent this message previously, but it ended being a reply in another thread which was not my intention. So let’s try one more time... I have an Objective-C iPhone application developed using Xcode. I have a singleton object which serves as the database controller. I use the SQLite C APIs

Re: [sqlite] Happy birthday to the SQLite Fossil repo

Happy belated birthday to the Sqlite Fossil repo. Will there be cake and candles? Greg Moore thewatchful...@gmail.com > On Aug 17, 2019, at 10:39 PM, jungle boogie wrote: > > Just fun trivia that drh pointed out elsewhere late last month... > > Ten years ago today, the first commit for