Comments (3)
What's the benefit of gcm?
from beekeeper-studio.
This is not a big deal but it appears that GCM was not easily supported when a key reference was first used but I think it is now and even that reference has been updated. (see https://lollyrock.com/posts/nodejs-encryption/)
There are several reasons I brought it up:
- GCM is authenticated encryption, CTR is not
- In theory GCM should be faster because it can parallelize (it builds on CTR which can do this, but if I understand you have to have to do this yourself) and there are hardware optimizations. (This may not be relevant if you're only encrypting a very small unit of data)
I would also note that both of these algorithms use an initialization vector (IV) that should be random, as you can see in the SubleCrypto examples: https://developer.mozilla.org/en-US/docs/Web/API/SubtleCrypto/encrypt.
This documentation from the node.js crypto package suggests that the method you are using without the IV is deprecated: https://nodejs.org/api/crypto.html#crypto_crypto_createcipher_algorithm_password_options
I hope this helps...
See:
https://en.wikipedia.org/wiki/Authenticated_encryption
https://www.quora.com/What-is-the-difference-between-Galois-Counter-Mode-and-Counter-Mode-AES
https://stackoverflow.com/questions/1220751/how-to-choose-an-aes-encryption-mode-cbc-ecb-ctr-ocb-cfb
https://crypto.stackexchange.com/questions/62029/does-an-iv-need-to-be-used-in-aes-ctr-mode
https://developer.mozilla.org/en-US/docs/Web/API/SubtleCrypto/encrypt
https://web.cs.ucdavis.edu/~rogaway/papers/modes.pdf
from beekeeper-studio.
Thanks for all the detail!
The encryption right now is only for data that lives on a user's local machine. Many similar apps don't even bother encrypting stuff that is stored locally, even sensitive information, so I feel ok about our current solution.
I'm going to close this issue, but have bookmarked it for if we ever do some sort of remote syncing feature (when data encryption becomes an important part of the solution)
from beekeeper-studio.
Related Issues (20)
- BUG: Column context menu broken in ResultTable in ultimate
- 为什么中文汉化不全 HOT 1
- Let users create and rename workspaces directly in the app
- CHORE: Tabulator 6.2 upgrade HOT 1
- FEAT: columns loading indicator HOT 1
- CHORE: Generalize LanguageData#resolveLanguage so we don't have to add a line when we add a new driver
- CSV Import Fails with Too few fields HOT 1
- FEAT: Table renaming on right-click menu
- BUG: PSQL 15+ indexes don't display when NULLS NOT DISTINCT” option was turned on
- BUG: Beekeeper doesn't properly show prefix indexes for TEXT / BLOB HOT 1
- wrong record count HOT 2
- FEAT: Find and replace within the current table view HOT 6
- BUG: Unexpected token g in JSON at position 0 HOT 2
- BUG: TableTable does not maintain sort order when reconnecting to a connection
- FEAT: Starting to type on a table cell doesn't actually start typing in the cell
- FEAT: When inserting a new row, show the default value as placeholder for the cell
- FEAT: Super Query Formatter 🚀🚀
- FEAT: Seed new installs with a demo database (SQLite) with built-in pre-populated data and app tabs
- BUG: Resizing Beekeeper doesn't appropriately resize CodeMirror
- BUG: blank screen after inputting data via UI in mysql connection HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from beekeeper-studio.