Recent changes to feature-requests

#37 [wxsqlite3] possible to add variant CCM to AES 128

2014-08-24T07:24:56.231000Z

status: open --> closed-rejected

#37 [wxsqlite3] possible to add variant CCM to AES 128

2014-08-24T07:23:47.677000Z

Correct - I know about the SEE project (and others),
and it in fact is the one used by Adobe AIR.

I already suspected that you wanted to work with databases created by a SQLite version with SEE support. This would require to implement a clone of the respective SEE method. Sorry, I'm not going to do that, even if I add additional encryption methods to the wxSQLite3 encryption extension in the future.

The license at this point is too cost prohibitive
to get my project off the ground at the moment

For a commercial project 2000 USD should usually be affordable. However, for a non-profit project it's way too much. And that's why the wxSQLite3 encryption extension exists in the first place.

By default AIR creates a sqlite db with UTF16LE (but will read/write UTF8)

The SQLite library allows to access text in UTF-8 or UTF-16 encoding independent of the actual encoding used for the database. Personally I prefer UTF-8, because it avoids endianess problems.

and if encrypted using AES 128 CCM mode.

Couldn't you create your intended templates in unencrypted mode and let users encrypt them themselves using AIR?

I am fighting two problems here:

1) Few if any tooling for db management uses UTF16 (this is reserved
typically for asian languages) - I have countered this by creating
"standard" UTF8 db's to use as a seeded template.

As far as I understand the SQLite documentation you can't attach databases which use a different encoding than the main database. That is, your templates should probably have the same encoding (UTF-16) as the AIR databases.

2) Is the encryption phase - I could use the db (UTF16, 128CCM) created by
adobe - but then I have no ability to attach mixed mode (defeating the purpose
of pre-setting tables, triggers, etc), and no 3rd party verification phase that
what I coded was actually correct (other than switching back and forth between
un/encrypted).

If AIR allows to attach databases it should be possible to attach an unencrypted UTF-16 database, at least in principle. However, I have to admit that I know nothing about AIR, so I really don't know of a feasible approach you could use.

Regards,

Ulrich

#37 [wxsqlite3] possible to add variant CCM to AES 128

2014-08-23T23:09:31.333000Z

Hi,

Unfortunately I know nothing is ever trivial, but at least thank you for considering it ;)

Correct - I know about the SEE project (and others), and it in fact is the one used by Adobe AIR. The license at this point is too cost prohibitive to get my project off the ground at the moment - to which I only want to create a single seeded template. By default AIR creates a sqlite db with UTF16LE (but will read/write UTF8) and if encrypted using AES 128 CCM mode.

Sadly (but understandable) Adobe doesn't include the sqlite3.dll with the AIR runtime deployment. Otherwise I could use this.

I am fighting two problems here:
1) Few if any tooling for db management uses UTF16 (this is reserved typically for asian languages) - I have countered this by creating "standard" UTF8 db's to use as a seeded template.
2) Is the encryption phase - I could use the db (UTF16, 128CCM) created by adobe - but then I have no ability to attach mixed mode (defeating the purpose of pre-setting tables, triggers, etc), and no 3rd party verification phase that what I coded was actually correct (other than switching back and forth between un/encrypted).

Like I said, thanks for at least considering it. I can completely understand if that is an endeavor you don't want to undertake.
Cheers.

#37 [wxsqlite3] possible to add variant CCM to AES 128

2014-08-22T22:42:52.970000Z

assigned_to: Ulrich Telle

[wxsqlite3] possible to add variant CCM to AES 128

2014-08-22T07:04:48.192000Z

Ticket 37 has been modified: [wxsqlite3] possible to add variant CCM to AES 128
Edited By: Ulrich Telle (utelle)
Owner updated: None => u'utelle'

[wxsqlite3] possible to add variant CCM to AES 128

2014-08-22T07:04:48.192000Z

Ticket 37 has been modified: [wxsqlite3] possible to add variant CCM to AES 128
Edited By: Ulrich Telle (utelle)
Status updated: u'open' => u'closed-rejected'

[wxsqlite3] possible to add variant CCM to AES 128

2014-08-22T07:04:48.192000Z

Hi,

I'm wondering if it's possible to add the CCM variant to AES128 to the wxsqlite3 project. More specifically using the prebuilt sqlite3shell (aes128/lib/release) I am attempting to create an encrypted template to use in another project. But the sqlite engine that it uses will only accept encryption of this type.

Thanks for considering,
Mike

ActiveRecord support wxsqlite3

2012-03-20T10:06:25Z

wxAactiveRecord is pretty cool lib.
As we known, wxAactiveRecord take databaselayer as its backend and will you please task wxSqlite3 as its backend as well?

scrolling for wxtreelistctrl

2011-11-01T19:32:33Z

it may be a good idea to allow automatic scrolling like windows explorer, where dragging an object abovethe top or under the bottom of the visible part of a tree will trigger scrolling as long as the cursor does not come back in the tree window.

it may help, that using scrollto may work. the only small flaw is with this method, the dragged item is initialized in onbeingdrag amd the same variable will be saved over and over as long as its out of the window. the flaw is whenever the cursor enter the window again, onbeingdrag gets called again, thus reinitializing the item again.
This can be seen when trying to drag an item from the top to all the way to the bottom and enter the window and go to the top. whats going to happen is after re etnering the item will jump straight to the top.

Thank you

wxTreeListCtrl reparent an item

2011-10-28T15:56:41Z

It may be a good idea to allow an item with childen and with parent, to be re assigned to a different parent with its children.