Re: [sqlite] sql statement to update the data in the table

On 20 Oct 2011, at 1:49am, Joanne Pham wrote: > it seems like it didn't work. > For example the password is 'password'. I ran the update statement below and > do the AES_DECRYPT the password is null instead of 'password'. Try just SELECT AES_ENCRYPT(password, 'abcddsfddafdasfddasd');

Re: [sqlite] sql statement to update the data in the table

On 10/19/2011 8:49 PM, Joanne Pham wrote: Yes, That is what i want but it seems like it didn't work. For example the password is 'password'. I ran the update statement below and do the AES_DECRYPT the password is null instead of 'password'. Any idea? You'll have to raise the issue with the

Re: [sqlite] sql statement to update the data in the table

Thanks, Yes, That is what i want but it seems like it didn't work. For example the password is 'password'. I ran the update statement below and do the AES_DECRYPT the password is null instead of 'password'. Any idea? JP From: Igor Tandetnik

Re: [sqlite] sql statement to update the data in the table

On 10/19/2011 7:23 PM, Joanne Pham wrote: update vpn set password = AES_ENCRYPT((select password from vpn) , "abcddsfddafdasfddasd"). I suspect you want update vpn set password = AES_ENCRYPT(password, 'abcddsfddafdasfddasd'); -- Igor Tandetnik

Re: [sqlite] sql statement to update the data in the table

Hi Igor,   update vpn set password = AES_ENCRYPT((select password from vpn) , "abcddsfddafdasfddasd"). Basically, I want to encrypt the password in vpn table so the passwords in this table are different. Above mysql statement still didn't work. Any idea. Thanks, JP

Re: [sqlite] sql statement to update the data in the table

