Re: [sqlite] SQlite on flash filesystem

Simon Slavin wrote: On 16 Aug 2014, at 9:32pm, Baruch Burstein wrote: On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: I am thinking about putting an SQLite database on a flash drive (SD card). I would like to know what kind of file system is

Re: [sqlite] SQlite on flash filesystem

On 16 Aug 2014, at 9:32pm, Baruch Burstein wrote: > On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: > >> I am thinking about putting an SQLite database on a flash drive (SD card). >> I would like to know what kind of file system is the optimal. I

Re: [sqlite] SQlite on flash filesystem

On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: > I am thinking about putting an SQLite database on a flash drive (SD card). > I would like to know what kind of file system is the optimal. I want to > query a lot, and insert or update a few times per minute. > Not

Re: [sqlite] geteuid call

> On 16 Aug 2014, at 8:48pm, Tal Tabakman wrote: > >> he question becomes "Are you running as root ? If so, do you have a >> good reason to be running as root ?" > > No, I am not running as root. I am running in one of those secure > chamber at customer site.can it be

Re: [sqlite] geteuid call

Hi Simon per your question he question becomes "Are you running as root ? If so, do you have a good reason to be running as root ?" No, I am not running as root. I am running in one of those secure chamber at customer site.can it be related ? On Sat, Aug 16, 2014 at 10:01 PM, Tal Tabakman

Re: [sqlite] geteuid call

On 16 Aug 2014, at 8:08pm, Richard Hipp wrote: > It comes from here: > http://www.sqlite.org/src/artifact/bd7df3094a609?ln=314-325 > > The posixFchown() function is used to ensure that the ownership of newly > created journal files match the ownership of the database file if

Re: [sqlite] geteuid call

On Sat, Aug 16, 2014 at 3:01 PM, Tal Tabakman wrote: > Hi Guys, > we have an application that generates database in sqlite format, > at customer, we saw while profiling that the geteuid() call done in > sqlite3.c is showing up rather high in our profiling report, any

Re: [sqlite] Long time to drop tables.

On Sat, Aug 16, 2014 at 2:41 PM, Jonathan Moules < jonathanmou...@warwickshire.gov.uk> wrote: > Hi List, > More of a curiosity. > I'm doing some general data munging and set off a query that consists > entirely of 37 DROP TABLEs in it. The database it's running against is > a bit less

[sqlite] geteuid call

Hi Guys, we have an application that generates database in sqlite format, at customer, we saw while profiling that the geteuid() call done in sqlite3.c is showing up rather high in our profiling report, any idea why ? what is this used for ? thanks Tal

Re: [sqlite] Long time to drop tables.

Do you have foreign key constraints on the tables? Are they enabled? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Jonathan Moules >Sent: Saturday, 16 August, 2014 12:41 >To: sqlite-users@sqlite.org >Subject: [sqlite]

Re: [sqlite] Long time to drop tables.

On 16 Aug 2014, at 7:41pm, Jonathan Moules wrote: > My questions is - why does it take so long? The total time required > to create this dataset (most of which was processing on the Python > side) was about 11 minutes. > > The total time

[sqlite] Long time to drop tables.

Hi List, More of a curiosity. I'm doing some general data munging and set off a query that consists entirely of 37 DROP TABLEs in it. The database it's running against is a bit less than 1GB made of about 5 million rows, and the tables being dropped constitute about 99% of the content.

Re: [sqlite] Does SQLite lock the entire DB for writes, or lock by table?

Hi guys, I've proceeded to test out whether SQLite could serve my needs and so far I am pretty optimistic that I can continue to use it at least until my game becomes massively popular. Wanted to share my results. My game does not in fact require a lot of write concurrency. It is just the