Re: [sqlite] SQlite exclusive table lock

On 3 May 2012, at 1:03am, Harnek Manj wrote: > So does it mean that in SQlite there is no way to stop the read operation > while a write operation is running, like table level exclusive lock. You seem to have jumped straight over the basic features of SQL and looked

Re: [sqlite] SQlite exclusive table lock

Pavel, So does it mean that in SQlite there is no way to stop the read operation while a write operation is running, like table level exclusive lock. Thanks Harnek -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel

Re: [sqlite] SQlite exclusive table lock

> I can't use WAL because it doesn't stop readers from reading. For this sort of synchronization you should use OS synchronization primitives, especially if you want to do that among different processes. Pavel On Wed, May 2, 2012 at 5:11 PM, Harnek Manj wrote: > Hi,

[sqlite] SQlite exclusive table lock

Hi, Should I use Shared-Cache in sqlite to have the exclusive table lock, so that readers have to wait for the write operation to finish. I don't want the complete database file locked while there is write operation. I can't use WAL because it doesn't stop readers from reading. Thanks Harnek

Re: [sqlite] Data Import Techniques

> Using the "Import Table Data" function in SQLiteman, the data loads very > quickly. However in my application, using either an SQL "insert" command or a > resultset, the import is very much slower. Is there another technique I can > use to speed things up? This FAQ entry might interest

Re: [sqlite] System.Data.SQLite and pooling problem

The fixes for this issue have now been merged to trunk along with an appropriate test case that can reproduce the issue. https://system.data.sqlite.org/index.html/ci/ae1f4354e4?sbs=0 -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Data Import Techniques

Did you try wrapping all your INSERT statements into a single transaction? BEGIN TRANSACTION INSERT... INSERT... ... COMMIT > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Nigel Verity > Sent: Wednesday, May 02, 2012

Re: [sqlite] Data Import Techniques

If you are not wrapping the inserts in an explicit transaction, try that. On 5/2/2012 9:04 AM, Nigel Verity wrote: Hi I am writing an application which requires approximately 50,000 items to be imported from a text file into a table. Each item is a single string of 8 characters, and the

[sqlite] Data Import Techniques

Hi I am writing an application which requires approximately 50,000 items to be imported from a text file into a table. Each item is a single string of 8 characters, and the target table has an auto-incrementing PK and one other field, to hold the 8 character string. Using the "Import Table

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

not sure yet ... but i'm working on it (between interruptions). thanks -Original Message- >From: "Black, Michael (IS)" >Sent: May 2, 2012 10:15 AM >To: General Discussion of SQLite Database >Subject: Re: [sqlite] is SQLite the right tool

Re: [sqlite] transactions and locking

Thank you both, I now have a better understanding. Lars ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

Using Reflector, I can see the resources: https://system.data.sqlite.org/temporary/linq_resources.png What is the exception you are seeing when the BuildTempSchema method is called? -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

Hi, I'm using the assembly in the GAC, the resource named "System.Data.SQLite.Linq.Properties.Resources.resources" is present but I could'nt see the SQL_CONSTRAINTS string resource in it browsing the assemblies 1.0.79.0 and 1.0.80.0 with ILSpy. I checked the resource string is not missing in

Re: [sqlite] Bug: Memory leak using PRAGMA temp_store_directory

Josh Gibbs wrote: > I reported this a while ago and forgot about this until today while I > was doing some debugging and once again got the report of leaked memory. > > I'm using the c amalgamation code from 3.7.10 with VStudio 2010, and > always start up my databases setting a temp directory to

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

TAUZIN Mathieu wrote: > > I've just noticed that a resource is missing in System.Data.SQLite.Linq.dll > since version 1.0.79.0. > I'm not able to reproduce this problem. When viewed with ILDASM, the resource named "System.Data.SQLite.Linq.Properties.Resources.resources" is present. Also, the

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Does that mean using the CLI worked for you? If so, you may be able to access the database with the other programs AFTER you create it. Seems that creating a db from csv is challenging to some and not thoroughly tested for large data sources. Michael D. Black Senior Scientist Advanced

[sqlite] Extended error code values

The list of extended error codes on http://www.sqlite.org/c3ref/c_abort_rollback.html are in a format that is fairly inconvenient when you're trying to lookup an error value. Below are what they resolve to, and I'm wondering if perhaps someone could update the page to show those values for future

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Thank you all. Look like I'm stuck with the CLI though I have contacted Nucleon software support ... tried CLI yesterday but need more practice. Is there a good reference book you would recommend for SQLite? peter -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] (no subject)

Hi Simon, thanks for the reply. I am using the C libraries as described in the link that you mentioned. I am not able to use a shell(or any other) [recompiled tool as the version of SQLite that I am using to create has the SEE (encryption) enabled. Whatever tool that I use I have to compile

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

Hi, I've just noticed that a resource is missing in System.Data.SQLite.Linq.dll since version 1.0.79.0. The missing resource causes an exception when calling the SQLiteProviderServices' ISQLiteSchemaExtensions.BuildTempSchema implementation. Hope this will help Mathieu TAUZIN

[sqlite] [ANN] ODB C++ ORM 2.0.0 released, adds support for C++11, polymorphism

I am pleased to announce the release of ODB 2.0.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major

Re: [sqlite] transactions and locking

On 2 May 2012, at 12:16pm, Lars Hansen wrote: > I'm sorry I have to bother you readers but I haven't understood > http://sqlite.org/lockingv3.html chapter 7. I've answered your questions in order, but they're all interrelated, so please read them all before worrying about the

Re: [sqlite] transactions and locking

On Wed, May 02, 2012 at 01:16:41PM +0200, Lars Hansen scratched on the wall: > Hello, > > I'm sorry I have to bother you readers but I haven't understood > http://sqlite.org/lockingv3.html chapter 7. > > 1. "In autocommit mode, all changes to the database are committed as > soon as all

[sqlite] transactions and locking

Hello, I'm sorry I have to bother you readers but I haven't understood http://sqlite.org/lockingv3.html chapter 7. 1. "In autocommit mode, all changes to the database are committed as soon as all operations associated with the current database connection complete." How does SQLite know when

Re: [sqlite] (no subject)

On 2 May 2012, at 8:55am, Octet Computech wrote: > I have an application that creates > and saves some data in a SQLite database. I am using SQLite v 3.6.14, > accessing > it through the native dll form a C# WPF application. For some reason that I > cant figure out am

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

Am 01.05.2012 22:06, schrieb peter korinis: I'm new to SQLite . not a programmer . not a DBA . just an end-user with no dev support for a pilot project (single user, no updates, just queries). I want to analyze the data contained in a 44GB csv file with 44M rows x 600 columns (fields all<15

Re: [sqlite] catastrophic installation on Ubuntu 11.10

Hello Richard I didn't heard from you since I send you the file. I have solved my problem by installing Win7 on virtualbox. I think your discussions are quiet interesting, but for my level, it is too much. Can you please remove me from the list? If you still have questions/solutions, you can

[sqlite] (no subject)

Here is the problem that I am having with SQLite with encryption extension enabled, and I need help. I have an application that creates and saves some data in a SQLite database. I am using SQLite v 3.6.14, accessing it through the native dll form a C# WPF application. For some reason that