Hi Mike, This is awesome! Yes, I like the client side approach, especially the "Use TypeDecorator" method. Is there a specific version of SQLAlchemy I need? So with this, I would be able to query/filter an encrypted column and it will automatically perform the decryption to test the column?
On Wednesday, 8 July 2020 at 16:10:22 UTC+2 Mike Bayer wrote: > I had just created all-new revised encryption examples on the wiki and > apparently I forgot to link them from the index, fixed. > > Here's two examples showing the general idea of how this can be done: > > https://github.com/sqlalchemy/sqlalchemy/wiki/SymmetricEncryptionClientSide > > https://github.com/sqlalchemy/sqlalchemy/wiki/SymmetricEncryptionServerSide > > the "client side" version is more general purpose and you can use any > encryption system you'd like. > > > > On Wed, Jul 8, 2020, at 6:55 AM, Justvuur wrote: > > Hi All, > > In one or two database tables I need to encrypt/decrypt a couple of > columns. These tables/columns already exist in the DB and they already have > data in them. > > What is the best way using SQL Alchemy to add encryption to these > tables/columns? > It needs to be efficient and the columns need to be able to work with > querying/filtering. > > Regards, > Justin > > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/583d5772-50e4-484a-93e2-fcab29532116n%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/583d5772-50e4-484a-93e2-fcab29532116n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/1164ebf3-4ee3-4434-a21c-fe12ce57f556n%40googlegroups.com.