On 10/19/2011 6:34 PM, Joanne Pham wrote: Curently I had the table with the plain text and I want to encrypt these passwords by using the following sql statement but I got the error mesages.. Any suggestion? update vpn set password = AES_ENCRYPT(select password from mytable,

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On 19 Oct 2011, at 11:20pm, Nico Williams wrote: > On Wed, Oct 19, 2011 at 4:16 PM, Jay A. Kreibich wrote: >> Just because the standards include such features, you seem to be >> under the impression that every client and every server running on >> top of any filesystem

[sqlite] sql statement to update the data in the table

Hi all, Curently I had the table with the plain text and I want to  encrypt these passwords by using the following sql statement but I got the error mesages. Any suggestion? update vpn set password = AES_ENCRYPT(select password from mytable, "abcddsfddafdasfddasd"). Thanks in advance, JP

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 4:16 PM, Jay A. Kreibich wrote: > On Wed, Oct 19, 2011 at 03:24:35PM -0500, Nico Williams scratched on the wall: >> Also, regarding NFS, it would be safe to use if SQLite3 were to use >> whole-file byte range locks.  NFS makes concurrent access to byte >>

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19/10/11 13:24, Nico Williams wrote: > That explains why concurrent access over NFS or CIFS is dangerous. It > doesn't explain that it's not possible to use SQLite3 over NFS or > CIFS. The simple answer is that they don't provide *exactly* the

Re: [sqlite] Database full error?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19/10/11 14:03, PA Newsgroups wrote: > Is there anything else that could cause this error? It's on a Windows > computer if that makes any difference. SQLite code has a tendency to report virtually any error involving write calls as the disk

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 03:24:35PM -0500, Nico Williams scratched on the wall: > On Wed, Oct 19, 2011 at 2:23 PM, Jay A. Kreibich wrote: > > On Wed, Oct 19, 2011 at 02:13:35PM -0500, Nico Williams scratched on the > > wall: > >> On Wed, Oct 19, 2011 at 4:00 AM, Stephan Beal

[sqlite] Database full error?

I have a customer with a database whose file size is about 39GB. He's getting error 13 (database or disk is full) on an insert. My app sets the page size to 4096, but even if it was the default, this error shouldn't happen until it's around 4TB in size based on what I read the default

Re: [sqlite] FTS vs INDEX

2011/10/19 Fabian : > I always do inserts in batches of 100.000 rows, and after each batch I > manually merge the b-trees using: > >  INSERT INTO table(table) VALUES('optimize'); > > Is there a possibility that it will do automatic maintenance half-way during > a batch? Or

Re: [sqlite] FTS vs INDEX

On Wed, Oct 19, 2011 at 12:50 PM, Fabian wrote: > 2011/10/19 Scott Hess >> To be clear, how it works is that new insertions are batched into a >> new index tree, with index trees periodically aggregated to keep >> selection efficient and to keep the size

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 2:23 PM, Jay A. Kreibich wrote: > On Wed, Oct 19, 2011 at 02:13:35PM -0500, Nico Williams scratched on the wall: >> On Wed, Oct 19, 2011 at 4:00 AM, Stephan Beal wrote: >> > On Tue, Oct 18, 2011 at 12:37 PM, Sune Ahlgren >> >

[sqlite] FTS: Reduce tokens

Using the default tokenizer, everything that is not an alphanumeric character or an underscore, will generate a new token. I have a lot of columns that contains e-mail addresses or URL's, and most of them have characters like '.', '@' and '/'. Is there a simple way to make FTS see them as one

Re: [sqlite] FTS vs INDEX

2011/10/19 Scott Hess > > To be clear, how it works is that new insertions are batched into a > new index tree, with index trees periodically aggregated to keep > selection efficient and to keep the size contained. So while the > speed per insert should remain pretty stable

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 9:40 PM, Simon Slavin wrote: > Think is, it's possible to do it right. It's just that doing it right > means every operation takes two or three times as long as the slightly buggy > implementations we have now. And people prefer fast-but-buggy. >

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On 19 Oct 2011, at 8:26pm, Stephan Beal wrote: > On Wed, Oct 19, 2011 at 9:23 PM, Stephan Beal wrote: > >> race conditions, unclean network connection errors, blah blah blah. That >> goes for all applications, not just databases. > > And not just for CIFS, but NFS and

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 9:23 PM, Stephan Beal wrote: > race conditions, unclean network connection errors, blah blah blah. That > goes for all applications, not just databases. > > And not just for CIFS, but NFS and other networked filesystems as well. i'm not personally

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 9:13 PM, Nico Williams wrote: > > Nothing. Even MS Access cannot (or could not way back when i used it) be > > safely used on SMB/CIFS storage. > > Can you elaborate as to why? > > i unfortunately can't, except to say that file locking on networked

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 02:13:35PM -0500, Nico Williams scratched on the wall: > On Wed, Oct 19, 2011 at 4:00 AM, Stephan Beal wrote: > > On Tue, Oct 18, 2011 at 12:37 PM, Sune Ahlgren > > wrote: > >> What can I do to make SQLite run safely on

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Wed, Oct 19, 2011 at 4:00 AM, Stephan Beal wrote: > On Tue, Oct 18, 2011 at 12:37 PM, Sune Ahlgren > wrote: >> What can I do to make SQLite run safely on CIFS? > > Nothing. Even MS Access cannot (or could not way back when i used it) be >

Re: [sqlite] FTS vs INDEX

On Wed, Oct 19, 2011 at 7:56 AM, Fabian wrote: > 2011/10/19 Alexey Pechnikov >> FTS use index multi-tree and de-facto has _no_ insert speed degradation. > > Thanks, that's good to hear! It makes me wonder why SQLite doesn't use that > same

Re: [sqlite] FTS vs INDEX

Nope -- didn't note the insert speed on that test. Why don't you take my benchmark data and test it yourself? Then post the results. The saying "your mileage may vary" comes to mind... Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions

Re: [sqlite] FTS vs INDEX

2011/10/19 Fabian : > Thanks, that's good to hear! It makes me wonder why SQLite doesn't use that > same multi-tree mechanism for regular indexes, but that's a whole different > question. It's impossible with SQLite3 database format. May be SQLite4 will be support it :) --

Re: [sqlite] FTS vs INDEX

2011/10/19 Alexey Pechnikov > FTS use index multi-tree and de-facto has _no_ insert speed degradation. > Thanks, that's good to hear! It makes me wonder why SQLite doesn't use that same multi-tree mechanism for regular indexes, but that's a whole different question.

Re: [sqlite] FTS vs INDEX

FTS use index multi-tree and de-facto has _no_ insert speed degradation. I did do test for 400+ millions of records. With b-tree index there is insert speed degradation: http://geomapx.blogspot.com/2010/04/sqlite-index-degradation-tests.html http://geomapx.blogspot.com/search?q=index+speed So FTS

Re: [sqlite] FTS vs INDEX

