with SQLite Encryption Extension?
On 12/4/15, Ribeiro, Glauber wrote:
> We have an Android application built on PhoneGap, which uses the built-in
> SQLite to store data.
>
> Does anybody here know if it's possible to replace the built-in SQLite in
> PhoneGap (Android) with a versio
We have an Android application built on PhoneGap, which uses the built-in
SQLite to store data.
Does anybody here know if it's possible to replace the built-in SQLite in
PhoneGap (Android) with a version that supports encryption (S.E.E. or other
kind), so that the application information
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Angus March
Sent: Tuesday, September 22, 2009 8:40 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Why are allowed to keep a text of 3 characters in
a field
Unfortunately, the 3 main families of small computer operating systems
have 3 different definitions of what a text file is...
DOS/Windows (PC): lines are terminated with CR+LF
Unix: lines are terminated with LF
Macintosh: lines are terminated with CR
This causes no end of trouble when moving
ge-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ribeiro, Glauber
Sent: Wednesday, August 12, 2009 4:35 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLJet - pure Java implementation of SQLite
andNestedVM version
I had the impression that the NestedVM version worked under Linux only,
is this incorrect?
g
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Wednesday, August 12, 2009 3:54 PM
To: General Discussion of
I took only a quick look, but it seems to me that sqlite3_free is only
being called if there is an error.
See http://sqlite.org/c3ref/exec.html
g
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Greg Morehead
Sent: Friday,
Yes, and Control-Z exits sqlite3, in Windows, as expected.
g
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel Ivanov
Sent: Monday, May 04, 2009 2:01 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to exit from
You can only use one command in the command-line. Use options for the
others, like this:
Sqlite3.exe -csv -separator ',' ioimport.db3 "select * from iotemplate;"
>thisisit.csv
-Original Message-
From: Richard Nero [mailto:rich...@rlnero.com]
Sent: Monday, March 30, 2009 10:12 AM
To:
Are you looking perhaps for digest mode? Yes, there is a digest mode for
the SQLite email lists, it's one of the options you can set up.
Or are you thinking of posts that were made under the influence of
distillates? :)
g
-Original Message-
From: liubin liu [mailto:7101...@sina.com]
How heavy? How many kg? :)
http://www.sqlite.org/faq.html#q5
If it's all reads, you're fine, but if anyone is writing, all others are
blocked until that transaction is finished. Locks are at database, not
record or table level.
g
-Original Message-
From: Eversogood
You may not have a column name; it might be a calculated column; for
example, count(*)
g
-Original Message-
From: John Machin [mailto:sjmac...@lexicon.net]
Sent: Tuesday, February 03, 2009 2:05 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] drop table question ?
On
My only suggestion at the moment, please use the amalgamation instead of
individual files. This makes it much easier to upgrade when SQLite
releases a new version.
g
-Original Message-
From: Clark Christensen [mailto:cdcmi...@yahoo.com]
Sent: Wednesday, January 14, 2009 10:19 AM
To:
Yes, the amalgamation driver is the better way to do this. It has been
working for me, for several SQLite updates.
g
-Original Message-
From: Jim Dodgen [mailto:j...@dodgen.us]
Sent: Monday, January 12, 2009 10:42 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite]
Brazil, but living in the Chicago area of the USA since 1991.
-Original Message-
From: MikeW [mailto:mw_p...@yahoo.co.uk]
Sent: Monday, January 12, 2009 6:35 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Hi, a question from Colombia
Ribeiro, Glauber <glauber.ribe...@...>
Carlos,
If you don't mind, I'll answer through the list, because there are
people there who know much more than I do.
Here's your question:
> Here I'm looking for subtract two datefields from diferentes tables if
> the field1 is not null, if that field is null the value is 'without
> close'
Hi, Carlos,
People here are helpful and friendly, and we will try to help you in our
abundant free time, but try to include as much information as possible
with your question, so we can give you meaningful answers.
For example, don't just ask "why is my SQL so slow?", but tell us
specifically
You didn't mention which OS you're in. This works in Unix:
$ sqlite3 -help
Usage: sqlite3 [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
OPTIONS include:
-init filename read/process named file
If the data were small I'd do a case statement, otherwise, create a
table with the ranges and join that to your main table.
g
-Original Message-
From: Jonathon [mailto:thejunk...@gmail.com]
Sent: Wednesday, December 31, 2008 5:16 AM
To: General Discussion of SQLite Database
Subject:
Perhaps the directory name is mispeled? Do "$!" or "$@" have anything
interesting in them?
Perl's debugger is invoked with the -d switch. See the "perldebug"
document
-Original Message-
From: LUKE [mailto:l...@tc.program.com.tw]
Sent: Thursday, December 18, 2008 1:31 AM
To:
This should return only one record, right? So you shouldn't need the
second order by ("order by f.type asc, f.price desc").
-Original Message-
From: Martin Engelschalk [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2008 8:15 AM
To: General Discussion of SQLite Database
Subject:
I think the source code for SQLite with TCL for version 3.6.6.2 is
missing from sqlite.org.
Thanks,
glauber
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
What is the current wisdom about the best JDBC driver to use for SQLite
in Linux?
Thanks,
glauber
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
It uses OS-level file locking.
Read http://sqlite.org/atomiccommit.html
Here's some more: http://sqlite.org/lockingv3.html
Documentation page: http://sqlite.org/docs.html
g
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2008 2:14 PM
It uses OS-level file locking.
Read http://sqlite.org/atomiccommit.html
g
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2008 2:14 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How does sqlite return the status of the data base
Do you mean "First come first serve"?
In that case, I suppose not, since there is no server processed
involved, to mediate access.
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2008 10:44 AM
To: sqlite-users@sqlite.org
Subject: Re:
Yes, this is a little irritating. Back in the time when I used to do C,
I always used strncpy and then stuck a '0' at the end of the new string.
-Original Message-
From: Dave Dyer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2008 12:25 PM
To: Teg; General Discussion of SQLite
You probably want to open your in-file database, open the :memory:
database, and copy all the data from the file to memory, do your
manipulations in memory, then copy back to file when you're done.
http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase has a simple TCL
program to copy a database,
You can probably do it the hard way: create a new table with the
structure you need, then populate it with data from your old table, then
rename both tables.
-Original Message-
From: Dan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 11:53 PM
To: General Discussion of
SQLite needs to guarantee transaction integrity and concurrent accesses
(more than one process could be writing and reading a SQLite database at
the same time). It has to go to greath lengths to ensure that the data
actually gets written to disk instead of staying in memory cache. All
this has
The documentation for sqlite3 on the web site:
http://www.sqlite.org/sqlite.html
Lists a .bail (on|off) command (stop after hitting an error. Default
off)
This doesn't seem to be implemented in the current version. Why? This
seems to be an important feature for creating robust applications.
Is
This issue continues with version 3.6.2
g
-Original Message-
From: Ribeiro, Glauber
Sent: Friday, September 19, 2008 11:55 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Core dumps on AIX with optimization
Just wondering, are there other AIX Sqlite users out
Just wondering, are there other AIX Sqlite users out there, and what
have you done in order to get a successful compile?
I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the
command line utility sqlite2 dumps core when running SQL that contains
an aggregation function, if it was
SQLite is written in C, and its creators seem to be fond of TCL, so
those are 2 good choices, but I don't think there is a most ideal
language for anything - it all depends on balancing what you need to do
and what you want to learn.
And of course, Perl is always best. :)
g
-Original
True, but it seems to me that "Julian dates" (floating-point numbers) in
Universal Time are the least cumbersome way to go if you want a binary
representation, or character strings in one of the supported formats, if
you want a human-readable one.
You can also use Unix timestamps (integers), but
Hello,
Here's another newbie question, but it doesn't look like the
documentation for vacuum covers this.
I'm using SQLite to store an application's log. Suppose I have a program
that runs nightly and deletes log records that are older than 60 days,
to keep the database from growing without
Sorry for the newbie question, but how is the regression testing
invoked?
I tried "make check" with the 3.6.2 "amalgamation" distribution in Unix,
but that seemed to do nothing.
Thanks,
glauber
___
sqlite-users mailing list
sqlite-users@sqlite.org
37 matches
Mail list logo