On Thu, Jul 9, 2020, at 4:53 AM, Justvuur wrote: > 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?
TypeDecorator is pretty universal so it should work for any modern version in the past five years at least > So with this, I would be able to query/filter an encrypted column and it will > automatically perform the decryption to test the column? should work, sure, try it out > > > 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 > > <https://groups.google.com/d/msgid/sqlalchemy/1164ebf3-4ee3-4434-a21c-fe12ce57f556n%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/0b4b7fa0-0cfb-466c-be0f-8f48d6a56eef%40www.fastmail.com.