I've met the same problem and I'll really appreciate, if this feature
starts to work. Maybe I've also missed something in doc.
Fanda
On Wed, 06 Dec 2006 02:45:30 +0100, Sandeep Suresh <[EMAIL PROTECTED]>
wrote:
When doing a select with join as :
select * from table_1
left join table_2
Youm need to contact Dr Hipp about that. I understand he has a special
embedded version of sqlite which omits the compiler and uses
pre-compiled VDBE code to reduce the footprint.
Kalyani Tummala wrote:
Hi,
In one of the group mails I have read about precompiled queries to
improve the
Hi,
In one of the group mails I have read about precompiled queries to
improve the performance and reduce the foot print size and also heap
size. In my application I have some fixed set of queries. Can some one
point me to the sections of code that I can manipulate to do the same?
Is it possible
On 12/5/06, Felix Hoffmann <[EMAIL PROTECTED]> wrote:
Questions: (1) Is it correct procedure to use sqlite_open() as the first
step, or do I need to perform some sort of memory allocation first?
sqlite_open() is the first step, so that is correct. Documentation is found
here:
On 12/5/06, made hendra <[EMAIL PROTECTED]> wrote:
Are there a way to protected sqlite database? with password
maybe.
I believe Dr. H has a commercial version that provides low level
encryption. If you are using .Net (Windows) then modified version of SQLite
that has password
Hello sqlite-users,
Are there a way to protected sqlite database? with password
maybe. So it can not be easily opened with "sqlite3.exe
somedatabase.db" or with some sqlite browser.
Thank You
--
Regards
made hendra <[EMAIL PROTECTED]>
When doing a select with join as :
select * from table_1
left join table_2
on table_1.column11 = table2.column21
column names are *not *qualified with table names. Instead, what I get
is column11, column12, column21, column22 and so on. ( where column11,
column12 are from table_1 and
On 3-Dec-06, at 7:24 AM, [EMAIL PROTECTED] wrote:
Max Barry <[EMAIL PROTECTED]> wrote:
My database is permanently locked, and I've spent two fruitless days
trying to unlock it.
The problem:
$ sqlite trac.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .databases
Error:
SQLite includes a Tcl API. Tcl does all these conversions with ease.
See the encoding convertto/convertfrom commands and fconfigure.
On Tuesday 05 December 2006 20:42, Nicolas Williams wrote:
> On Tue, Dec 05, 2006 at 06:53:28PM +0100, Marten Feldtmann wrote:
> > Perhaps it would be nice to
Hello Nicolas Williams,
>No, but having built-in functions that can do codeset conversion would
>be nice.
SQLiteSpy can do this: http://www.yunqa.de/delphi/sqlitespy/
-
To unsubscribe, send email to [EMAIL PROTECTED]
On Tue, Dec 05, 2006 at 06:53:28PM +0100, Marten Feldtmann wrote:
> Perhaps it would be nice to change sqlite3 in that way, that (when columns
> with storage class text) these columns are converted to the host platform
> code page. But actually even in that situation you may have strings, which
>
On Tue, Dec 05, 2006 at 09:58:02AM -0700, Dennis Cote wrote:
> select
>case
>when substr(ip, 2, 1) = '.' then -- one digit first quad
>case
>when substr(ip, 4, 1) = '.' then -- 1 digit second quad
>case
>when substr(ip, 6, 1) = '.' then -- 1 digit
Igor Tandetnik schrieb:
Da Martian <[EMAIL PROTECTED]> wrote:
So if I look at a name with umlaughts in the database via sqlite3.exe
I get:
Städt. Klinikum Neunkirchen gGmbH
--
|
an "a" with two dots on top
"A with umlaut" is represented as two bytes in UTF-8. sqlite3.exe just
dumps
On Tue, 5 Dec 2006, Kees Nuyt wrote:
what would be the best method to dump this db into another one to recover?
sqlite olddb .dump | sqlite newdb
this worked. thanks a million.
I have no idea what could cause the segfault, except perhaps a version
difference between the sqlite command
On Tue, 5 Dec 2006, Kees Nuyt wrote:
On Tue, 5 Dec 2006 08:06:41 -0700 (MST), you wrote:
what would be the best method to dump this db into another one to recover?
sqlite olddb .dump | sqlite newdb
thanks.
I have no idea what could cause the segfault, except perhaps a
version difference
Kevin Waterson wrote:
well, the range could be 256, or 16, or 131072 or 2048 or any other number
really.
but the IP will always be a valid IPv4 address.
Given a valid IPv4 address, I wish to find the range it falls into.
eg: SELECT * FROM table WHERE start < 203.7.136.123 AND 203.7.136.123 <
On Tue, 5 Dec 2006 08:06:41 -0700 (MST), you wrote:
>what would be the best method to dump this db into another one to recover?
sqlite olddb .dump | sqlite newdb
I have no idea what could cause the segfault, except perhaps a
version difference between the sqlite command program and the
sqlite
Da Martian <[EMAIL PROTECTED]> wrote:
So if I look at a name with umlaughts in the database via sqlite3.exe
I get:
Städt. Klinikum Neunkirchen gGmbH
--
|
an "a" with two dots on top
"A with umlaut" is represented as two bytes in UTF-8. sqlite3.exe just
dumps these bytes onto the
Hello Eduardo,
thank you for the hints given. Please can you tell me how to disable
journaling? In our project it is not important to have the database
persistent. We create the database, work with it, and destroy it within one
batch run. So we dont have to save it to disk ;-).
thank you so
Hi
I still cant seem to locate any, but I used the main icon from the homepage
and it looks pretty good on my about box.
Thanks,
On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Da Martian" <[EMAIL PROTECTED]> wrote:
> Hi
>
> Are there any powered by images for SQLite3?
>
A search
Hi
I have a system up and working using sqlite3, but I think I am having
unicode issues and I am not sure how I should go about coding the solution.
I was hoping someone could share the approach needed. Here is my situation:
I have german characters which "Umlauts" which I would like to get
On Tue, Dec 05, 2006 at 08:21:35PM +1100, Kevin Waterson wrote:
> This one time, at band camp, "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
>
>
> > I'd store the IPs in the DB in integer form as Lloyd suggested, if
> > range queries are your goal. Do conversion to and from display format
> > in
I would like to use SQLite with ToolBook, (an educational authoring
environment running on Windows).
I have searched the web and various archives, but nobody seems to have
done this before. There is no SQLite wrapper for the OpenScript language
that is part of TB.
I have linked the SQLite DLL
On 7/7/05, Vladimir Vukicevic <[EMAIL PROTECTED]> wrote:
On Wed, 2005-07-06 at 08:40 -0700, Scott Baker wrote:
> Looks like Firefox is gearing up to store some of its information in
> SQLite? Does anyone know anything more about this?
>
>
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> You can add a custom function which calls the dotted IP to IP function.
yeah, thats what I was hoping to avoid.
So, my solution is to use awk to snarf the IP addresses from csv file before
import
and the convert to long IP
Kevin Waterson wrote:
This one time, at band camp, "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
I'd store the IPs in the DB in integer form as Lloyd suggested, if
range queries are your goal. Do conversion to and from display format
in the application.
Yes, they are stored as INTEGER. and
I feel little difficulty in understanding what you actually want (I
thing the same is for all...). So could make it more clear? so that your
problem can be solved fast!
Thanks,
Lloyd.
Yes, they are stored as INTEGER. and the conversion outside sqlite
> is simple. However, I still need to
This one time, at band camp, "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
> I'd store the IPs in the DB in integer form as Lloyd suggested, if
> range queries are your goal. Do conversion to and from display format
> in the application.
Yes, they are stored as INTEGER. and the conversion
On 12/4/06, Kevin Waterson <[EMAIL PROTECTED]> wrote:
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> I suspect that you might find these blocks to be networks and subnets
> and consequently identified by the octets in the dotted IP.
yes, they would be nets and subnets.
> -Ursprüngliche Nachricht-
> Von: Eduardo Morras [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 1. Dezember 2006 19:44
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] for what reason :memory: is much slower than
> /dev/shm/dummy.db
>
>
> At 09:34 01/12/2006, you wrote:
> >Hi
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> I suspect that you might find these blocks to be networks and subnets
> and consequently identified by the octets in the dotted IP.
yes, they would be nets and subnets.
But how to identify them or single out a net/subnet?
31 matches
Mail list logo