At 8:39 PM -0600 11/14/07, andy wrote:
<[EMAIL PROTECTED]> writes:
> > * Somebody please suggest a better tag line -
> something better than "The World's Most Widely
> Used SQL Database".
How about:
"Small, Fast, Reliable. Choose any three."
I'm not sure if I heard that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Asif Lodhi wrote:
> Interestingly, Microsoft's SourceSafe (at least VS-6.0) apparently
> uses file system
It basically uses a whole bunch of directories and uses a scheme very
similar to RCS to store the versioning content.
> while SVN uses
Hi,
On 11/15/07, Andreas Volz <[EMAIL PROTECTED]> wrote:
> Am Tue, 13 Nov 2007 12:46:11 -0800 (PST) schrieb Ken:
>
> > I think your blob file performance may greatly depend upon the file
> > system that it used and the workload.
> >
> > I found this article:
> >
> >
[EMAIL PROTECTED] wrote:
The new look for the SQLite website is now in place,
if you haven't already noticed:
http://www.sqlite.org/
YUCK!
What happened?
Yesterday when I looked there was a simple summary of what SQLite was
about centred on screen (the whole page fitted vertically and
I agree; less is more. Way too many words on the front page now.
First, why have nav bars at top AND at the right side? (Plus vertical nav
bars are best put on the left side. )
I'd recommend just (something like) this text on the main page:
SQLite is a free, public domain, compact, embedded
<[EMAIL PROTECTED]> writes:
> >
> > * Somebody please suggest a better tag line -
> > something better than "The World's Most Widely
> > Used SQL Database".
How about:
"Small, Fast, Reliable. Choose any three."
I'm not sure if I heard that someplace, but I googled it and didnt
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> 5) There is no link to the CVStrac home page on the navigation bar
Developers
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
Steven Fisher wrote:
On 14-Nov-2007, at 3:37 PM, John Stanton wrote:
I am looking at it on a wide screen and it does not render to the full
screen width. I would guess that making the toolbar an image would
stop the wrapping. The image would scale to 100%.
I used to think it was a good
On 14-Nov-2007, at 3:37 PM, John Stanton wrote:
I am looking at it on a wide screen and it does not render to the
full screen width. I would guess that making the toolbar an image
would stop the wrapping. The image would scale to 100%.
I used to think it was a good thing when web sites
The simple answer is that current mass-market machines and software
strongly resist parallel processing. Newer architectures allow for
massively parallel execution and support software which can take
advantage of it fairly transparently. Each one needs to be used in such
a way as to maximize
[EMAIL PROTECTED] wrote:
"Scott Hess" <[EMAIL PROTECTED]> wrote:
I probably am misunderstanding something. The box scales down to
narrower windows just fine, so why can't the box scale until it hits
the width of my browser, and _then_ start doing the vertical-wrapping
thing?
There is a CSS
I took a quick look at the page with Firebug and could see that there
are spaces embedded in the toolbar, a Firefox feature. They could be
removed by concatenating the href's onto one line of text. The font
specified plus the spaces renders to a width greater than the table so
it wraps.
I
The navigation bar for me is on 2 lines - Support is wrapped to the
second line. Is that intended? (doesn't look right :))
Dennis
-
To unsubscribe, send email to [EMAIL PROTECTED]
* Suggestions for something better to put on
the home page.
I see the home page has been expanded. Very nice!
I would add some formatting to the overview text to
make it more visually appealing.
Perhaps make each paragraph a bullet item, with the
first sentence in bold:
o *SQLite
=?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECTED]> wrote:
>
> What happened to the download-page, I only see the "Direct Access To The
> Sources Via Anonymous CVS"?
>
Cockpit trouble. Fixed now.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Grzegorz Makarewicz wrote:
Michael Scharf wrote:
* Somebody please suggest a better tag line - something
better than "The World's Most Widely
Used SQL Database".
I really like this tag line! However, it would be great if
there would be a link with some information that
Andreas Volz wrote:
Am Tue, 13 Nov 2007 15:15:49 -0600 schrieb John Stanton:
You might find the method used by Squid to manage its cache would be
worth emulating.
I don't know how squid works. Could you explain it in simple steps?
I haven't looked at the code, but it builds a tree of
On 13-Nov-2007, at 5:40 PM, [EMAIL PROTECTED] wrote:
* Suggestions for something better to put on
the home page.
Yeah. My first thought when I brought up that page was "There's no way
I'm reading all that text!"... and I already use sqlite. I like the
points it goes over, though.
I have to agree about the amount of text on the front page.
What happened to the download-page, I only see the "Direct Access To The
Sources Via Anonymous CVS"?
Samuel R. Neff wrote:
Limiting the width is good, but the pixel-based limit can cause variations
on different resolutions and font
[EMAIL PROTECTED] wrote:
The new look for the SQLite website is now in place,
if you haven't already noticed:
http://www.sqlite.org/
Even though the new look is "in place" you should
understand this as a work in progress, not a done
deal. I am still looking for suggestions, comments,
and
On 11/14/07, John Stanton <[EMAIL PROTECTED]> wrote:
> Threads simulated in software are a kludge to better utilize current
> processor and operating system architectures. In time machines where
> the parallelism is handled in hardware will be more widely available and
> the threading will be
Limiting the width is good, but the pixel-based limit can cause variations
on different resolutions and font settings. I would suggest this instead:
max-width: 60em;
Which will cause the max width to adjust based on text size settings.
With the most recent change, I feel overwhelmed
wow! thanks.
On 11/14/07, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
>
> On Tue, 13 Nov 2007 20:46:06 -0500, "Benilton Carvalho"
> <[EMAIL PROTECTED]> wrote:
>
> >I'm in the process of creating the whole db now and will give it a
> >try... maybe creation is the worse part, as I'm going to be
"Scott Hess" <[EMAIL PROTECTED]> wrote:
> I probably am misunderstanding something. The box scales down to
> narrower windows just fine, so why can't the box scale until it hits
> the width of my browser, and _then_ start doing the vertical-wrapping
> thing?
>
There is a CSS parameter that
Jarl Friis wrote:
[EMAIL PROTECTED] writes:
I put up 4 variations. Please, everyone, offer your opinions:
(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
(3) http://sqlite.hwaci.com/v3/ CSS menus with
Michael Scharf wrote:
>> * Somebody please suggest a better tag line - something
>> better than "The World's Most Widely
>> Used SQL Database".
>
> I really like this tag line! However, it would be great if
> there would be a link with some information that supports/explains
> this
I probably am misunderstanding something. The box scales down to
narrower windows just fine, so why can't the box scale until it hits
the width of my browser, and _then_ start doing the vertical-wrapping
thing?
-scott
On Nov 14, 2007 10:59 AM, John Stanton <[EMAIL PROTECTED]> wrote:
> There
Am Tue, 13 Nov 2007 12:46:11 -0800 (PST) schrieb Ken:
> I think your blob file performance may greatly depend upon the file
> system that it used and the workload.
>
> I found this article:
>
> http://oss.sgi.com/projects/xfs/papers/filesystem-perf-tm.pdf
Very interesting document. But I
On Tue, 13 Nov 2007 20:46:06 -0500, "Benilton Carvalho"
<[EMAIL PROTECTED]> wrote:
>I'm in the process of creating the whole db now and will give it a
>try... maybe creation is the worse part, as I'm going to be accessing
>contiguous sets of rows (all columns) at a time... something like:
>
- Original Message
> From: John Stanton <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 14, 2007 11:43:48 AM
> Subject: Re: [sqlite] Re: Threads
>
> If you machine has a single disk it fundamentally does not have parallel
> I/O. If you have a machine with
Am Tue, 13 Nov 2007 15:15:49 -0600 schrieb John Stanton:
> You might find the method used by Squid to manage its cache would be
> worth emulating.
I don't know how squid works. Could you explain it in simple steps?
> Using TransmitFile on Windows or sendfile on Unix to despatch the
> file to
If you machine has a single disk it fundamentally does not have parallel
I/O. If you have a machine with multiple dik spindles and multiple
channels then you can have parallel access. Multiple Sqlite databases
residing on the same disk are accessed sequentially because the access
depends
No I'm not currently parallel I/O. But I was hoping to use multiple Sqlite
databases (in-memory, disk based etc), and wanted to know the recommended
policy in that case. At present, since SQLite is a single file, there can be no
parallel I/O within a single DB - right?
John Stanton <[EMAIL
I would not agree with that. Parallelism is very much architectural if
it to be better than yet another layer of software loading down what is
a non-parallel architecture.
It will be some time before the technology filters down to the mass users.
Joe Wilson wrote:
--- John Stanton <[EMAIL
--- John Stanton <[EMAIL PROTECTED]> wrote:
> One of the ignored points about thread usage is just how expensive are
> the synchronization mechanisms. It is a good idea to apply Occam's
> Razor to your design and eliminate unnecessary features and have a
> result which provides a better level
I notice that in Firefox on Linux with a maximized window on a
1600x1200 screen, the "Support" link in the navbar wraps around. The
navbar still looks nice, but since it's only half the width of my
screen, it shouldn't need to wrap. It also happens with narrower
browser windows, I'm guessing
How about when you need to take advantage of parallel I/O etc, or you need to
access multiple SQLite databases w/i a transaction?
Are you dissuading thread usage from DB application point of view, or even
within SQLite kernel?
Thanks in advance
- Uma
John Stanton <[EMAIL PROTECTED]>
Threads simulated in software are a kludge to better utilize current
processor and operating system architectures. In time machines where
the parallelism is handled in hardware will be more widely available and
the threading will be transparent and highly efficient.
Joe Wilson wrote:
One of the ignored points about thread usage is just how expensive are
the synchronization mechanisms. It is a good idea to apply Occam's
Razor to your design and eliminate unnecessary features and have a
result which provides a better level of functionality and a structure
which is much
And now for something completely different:
Bud Lite - Tastes great, less filling
SQLite - Works great, less bloat
/bow
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: Michael Scharf [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007
* Somebody please suggest a better tag line -
something better than "The World's Most Widely
Used SQL Database".
I really like this tag line! However, it would be great if
there would be a link with some information that supports/explains
this statement. Anybody could say "The
Threads are very much in the C tradition - minimalistic.
If you code in C you must know what you're doing anyway.
C is by no means a high level or safe language.
But until an automatically parallelizing safe language with
good performance becomes popular - this is what we got.
You just have to
--- Ken <[EMAIL PROTECTED]> wrote:
> In general I'v found that Thread cancellation is very painful,
> a simpler paradigm to utilize is the lock timeout with a Global
> variable status check.
Rather than check a global variable you could simply pass a null
event to the queue which instructs the
Why Threads Are A Bad Idea:
http://www.eecs.berkeley.edu/Pubs/TechRpts/2006/EECS-2006-1.pdf
From the article:
"Threads are a seemingly straightforward adaptation of the
dominant sequential model of computation to concurrent
systems. Languages require little or no syntactic changes to
Joe,
Great article. I generaly agree that threaded code much harder and should be
avoided where possible.
I fully agree that a work Queue with multiple threads servicing the queue is a
great technique. One that we've abstracted and have a library written against.
Some other helpful patterns
I have only glanced at the problem so I may have missed something but my
approach to a large matrix would be to realise it is a flat file and
mmap it. Your program would then treat it as a memory resident
structure. The VM features of the OS would perform paging as necessary
to keep a
Thanks!
Simplest solutions tend to be forgotten, unfortunately...
What I did was to simply replace every occurence of \r\n in my script with
LF character...
And it worked like a charm!
Thanks again!
With best regards,
J.R.
On Nov 14, 2007 4:46 PM, <[EMAIL PROTECTED]> wrote:
> "Jevgenijs
"Jevgenijs Rogovs" <[EMAIL PROTECTED]> wrote:
> I suppose I could try raising the limit of tree depth, or removing it
> whatsoever, but how do I do that, provided that I'm doing my import like
> this:
>
> sqlite3 mydatabase.db < myhugescript.sql
>
You are making this *way* harder than it needs
All you need to do is to test the returned status of your sqlite3_step
calls and if you get an error launch an SQL statement "ROLLBACK" and
bail out of the transaction. If there are no errors you complete your
transaction with an SQL "COMMIT".
sqlite_prepare_v2 SQL statements
exec
On 14/11/2007, Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote:
> Sounds too complicated for this simple situation...
> Can anything be done w/o coding?
>
Why not change
INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
into
INSERT INTO sometable VALUES ('blablabla
yadayadayada');
(real
Sounds too complicated for this simple situation...
Can anything be done w/o coding?
On Nov 14, 2007 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Jevgenijs Rogovs <[EMAIL PROTECTED]>
> wrote:
> > Thanks, but how do I use those?
> > See, I have a huge file of INSERT statements, which look
It runs fine as long as it is small...
If the text in the field is longer, it seems to crash.
Any idea how to drop that stupid depth limit? Where do I specify that
option?
The official site (http://www.sqlite.org/limits.html) does not explain
this...
On Nov 14, 2007 3:53 PM, Dan Kennedy <[EMAIL
Jevgenijs Rogovs <[EMAIL PROTECTED]>
wrote:
Thanks, but how do I use those?
See, I have a huge file of INSERT statements, which look like this:
INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
Prepare a single statement of the form
INSERT INTO sometable VALUES (?);
Then read your
On Wed, 2007-11-14 at 15:38 +0200, Jevgenijs Rogovs wrote:
> Thanks, but how do I use those?
> See, I have a huge file of INSERT statements, which look like this:
>
> INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
>
> What I need is to import this data into SQLite database. If I
I suppose I could try raising the limit of tree depth, or removing it
whatsoever, but how do I do that, provided that I'm doing my import like
this:
sqlite3 mydatabase.db < myhugescript.sql
Tried the -DSQLITE_MAX_EXPR_DEPTH=0 option on sqlite3 command line, but it
doesn't recognize it!
What am
d_maniger06 wrote:
i have a list of records that i want to insert in my database..if
ever an error occurred ( e.g. insert was not successful ), i want to
undo all the previous inserts that i have done..to do this, i have
read that i would need to use sqlite3_commit_hook and
Thanks, but how do I use those?
See, I have a huge file of INSERT statements, which look like this:
INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
What I need is to import this data into SQLite database. If I change all
\r\n occurances into the following:
INSERT INTO sometable
Jevgenijs Rogovs schrieb:
Hello everyone!
Could someone please assist me with the following: how do I insert a string
into an SQLite database that contains a CR or LF character? C-style escapes
(like \r and \n) are not working with SQLite, so how can I do this?
Depends on your sqlite
Jevgenijs Rogovs <[EMAIL PROTECTED]>
wrote:
Could someone please assist me with the following: how do I insert a
string into an SQLite database that contains a CR or LF character?
C-style escapes (like \r and \n) are not working with SQLite, so how
can I do this?
Use parameterized statements -
good day!..
i have a list of records that i want to insert in my database..if ever an
error occurred ( e.g. insert was not successful ), i want to undo all the
previous inserts that i have done..to do this, i have read that i would need
to use sqlite3_commit_hook and sqlite3_rollback_hook..i
Hello everyone!
Could someone please assist me with the following: how do I insert a string
into an SQLite database that contains a CR or LF character? C-style escapes
(like \r and \n) are not working with SQLite, so how can I do this?
Thanks in advance!
With best regards,
J.R.
Hello Benilton,
some years ago i came across pyTables ( http://www.pytables.org ).
It's a wrapper for the HDF5-format. PyTables claims to handle high
data-thruput very well. It supports Matrix/Array-formats as these are
typically used in scientific-projects. PyTables does not provide any
62 matches
Mail list logo