Very interesting benchmarks! However it seems to focus mainly on the speed of SELECT queries, and the total size of the resulting database on disk. But my main concern is about the speed of INSERT queries vs normal tables. Any chance you compared that too? 2011/10/19 Black, Michael (IS)

Re: [sqlite] FTS vs INDEX

I recently benchmarked this...FTS4 has a prefix option that can make it slightly faster than TEXT. Other than that it's about the same speed. http://www.mail-archive.com/sqlite-users@sqlite.org/msg64591.html The older part of the thread has the benchmark data Michael D. Black Senior

[sqlite] FTS vs INDEX

Did anyone do some benchmarks how the insert-speed of FTS compares to a TEXT INDEX column? I don't need many of the extra features of FTS, because I always need to look up rows by prefix or exact match, and both can be implemented efficiently via TEXT INDEX too. But if the overhead is comparable,

[sqlite] Problems with nested Joins

Hello I'm currently evaluating SQLite for replacing a Microsoft Access (Jet) Database in one of our projects. We use a data layer abstraction which allows us to quickly implement other database. Therefore we allow the user of the data acces layer to make arbitrary nested joins. Currently I

Re: [sqlite] Bug in using overloaded functions for virtual tables?

Stepping through execution for queries with and without GROUP BY clauses, I could see that, when preparing a query containing a Group By clause, the parser assigns a TK_AGG_COLUMN type to first argument of the offsets() and snippet() functions, thus breaking out of sqlite3VtabOverloadFunction()

Re: [sqlite] SQLite

On 7 Oct 2011, at 4:10pm, Arbol One wrote: > Looking at the choices given at http://www.sqlite.org/download.html, I would > like to know what would be the best way to add SQLite to my app. > > I am using Windows 7-64bit as the OS and Code::Blocks with MinGW/GNU C++. Download the amalgamation

Re: [sqlite] Where is my posting?

In-fact there is at-least one more post from you (other than this one), regarding the best way to add sqlite to your app (Sorry I am not sure of the answer). I think that confirms that your mails are being received.. Regards Taleeb Anawr *Ghurbat men Hon Agar Hum, Rehta Hai Dil "Chicken" men!!*

Re: [sqlite] Where is my posting?

OH! nice! thanks Taleeb, now I know it is working. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Taleeb Anwar Sent: Wednesday, October 19, 2011 7:30 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Where is

Re: [sqlite] Where is my posting?

Now that is a difficult question (in fact one of the most difficult questions of all) -- why nobody replies to your posts. Well, I don't know the answer - but am replying - to confirm that your posts are being received by others. And for the questions you didn't get any answer -- try rephrasing

Re: [sqlite] Where is my posting?

Hello AO> How can I know if my email actually is being considered by other AO> members of the list or if it was never posted? Somehow this one made it through. Swithun. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Where is my posting?

Hey boys and girls! Anyone knows why is it that I cannot see my own postings, worst yet! Nobody replies to my postings?! How can I know if my email actually is being considered by other members of the list or if it was never posted? TIA ___

Re: [sqlite] Trouble about ordering records by name (or any varchar column)

In my SQLite 3 Database, I have some records with Turkish characters such as "í", "Ü", "İ" etc. When I select my values with SELECT * FROM TABLE ORDER BY COLUMN_NAME query, the records that begin with these characters are coming at the end. Bare bone SQLite only collates correctly on

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

On Tue, Oct 18, 2011 at 12:37 PM, Sune Ahlgren wrote: > What can I do to make SQLite run safely on CIFS? > Nothing. Even MS Access cannot (or could not way back when i used it) be safely used on SMB/CIFS storage. -- - stephan beal

Re: [sqlite] How to make SQLite run safely on CIFS mounted file system?

2011/10/18 Sune Ahlgren : > What can I do to make SQLite run safely on CIFS? > /Sune Do not use SQLite on shared device. Use client/server database or client/server front-end of SQLite. -- Kit ___ sqlite-users mailing list

[sqlite] Trouble about ordering records by name (or any varchar column)

Hi all, I'm having some trouble about ordering records by name (or any varchar column). I first asked for help at StackOverFlow(I wasn't aware of this list) then had to dig out more. In my SQLite 3 Database, I have some records with Turkish characters such as "Ö", "Ü", "İ" etc. When I select

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Frank Missel wrote: I think that the sqlite-users e-mail list has enough traffic to warrant a proper forum. The only alternative forum I would accept is one with integrated email functionality so that all posts to the forum also generate emails with copies of the posts to people who want