Re: [sqlite] SQLite Viewer Tool

why not windows 2003/2008? 2009/7/10, Simon Slavin : > > On 8 Jul 2009, at 7:20pm, TSGames wrote: > > > I have developed a gui-based tool to create, edit and view SQLite > > databases. > > Just a note that this is a Windows 2000/XP/Vista/7 product only. > > Simon. >

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

Thank you very much for your post Just after I post the last code I know the concept of "reentrant" and "thread-safety". And you should notice the wrong usage of printf() in signal handle func. ^_^ So I re-writed the code and re-test. And the problem is still in someplace. So I re-post the

Re: [sqlite] blob c/c++ sample code

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wayne Anderson wrote: > I'm unclear about several things, but chief among them is how to set > the initial size of a blob. If you are using SQL then use: INSERT into foo values(zeroblob(12345)) If you are using bindings with a statement like:

[sqlite] blob c/c++ sample code

Hello, I'm converting an old application file format to use SQLite as a back end. For several sections of the file data I will need to use blobs. I'm unclear about several things, but chief among them is how to set the initial size of a blob. The documentation indicates that you need

[sqlite] Strange crashes

Heyas, I have a strange problem, which I hope you can help me with. Here we go: I am building a C# wrapper for SQLite. I just want to make a simple query like: SELECT * FROM TableA and this is what I do: 1. sqlite3_open 2. sqlite3_prepare_v2 3. sqlite3_column_name (to get the names of the

Re: [sqlite] multi-thread access to a db

Batching the orders and writing more data as one transaction will certainly yield better throughput, but at the risk of some data loss until the data is committed to disk. It sounds like you are building some type of OLTP/ Transaction logging system. Another good idea here is to also

Re: [sqlite] SQL Syntax

Cheers! Rick Ratchford ProfitMax Trading Inc. http://www.amazingaccuracy.com #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik #>Sent: Thursday, July 09, 2009 1:15 PM #>To: sqlite-users@sqlite.org

Re: [sqlite] Pros and cons of various online code sharing sites

>How do you plan to statically link your new library into multiple projects? >Are you planning to make a copy of the code files for each C# project that uses Sqlite? I use the "Add as Link". Again my goal was not to create a reusable library, but rather as a programming challenge to learn C#

Re: [sqlite] SQL Syntax

Rick Ratchford wrote: > select >(select min(Year) ...) as firstFullYear, >(select max(Year) ...) as lastFullYear; > > If I go with the condensed version you illustrate above, I assume > that I would then need to use the LIMIT clause, right? When I tried > it, I

Re: [sqlite] Pros and cons of various online code sharing sites

On Jul 9, 2009, at 12:09 PM, Noah Hart wrote: > > BACKGROUND: > In order to learn C#, I have spent the last year converting the > source code > of SQLite3 from C to C#. As of version 3.6.16, it is now ready to > release in > the wild. I don't want to self-host CVS or some other repository,

Re: [sqlite] Fetch whole result set to memory

Eberhard, Markus (external) wrote: > I'm using SQLite in my application and I would like to fetch the whole > result set of a select statement to memory. > I can't use sqlite3_get_table since it doesn't support BLOBs as far > as I know. > Currently I'm using

Re: [sqlite] Pros and cons of various online code sharing sites

I wholeheartedly agree about the importance of source control, even though my specific advice didn't really involve that. To the OP in particular: How do you plan to statically link your new library into multiple projects? Are you planning to make a copy of the code files for each C# project

Re: [sqlite] Pros and cons of various online code sharing sites

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Noah Hart wrote: > I have looked at sourceforge, googlecode, codeproject and a few others. > However, while they all look fine, I not sure what works well in the real > world. TL;DR: Being familiar with DVCS is an important developer skill these

Re: [sqlite] multi-thread access to a db

Right now I index off the order id. I can look into options for indexing - you are correct that it is more likely that I'll need to read an order I recently wrote than one that is older. However, since reading is ~.2% of the accesses to the db, all db work accounts for 2% of the cpu usage, it

Re: [sqlite] SQLite Viewer Tool

On 8 Jul 2009, at 7:20pm, TSGames wrote: > I have developed a gui-based tool to create, edit and view SQLite > databases. Just a note that this is a Windows 2000/XP/Vista/7 product only. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] multi-thread access to a db

