Thanks for your mail.
Need to check I can use those plugins as part of Qt 5.15 commercial license.
Best Regards,
Ramakanth
On Mon, 14 Feb, 2022, 06:48 Yang Fan, wrote:
> You may search "qt sqlcipher" as the keyword on GitHub, there are some
> projects implementing sqlcipher as a plugin.
>
> On
Hi Frank,
Thanks for your mail. It helps to get started.
Hope the latest version of openssl would do to leverage hardware
accelerated AES on target platform to write our own crypto I/O backed or
use sqlcipher with Qt plugin.
Best Regards,
Ramakanth
On Sun, 13 Feb, 2022, 15:43 Frank Mertens,
You may search "qt sqlcipher" as the keyword on GitHub, there are some
projects implementing sqlcipher as a plugin.
On Sun, Feb 13, 2022 at 6:13 PM Frank Mertens wrote:
> Hi Ramakanth,
>
> I've done that in the past. Sqlite3 has quite easy to override page I/O
> functions and it is not to
Hi Ramakanth,
I've done that in the past. Sqlite3 has quite easy to override page I/O
functions and it is not to difficult to run your own crypto I/O backend. Of
course there is also nowadays SEE... I doubt Qt has anything to offer here, but
there is a configure switch to select to system's
Hi,
The embedded database being used is sqlite3 in our Qt Quick application
based out of Qt commercial Qt 5.15.8
As we intend to use encryption for the sqlite3 database, appreciate if
anyone could let me know if there is any inbuilt support to use sqlite
cipher in Qt SQL module or need to
Sorry, I was wrong. It is an issue of our app.
On 1/24/2022 11:40 AM, Alexander Dyagilev wrote:
Hello,
Let's suppose we have a database file of 16GB in size.
We open it using this code:
m_db = QSqlDatabase::addDatabase(
"QSQLITE",
dbConnectionName());
On Monday, 24 January 2022 02:41:38 PST Alexander Dyagilev wrote:
> Sorry, I don't really know (and I do not even care). But this is what
> Windows Task Manager shows to our users, and they are concerned about this.
Easy way to answer this: try to open a database that is bigger than the
virtual
On 1/24/2022 12:39 PM, Hamish Moffatt via Interest wrote:
Did you mean to misspell journal_mode?
LOL. OK, fine... ROFL... No, of course no...
Are you sure it's real memory usage and not just address space used by
mmap?
Sorry, I don't really know (and I do not even care). But this is what
On Mon, Jan 24, 2022 at 11:40 AM Hamish Moffatt via Interest
wrote:
>
> On 24/1/22 19:40, Alexander Dyagilev wrote:
> > Hello,
> >
> > Let's suppose we have a database file of 16GB in size.
> >
> > We open it using this code:
> >
> > m_db = QSqlDatabase::addDatabase(
> > "QSQLITE",
>
On 24/1/22 19:40, Alexander Dyagilev wrote:
Hello,
Let's suppose we have a database file of 16GB in size.
We open it using this code:
m_db = QSqlDatabase::addDatabase(
"QSQLITE",
dbConnectionName());
m_db.setConnectOptions("PRAGMA jounal_mode=WAL;");
Hello,
Let's suppose we have a database file of 16GB in size.
We open it using this code:
m_db = QSqlDatabase::addDatabase(
"QSQLITE",
dbConnectionName());
m_db.setConnectOptions("PRAGMA jounal_mode=WAL;");
m_db.setDatabaseName(m_dbPath);
m_db.open();
After this, our
On Saturday, 16 January 2021 02:33:09 PST Alexander Dyagilev wrote:
> Actually, the code is this:
You may want to look at the overhead you're creating...
So, you create 128 bits (16 bytes) of data of UUID, but then you save into
your database a QDataStream payload containing a QString encoding
Hello,
I don't believe such bug can exist and no one has noticed it yet :)
Anyway, thanks for your suggestion. I've checked it - works fine.
Actually, the code is this:
QString uuid=QUuid::createUuid().toString(QUuid::WithoutBraces);
QVariant v(uuid);
QByteArray UuidByteArray =
On Thursday, 14 January 2021 22:31:19 PST Alexander Dyagilev wrote:
> BLOB, so any arbitrary data is allowed. Thus the reason is not that the
> first byte is 0.
But it might be that the binding is buggy and is not passing the full 16
bytes.
You can easily confirm or deny this by trying to
Hello,
BLOB, so any arbitrary data is allowed. Thus the reason is not that the
first byte is 0.
On 1/15/2021 2:55 AM, Tony Rietwyk wrote:
Hi,
I haven't used SQLite, but I'm wondering if when the UuidByteArray
starts with a zero byte, then maybe nothing gets written for the
value? 1 in
Hello,
It's BLOB there, not TEXT.
On 1/15/2021 3:42 AM, Thiago Macieira wrote:
On Thursday, 14 January 2021 15:55:35 PST Tony Rietwyk wrote:
Is a BLOB field binary or text? Does a binary blob with embedded zeroes
always get fully written? Maybe using base64 encoding would work better?
The
On Thursday, 14 January 2021 15:55:35 PST Tony Rietwyk wrote:
> Is a BLOB field binary or text? Does a binary blob with embedded zeroes
> always get fully written? Maybe using base64 encoding would work better?
The table schema description said "TEXT", so one expects the UUID is in its
text
Hi,
I haven't used SQLite, but I'm wondering if when the UuidByteArray
starts with a zero byte, then maybe nothing gets written for the value?
1 in 16 of the generated UUID's could have this, which roughly matches
your 4% failures.
Is a BLOB field binary or text? Does a binary blob with
, often
return "no connection" or "unable to fetch" for a multitude of issues
Scott
-Original Message-
From: Alexander Dyagilev [mailto:alervd...@gmail.com]
Sent: Thursday, January 14, 2021 08:41
To: Scott Bloom ; interest@qt-project.org
Subject: Re: [Interest
On 1/14/2021 7:41 PM, Alexander Dyagilev wrote:
On 1/14/2021 7:06 PM, Scott Bloom wrote:
Did the prepare fail?
No. But why should it fail?
Oops. I meant we does not check this.
___
Interest mailing list
Interest@qt-project.org
Scott
-Original Message-
From: Interest [mailto:interest-boun...@qt-project.org] On Behalf Of Alexander
Dyagilev
Sent: Thursday, January 14, 2021 07:19
To: interest@qt-project.org
Subject: [Interest] SQLite: mystic bug: No query Unable to fetch row error
Hello,
Each instance of our app is suppos
rg
Subject: [Interest] SQLite: mystic bug: No query Unable to fetch row error
Hello,
Each instance of our app is supposed to have an unique id (UUID).
At every start, it check if it has assigned one, and if not - generates it and
saves it to the SQLite database.
We've found, that 4% of ours
Hello,
It seems that it's impossible to use SQLite Online Backup API via Qt API.
So I have created a ticker here:
https://bugreports.qt.io/browse/QTBUG-81564
Are there any workarounds to backup database to some file on disk?
The only way I see now is to use mutex and aquire it before doing
That is more or less the same mechanism I have been using to accomplish this.
But I only used one updater object, and a list of update scripts. The name of
the scripts was marked with the version of the database schema, like
update_v3.sql.
At startup the version of the current scheme is read
Hello,
On 05/28/15 21:31, Jason H wrote:
I once wrote a ORM that took an XML definition, and spat out QObject-derived
classes that provided QObject QPROPERTY to SQLite database mappings. So it
would create the SQL schema, the source files (.cpp/h) had support for
transactions and
...@avalonsciences.com
To: Bo Thorsen b...@vikingsoft.eu, interest@qt-project.org
interest@qt-project.org
Subject: Re: [Interest] SQLite
Hi Bo
It would be really interesting to see your sources and I would be grateful if
you could email them to me
Thanks
Graham
-Original Message-
From: Bo
Hi Bo
It would be really interesting to see your sources and I would be grateful if
you could email them to me
Thanks
Graham
-Original Message-
From: Bo Thorsen [mailto:b...@vikingsoft.eu]
Sent: 27 May 2015 21:56
To: interest@qt-project.org; Graham Labdon
Subject: Re: [Interest
m...@rpzdesign.com schreef op 28-5-2015 om 00:25:
Qt5 + SQLITE + QJsonDocument == Degrees of freedom
Could you go into this a little deeper? What do you mean by this
exactly? How do you use QJsonDocument in combination with SQLite to
obtain your Degrees of freedom? Does it still allow you to
m...@rpzdesign.com schreef op 28-5-2015 om 14:33:
Simple, Store json documents in a Text Field.
Study all the NOSQL implementations (Mongo,Couchbase,etc) and then
connect the dots between SQLITE and NOSQL.
Avoid SCHEMA or reduce to SCHEMA to minimal levels where you do not
need Versions and
Thanks
-Original Message-
From: interest-bounces+graham.labdon=avalonsciences@qt-project.org
[mailto:interest-bounces+graham.labdon=avalonsciences@qt-project.org] On
Behalf Of André Somers
Sent: 27 May 2015 09:52
To: interest@qt-project.org
Subject: Re: [Interest] SQLite
Graham
Graham Labdon schreef op 27-5-2015 om 09:39:
Hi
I am planning to use a SQLite database in my application to store application
data.
The application is large and complex so we are taking a phased delivery
approach. This will mean that the structure of the database will change over
time and
with postgres, I use a utility called
appgdiff http://apgdiff.com/ It might work for SQLite, but it only does
schemas.
Sent: Wednesday, May 27, 2015 at 3:39 AM
From: Graham Labdon graham.lab...@avalonsciences.com
To: Interest@qt-project.org Interest@qt-project.org
Subject: [Interest] SQLite
Hi
I
Den 27-05-2015 kl. 10:51 skrev André Somers:
Graham Labdon schreef op 27-5-2015 om 09:39:
Hi
I am planning to use a SQLite database in my application to store
application data.
The application is large and complex so we are taking a phased delivery
approach. This will mean that the
On 2015/05/27 09:39 AM, Graham Labdon wrote:
I am planning to use a SQLite database in my application to store application
data.
The application is large and complex so we are taking a phased delivery
approach. This will mean that the structure of the database will change over
time and
Qt5 + SQLITE + QJsonDocument == Degrees of freedom
On 5/27/2015 3:18 PM, Alex Strickland wrote:
On 2015/05/27 09:39 AM, Graham Labdon wrote:
I am planning to use a SQLite database in my application to store
application data.
The application is large and complex so we are taking a phased
Hi
I am planning to use a SQLite database in my application to store application
data.
The application is large and complex so we are taking a phased delivery
approach. This will mean that the structure of the database will change over
time and that we need to provide backwards compatibility.
On 2015/05/27 09:39 AM, Graham Labdon wrote:
I am planning to use a SQLite database in my application to store application
data.
The application is large and complex so we are taking a phased delivery
approach. This will mean that the structure of the database will change over
time and
Sent: Friday, April 17, 2015 at 7:24 PM
From: Thiago Macieira thiago.macie...@intel.com
To: interest@qt-project.org
Subject: Re: [Interest] sqlite
On Friday 17 April 2015 21:57:44 Jason H wrote:
I've used SQLite as a table store pretty extensively and I can say:
1. It works
-project.org
Subject: [Interest] sqlite
Hi
My application makes use of an sqlite database that needs to be shared amongst
multiple instantiations of the application.
Can anyone please suggest how I can implement this such that if one
instantiation of the application updates the database then any
Hi
My application makes use of an sqlite database that needs to be shared amongst
multiple instantiations of the application.
Can anyone please suggest how I can implement this such that if one
instantiation of the application updates the database then any other
instantiations that are running
Bo Thorsen schreef op 17-4-2015 om 13:48:
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared
amongst
multiple instantiations of the application.
Can anyone please suggest how I can implement this such that if one
Bo Thorsen schreef op 17-4-2015 om 14:24:
On 04/17/2015 02:10 PM, André Somers wrote:
Bo Thorsen schreef op 17-4-2015 om 13:48:
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared
amongst
multiple instantiations of the
@qt-project.org
Subject: Re: [Interest] sqlite
Bo Thorsen schreef op 17-4-2015 om 13:48:
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared amongst
multiple instantiations of the application.
Can anyone please suggest how I can
On 04/17/2015 02:36 PM, André Somers wrote:
Bo Thorsen schreef op 17-4-2015 om 14:24:
On 04/17/2015 02:10 PM, André Somers wrote:
Bo Thorsen schreef op 17-4-2015 om 13:48:
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared amongst
multiple instantiations of the application.
Can anyone please suggest how I can implement this such that if one
instantiation of the application updates the database
On 04/17/2015 02:10 PM, André Somers wrote:
Bo Thorsen schreef op 17-4-2015 om 13:48:
On 04/17/2015 10:25 AM, Graham Labdon wrote:
Hi
My application makes use of an sqlite database that needs to be shared
amongst
multiple instantiations of the application.
Can anyone please suggest how I
I've used SQLite as a table store pretty extensively and I can say:
1. It works as advertised. It allows multiple processes to access the same
database safely. Threads no. Processes yes.
2. Multiple process performance is low. It may me adequate if there is not a
lot of concurrency, just a lot
On Friday 17 April 2015 21:57:44 Jason H wrote:
I've used SQLite as a table store pretty extensively and I can say:
1. It works as advertised. It allows multiple processes to access the same
database safely. Threads no. Processes yes.
2. Multiple process performance
is low. It may me
El Friday 17 April 2015, Bo Thorsen escribió:
In practice, we found that it results in problems in practise, even if
it may work in theory. Perhaps it is due to the actual sqlite, perhaps
it is due to the fact that it really is just a file and it is the
(networked) file access that is to
I'm trying to run SQLite application on Windows Mobile. It seems that
Device emulator can't find the driver plugin. Here is the error message:
'Driver not loaded'. I tested with Qt 5.3.1. How to solve this problem?
Regards, Niko H.
___
Interest mailing
Hi,
Niko H wrote:
I'm trying to run SQLite application on Windows Mobile. It seems that
Device emulator can't find the driver plugin. Here is the error message:
'Driver not loaded'. I tested with Qt 5.3.1. How to solve this problem?
sqlite was not built for Windows Phone in Qt 5.3, but this
51 matches
Mail list logo
