>
> >I have read the article "
> > http://www.sqlite.org/fileformat.html#journal_file_formats"; and "
> > http://www.sqlite.org/fileformat.html#rollback_journal_method",but I
> > am even
> > more confused, anyone have some sample code for
> > rollback_journal_method.
>
> You do not handle r
On 27 Aug 2009, at 3:21am, danjenkins wrote:
> We use a julian.decimal format to represent date/time (i.e. noon of
> August
> 26, 2009 would be 40049.5000) and we use this julian date for an
> index key.
> Our databases are frequently up to 3GB in size containing 10 million
> records
> with
On Wed, Aug 26, 2009 at 9:21 PM, danjenkins wrote:
>
> Hello,
> We use a julian.decimal format to represent date/time (i.e. noon of August
> 26, 2009 would be 40049.5000) and we use this julian date for an index key.
> Our databases are frequently up to 3GB in size containing 10 million records
> w
Hello,
We use a julian.decimal format to represent date/time (i.e. noon of August
26, 2009 would be 40049.5000) and we use this julian date for an index key.
Our databases are frequently up to 3GB in size containing 10 million records
with 15 assorted field types per record and contain 6 months o
On Aug 26, 2009, at 8:09 PM, Paul Whipp wrote:
> Thanks for the reply Robert. It helps to know that it 'should' work.
>
> I get exactly the same result as you from "dpkg -l sqlite3"
>
> I uninstalled (aptitude purge sqlite3) and reinstalled and got
> exactly the
> same segmentation fault.
>
> C
Thanks for the reply Robert. It helps to know that it 'should' work.
I get exactly the same result as you from "dpkg -l sqlite3"
I uninstalled (aptitude purge sqlite3) and reinstalled and got exactly the
same segmentation fault.
Clearly, as its working on your system and not on mine there must b
Hi Matt,
> It appears to open, but it just spits out another compressed file,
> over and over -- like a cruel Matryoshka doll on my desktop.
>
> The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz
Yes, it is annoying. I've mentioned the problem here before. I think
DRH s
2009/8/27 Gilles Ganault :
> BTW, I noticed that "sqlite_master" has two columns that return the
> same thing: What is the difference between "name" and "tbl_name"?
It's different for indexes, wiews and triggers.
--
Kit
___
sqlite-users mailing list
sql
On Thu, 13 Aug 2009 09:10:11 -0500, Fred Williams
wrote:
>That's all you are suppose to get when querying the Master table for table
>names.
>
>You ask how to get a list of tables. That is what you got.
Thanks. I only needed to get the list of tables in an SQLite database
file, and Simon's tip w
On Sat, 8 Aug 2009 12:59:53 +0100, Simon Slavin
wrote:
>Not to start from zero that way. But you can create a record yourself
>which has a barcode of
>
>11
>
>to force the number of digits, and from then SQLite will count up from
>that one. (Test this first, I haven't tried exactly t
From: prayudinata
Avatar: Guest_prayudinata To: Sqlite-users@sqlite.org
On Aug 26, 2009, at 7:03 AM, Simon Slavin wrote:
>
> On 26 Aug 2009, at 1:27pm, P Kishor wrote:
>
>> However, on a Mac you don't really want this. Just download the
>> source
>> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
>> gunzip it, run make, make install, and it will in
Hi folks,
I've got a problem which has been confusing me for a few days, so its
time to ask the list for some insight.
I've got an application where there are two threads each reading from
distinct tables in the database. In the main thread, there is a SELECT
statement which returns a lot
On 26 Aug 2009, at 5:43pm, P Kishor wrote:
> Why would you want to use the factory installed stuff when installing
> your own and mucking around with your own version is so easy
Because you can give your resulting software to anyone else using a
Mac and know any tools they have will be able to
On Wed, Aug 26, 2009 at 9:03 AM, Simon
Slavin wrote:
>
> On 26 Aug 2009, at 1:27pm, P Kishor wrote:
>
>> However, on a Mac you don't really want this. Just download the source
>> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
>> gunzip it, run make, make install, and it will insta
On 26 Aug 2009, at 1:27pm, P Kishor wrote:
> However, on a Mac you don't really want this. Just download the source
> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
> gunzip it, run make, make install, and it will install all the bits
> and bobs for you in the right place.
Actu
On 26 Aug 2009, at 12:18pm, wrote:
> The observation is that when the permanent table population is
> complete, I find there are some records that are missing.
Are you getting errors returned from the calls which write those
records ?
Simon.
___
On 26 Aug 2009, at 11:42am, Zhanjun You wrote:
>I have read the article "
> http://www.sqlite.org/fileformat.html#journal_file_formats"; and "
> http://www.sqlite.org/fileformat.html#rollback_journal_method",but I
> am even
> more confused, anyone have some sample code for
> rollback_
I mean to say free to the OS so that it can use for other purpose.
SQlite frees but maintains to the memory will be present in SQLite memory
pool or heap. Not to the OS.
Regards
Shankar
On Wed, Aug 26, 2009 at 7:15 PM, Pavel Ivanov wrote:
> > SQLite currently does not support freeing of alloca
And I mean that you're wrong in this vision. SQLite doesn't keep
memory in pools if it doesn't belong to cache necessary to some open
connection. At least SQLite calls free() which of course doesn't
necessarily mean that memory will be returned to OS.
Pavel
On Wed, Aug 26, 2009 at 10:02 AM, shan
> SQLite currently does not support freeing of allocated memory
> unless it is shutdown.
It seams to me that you're wrong in this conclusion or elaborate
please how did you come to it.
In fact SQLite always frees all memory related to connection
(including cache) when you close it. And you can cle
> Can some one please tell me whether it is possible that the read thread is
> causing the write thread to miss inserting some records?
If you do not check for the result of executing INSERTs in write
thread and then blindly reset the statement then answer is yes. In
case if INSERT returned SQLIT
On 26/08/2009 5:47 AM, Matt Stiles wrote:
> Am I losing my mind, or is there something wrong with the bin.gz file on the
> download page? I've downloaded it several times, but I can't get it to open
> completely using Stuffit or the Mac archive utility. It appears to open, but
> it just spits out a
On Tue, Aug 25, 2009 at 2:47 PM, Matt Stiles wrote:
> Am I losing my mind, or is there something wrong with the bin.gz file on the
> download page? I've downloaded it several times, but I can't get it to open
> completely using Stuffit or the Mac archive utility. It appears to open, but
> it just s
FWIW, I've been running sqlite3 on Ubuntu 9.04 for a while without
issue for several months.
$ cat /etc/issue.net
Ubuntu 9.04
$ dpkg -l sqlite3
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Hold/Reinst-requi
Atul_Vaidya wrote:
> Hi, I have three tables,
> 1. Table Entity_xdata containing following fields
>> Entity_id|Layer|grpuid|
>
> 2. Table, group_xdata_pipe containing following fields
>> grpuid|LNV|
>
> 3. Table group_id_vs_reggappname containing following fields
>> grpuid|reggappname
Atul_Vaidya wrote:
>
>
> SELECT DISTINCT Entity_xData.grpuid from Entity_xdata INNER JOIN
> group_id_vs_regappname ON(Entity_xdata.grpuid =
> group_id_vs_regappname.grpuid AND group_id_vs_regappname.reg_appname =
> 'CPD1')
> I get the grpuids using this command and then i use the grpuids that i
Hi there,
I just installed sqlite3 using synaptic. Install went fine but:
~$ sqlite3 test.db
Segmentation fault
Can anyone point me to the relevant documentation/solution?
Regards,
Paul Whipp
www.paulwhippconsulting.com.au
Tel: +61 410 545 357
___
sql
Am I losing my mind, or is there something wrong with the bin.gz file on the
download page? I've downloaded it several times, but I can't get it to open
completely using Stuffit or the Mac archive utility. It appears to open, but
it just spits out another compressed file, over and over -- like a cr
> According to http://www.sqlite.org/lang_datefunc.html datetime('now')
> returns date and time already as UTC. If you add 'utc' modifier then
> it makes datetime() think that it's your local time and convert it to
> 'utc' thus adding 4 hours (apparently you're in GMT -4 timezone).
Thanks. I figu
Hi,
I am having two threads running say Thread-A and Thread-B. Thread-A is
populating a DB table with while Thread-B is trying to read
from the same table. In side Thread-B , I am creating a temporary table based
on filtered queries made on the
table which is getting populated by Thread-A. To m
2009/8/26 Zhanjun You :
> hello all,
> I have read the article "
> http://www.sqlite.org/fileformat.html#journal_file_formats"; and "
> http://www.sqlite.org/fileformat.html#rollback_journal_method",but I am even
> more confused, anyone have some sample code for rollback_journal_method.
>Fr
hello all,
I have read the article "
http://www.sqlite.org/fileformat.html#journal_file_formats"; and "
http://www.sqlite.org/fileformat.html#rollback_journal_method",but I am even
more confused, anyone have some sample code for rollback_journal_method.
thanks.
simon
_
Thanks!
-SK
On Tue, Aug 25, 2009 at 8:09 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> sub sk79 wrote:
> > I followed the exact instructions (
> > http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions) on SQLite wiki
> for
> > loadable extensions and still have
Hi, I have three tables,
1. Table Entity_xdata containing following fields
|Entity_id|Layer|grpuid|
2. Table, group_xdata_pipe containing following fields
|grpuid|LNV|
3. Table group_id_vs_reggappname containing following fields
|grpuid|reggappname|
Now, I need to Fire a query to
>> Well, now we want to add some sophisticated forensics features.
>> Currently we
>> have fancy filtering but no real OLAP sort of capability.
>>
> Are you talking straight OLAP, or do you have other forensic needs
> which will require you to roll your own functions ? The only mention
> of OLAP o
36 matches
Mail list logo
