Andreas:
Some time ago, in response to a similar question, Günter Greschenz sent to
this forum a email:
hi,
i've written some sqlite-functions to crypt (blowfish) or compress (bzip)
data in sqlite:
e.g.
insert into blubs values (crypt('data','pwd'))
or
select from xyz where
On 11/12/07, Andreas Volz <[EMAIL PROTECTED]> wrote:
> I think about to encrypt the data in my DB. Does sqlite offer a data
> encryption on a lower level? Or should I encrypt my data before putting
> it into the table on a higher level in my application without involving
> sqlite?
Dr. Hipp sells
Am Mon, 12 Nov 2007 23:41:59 + schrieb [EMAIL PROTECTED]:
> Andreas Volz <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I'll tell you my current situation. I implemented a web cache
> > function for images and other data in my application. In the past I
> > saved the data on the hard disk
Hello,
I think about to encrypt the data in my DB. Does sqlite offer a data
encryption on a lower level? Or should I encrypt my data before putting
it into the table on a higher level in my application without involving
sqlite?
regards
Andreas
On 11/12/07, Andreas <[EMAIL PROTECTED]> wrote:
> Am 12.11.2007 um 14:40 schrieb Igor Tandetnik:
> > I wonder - do you have any plans to eventually drop some of these
> > views? Or are you just going to keep creating them, exploding the
> > size of the database schema? In fact, why on earth do
Am 12.11.2007 um 14:40 schrieb Igor Tandetnik:
There is no syntax in SQLite to create a view (or anything else)
with name generated at runtime from field values. A view name is a
plain identifier hardcoded into the statement - it is not evaluated
as an expression.
great, thx for this
Andreas Volz <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'll tell you my current situation. I implemented a web cache function
> for images and other data in my application. In the past I saved the
> data on the hard disk with a special name and had a text file with the
> relation "cache file name
Owen Watson wrote:
I'd like to have a one line batch file:
sqlite3 test 'insert into testable values ('value1','value2')'
but the few variants of this I've tried don't work.
I've seen and understood the batch file that calls another text file
approach but I was wondering if I could avoid this
Nuno Lucas wrote
> Seems like you didn't enable the extension loading mechanism. It
> defaults to disabled for security reasons.
>
> Check the wiki page about the SQLITE_OMIT_LOAD_EXTENSION define:
> * http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
I have been using the precompiled
Ah, that makes sense. Thanks!
>
> Mark,
>
> I was talking about using the sqlite download page at
> http://www.sqlite.org/download.html.
>
> If you right click on a link (like the one for
> sqlite3-3_5_2.zip under
> Precompiled Binaries For Windows) and select "copy the link location"
>
Andreas wrote:
I'm trying to let a Trigger create a View. The first Trigger
('resetSyncMarker') cares for unique-keying in the config-table. The
second Trigger('makeView') shall create a View on insert into the
config-table. The View's name shall be the content of the inserted
shortName-field.
Hi sqlite-users,
i'm working on a web-based workflow involving POW and Server-Side-JS
and sqlite for sure.
I'm trying to let a Trigger create a View. The first Trigger
('resetSyncMarker') cares for unique-keying in the config-table. The
second Trigger('makeView') shall create a View on
12 matches
Mail list logo