On 9 Jul 2009, at 2:58pm, Rizzuto, Raymond wrote: > I have 4 servers, all with 4 cores. This is to handle a volume of > 10-20 million orders per day. > > Most of the work load (~90%) is unrelated to the database. In fact, > I added the database just to allow me to offload orders out of >

Re: [sqlite] multi-thread access to a db

I did some measurements and calculations, and writing to the db accounts for 2% of the processing in my system. Of course, that low percentage is due to the high transaction rate I got with asynch+exclusive. With 5 threads, I compute that contention would occur 20% of the time. That isn't

Re: [sqlite] multi-thread access to a db

Each thread has its own data. I.e. a thread only ever needs to read data that it wrote. I considered using the asynch io module described at http://www.sqlite.org/asyncvfs.html so that I could have a worker thread, but was dissuaded by the author, who suggested the asynch pragma instead. The

Re: [sqlite] Pros and cons of various online code sharing sites

By the way, Noah, I think share your feelings about DLL-free static linking in .NET. It ought to be easier to statically link to libraries in .NET, e.g. to create a truly standalone .EXE. This oversight is one of the main reasons I now avoid .NET. In particular, C# doesn't have "#include" or

Re: [sqlite] SQL Syntax

Rick Ratchford wrote: > Okay, this worked, but I have NO IDEA why. > >SQLString = "SELECT min(Year) FROM TmpTable " & _ >"WHERE Month=1 UNION " & _ >"SELECT max(Year) FROM TmpTable " & _ >"WHERE Month = 12 LIMIT 2" Read about aggregate

Re: [sqlite] Pros and cons of various online code sharing sites

In my personal experience Code Project is the most useful, especially if you work heavily with C#. I have worked with SourceForge and my personal opinion is that it's a bit too UNIX-oriented for my taste. I love UNIX, and use (for example) Cygwin and MinGW very extensively for development

[sqlite] Pros and cons of various online code sharing sites

BACKGROUND: In order to learn C#, I have spent the last year converting the source code of SQLite3 from C to C#. As of version 3.6.16, it is now ready to release in the wild. I don't want to self-host CVS or some other repository, so I am trying to decide where to post the code. My goals for

[sqlite] Fetch whole result set to memory

Hi, I'm using SQLite in my application and I would like to fetch the whole result set of a select statement to memory. I can't use sqlite3_get_table since it doesn't support BLOBs as far as I know. Currently I'm using function sqlite3_step to itterate through the result set; that function calls

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

Why do you re-post your code as if it's another question not related to previous one (along with the answer)? > does it mean that the sqlite3's C-api isn't reentrant or thread-safety? If SQLite is compiled with SQLITE_THREADSAFE = 1 or 2 then API is thread-safe (with some limitations when it's

Re: [sqlite] New Book Available

On Thu, Jul 9, 2009 at 8:50 AM, wrote: > On Thu, 9 Jul 2009, Rich Shepard wrote: > >> Rick van der Laans, who wrote the excellent "Introduction to SQL, 4th Ed." >> (and eariler editions, of course) has just had his new book specific to >> SQLite published. It is another

Re: [sqlite] multi-thread access to a db

Additional considerations: 1. Does the re-reading of data occur cross thread? If so you'll need some way to identify the DB that contains the data. 2. Consider using either a disk array or multiple disk drives, one for each db file. You probably should do some load testing at volume to

Re: [sqlite] SQLITE_OMIT_AUTOVACUUM seems to need small change inbtree.c

Hello Pavel & the community, Thank you for your quick answer. Actually, it could have been related but it is not. My problem is on a different set of functions that, indeed, are not found when SQLITE_OMIT_AUTOVACUUM is defined. The file I attached earlier solves the problem. I don't know if

Re: [sqlite] multi-thread access to a db

I have 4 servers, all with 4 cores. This is to handle a volume of 10-20 million orders per day. Most of the work load (~90%) is unrelated to the database. In fact, I added the database just to allow me to offload orders out of memory when they look done so that the app doesn't run out of

Re: [sqlite] New Book Available

On Thu, 9 Jul 2009, Rich Shepard wrote: > Rick van der Laans, who wrote the excellent "Introduction to SQL, 4th Ed." > (and eariler editions, of course) has just had his new book specific to > SQLite published. It is another resource for those who want a detailed > explanation of how to get the

[sqlite] SQLITE is not working in pthread

Hi All, I have used pthread_create(fedora 10) to insert data into database. But it is not working. Only sqlite3_open will execute first time. Not other things are executed in the thread. What should I do? Thanks & Regards Pramoda.M.A CREST | KPIT Cummins Infosystems Limited | Bengaluru | Cell:

