[sqlite] SqliteDog released

2013-10-23 Thread Sqlite Dog
Hi, we are happy to announce a final release of SqliteDog: a modern SQLite database manager. http://sqlitedog.com -- Regards, SqliteDog support team ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SqliteDog released

2013-10-23 Thread Sqlite Dog
mmar errors in the website text. I > suggest you may want to have a native English speaker proof it. > > > On Wed, Oct 23, 2013 at 12:21 PM, Sqlite Dog <sqlite...@gmail.com> wrote: > > > Hi, > > > > we are happy to announce a final release of SqliteD

Re: [sqlite] How to fix sqlite issue

2013-11-12 Thread Sqlite Dog
Hi, perhaps, this can help: 1) download zip with latest SQLite DLL from http://sqlite.org/download.html; 2) unzip it to c:\temp; 3) copy c:\temp\sqlite3.dll to Windows\System32 folder; 4) if there is already sqlite3.dll in Windows\System32 and it's locked, overwrite it with InUse.exe

[sqlite] Is there available sample "featured" SQLite database file?

2013-06-28 Thread Sqlite Dog
Hi, we are developing (yet another :) SQLite manager. I'm wondering is there available sample "feature-tight" "limit-striking" SQLite database (or SQL script) for GUI manager testing purposes? Like: - identifier names contains spaces, UNICODE chars, are surrounded by [], by "" or not

Re: [sqlite] Is there available sample "featured" SQLite database file?

2013-06-28 Thread Sqlite Dog
> Here is your starter schema (and perfectly valid): > create table ""("" ""); Thanks for this snippet! Actually found a bug :) > For performance testing this could be helpful with the --dump-sql arg: > https://code.google.com/p/apsw/source/browse/tools/speedtest.py Well, performance is

[sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
Hi, documentation on SEE (http://www.hwaci.com/sw/sqlite/see.html) states that "You can ship as many compiled, binary copies of SQLite with your commercial product as long as each copy is attached to your product in such a way that it cannot be separated from your product. Normally this means

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
That's interesting. What about pas file with function declarations to SQLite API? Should it be modified somehow? 2013/7/19 kyan <alfasud...@gmail.com> > On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog <sqlite...@gmail.com> wrote: > > > > > Our database manager is

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
2013/7/19 Richard Hipp <d...@sqlite.org> > On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog <sqlite...@gmail.com> wrote: > > > > > Our database manager is developed using Delphi (Pascal). Thus it is not > > possible to statically link SQLite library, SQLite.dll

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
2013/7/19 Ralf Junker <ralfjun...@gmx.de> > On 19.07.2013 09:21, Sqlite Dog wrote: > > > Our database manager is developed using Delphi (Pascal). Thus it is > > not possible to statically link SQLite library, SQLite.dll is used. > > Is there some other way to suppo

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
encryptions have ratings way above military > specification when using proper keys etc. If it is the latter case, you > can't open Databases of which you don't know exactly the encryption and > keys... there is no way to do this, else the whole encryption racket would > be rather useless. I guess

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Sqlite Dog
OK. Thank you. 2013/7/19 Richard Hipp <d...@sqlite.org> > On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog <sqlite...@gmail.com> wrote: > > > > > > > There is no way to detect which encryption algorithm is used. Indeed, > > the > > > encryption

[sqlite] How to detect full table scan?

2013-08-13 Thread Sqlite Dog
What is a best way to detect that query does full table scan? Considering this (from http://www.sqlite.org/eqp.html ): "Warning: The data returned by the EXPLAIN QUERY PLAN command is intended for interactive debugging only. It may change dramatically between SQLite releases. Applications should

Re: [sqlite] How to detect full table scan?

2013-08-13 Thread Sqlite Dog
We are using SQLite 3.7.17 2013/8/13 Sqlite Dog <sqlite...@gmail.com> > What is a best way to detect that query does full table scan? Considering > this (from http://www.sqlite.org/eqp.html ): > > "Warning: The data returned by the EXPLAIN QUERY PLAN command is int

[sqlite] Trigger SQL and database schema

2013-10-15 Thread Sqlite Dog
Hi, seems like SQLite is not checking trigger SQL for invalid column names until execution? Is there a way to force this check? The problem: trying to find out which indices, triggers and views depend on particular column. We can recreate table without this column and recompile indices, triggers