Re: [sqlite] multi-thread access to a db

Ken, Yes, I know contention is possible. My application spends most of its time doing non-db operations - it is likely that locking contention isn't currently a big factor, but that will change as I increase the # of threads. Since each thread reads and writes its own data, I can definitely

[sqlite] New Book Available

Rick van der Laans, who wrote the excellent "Introduction to SQL, 4th Ed." (and eariler editions, of course) has just had his new book specific to SQLite published. It is another resource for those who want a detailed explanation of how to get the most from this great tool. I have no vested

Re: [sqlite] SQL Syntax

Rick Ratchford wrote: > Okay, this worked, but I have NO IDEA why. > >SQLString = "SELECT min(Year) FROM TmpTable " & _ >"WHERE Month=1 UNION " & _ >"SELECT max(Year) FROM TmpTable " & _ >"WHERE Month = 12 LIMIT 2" Read about aggregate functions

Re: [sqlite] Error is coming in Linux while openings Databse

If I remove sqlite3_get_table API, it is working fine. Now segfault error is coming. I am running in root only. Data is inserting properly, but unable to query the the database. Thanks & Regards Pramoda.M.A CREST | KPIT Cummins Infosystems Limited | Bengaluru | Cell: +91 91640 57663

Re: [sqlite] SQL Syntax

On Thu, 2009-07-09 at 10:47 +0200, Jean-Denis Muys wrote: > On 7/9/09 6:21 , "Rick Ratchford" wrote: > > > > > Okay, this worked, but I have NO IDEA why. > > > > SQLString = "SELECT min(Year) FROM TmpTable " & _ > > "WHERE Month=1 UNION " & _ > >

Re: [sqlite] Error is coming in Linux while openings Databse

Hi, Does the user under which the application runs have write permission on the Directory the database resides in? Are you sure that the segfault occurs inside sqlite and not in your own code? Martin Pramoda M. A schrieb: > Hi All, > >I am working on Fedora 10. Using C interfaces, I am

[sqlite] Error is coming in Linux while openings Databse

Hi All, I am working on Fedora 10. Using C interfaces, I am successfully opening database. No error while inserting data Into database. But after insertion, if I try to get data it is giving segmentation fault error. When I try to open using in-built sqlite3 commands, "Select * from File",

Re: [sqlite] SQL Syntax

Rick Ratchford wrote: > Okay, this worked, but I have NO IDEA why. > >SQLString = "SELECT min(Year) FROM TmpTable " & _ >"WHERE Month=1 UNION " & _ >"SELECT max(Year) FROM TmpTable " & _ >"WHERE Month = 12 LIMIT 2" Read about aggregate functions

Re: [sqlite] what is most effective way to temporarily disable triggers?

Hi, if you are talking about a feature request: Oracle supports sql syntax to enable or disable a certain trigger (as opposed to all triggers as you suggested): ALTER TRIGGER DISABLE or ALTER TRIGGER ENABLE This would be nice. Martin Michal Seliga schrieb: > hi > > attached is patch which

Re: [sqlite] what is most effective way to temporarily disable triggers?

hi attached is patch which will make temporary disable of triggers possible. i tried it in my application with current data (many inserts in to various table with many triggers on them, which are not meant to be run while importing data). it works and it changed running time from 62 seconds to 4,

Re: [sqlite] what is most effective way to temporarily disable triggers?

hi attached is patch which will make temporary disable of triggers possible. i tried it in my application with current data (many inserts in to various table with many triggers on them, which are not meant to be run while importing data). it works and it changed running time from 62 seconds to 4,

Re: [sqlite] Low-Cost data migration and ETL tools

Bombarded by Talend ads? As Lawrence says, Talend Open Studio is an option. It can do the job easily and less expensive than proprietary solutions that cost a lot of money. Some companies have budget problems and are having to reduce their cost of operation. You can have a look at the open

Re: [sqlite] SQL Syntax

On 7/9/09 6:21 , "Rick Ratchford" wrote: > > Okay, this worked, but I have NO IDEA why. > > SQLString = "SELECT min(Year) FROM TmpTable " & _ > "WHERE Month=1 UNION " & _ > "SELECT max(Year) FROM TmpTable " & _ >

[sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

does it mean that the sqlite3's C-api isn't reentrant or thread-safety? #include // for printf() #include // for signal() #include // for alarm() #include // for system() #include // for pthread_create()