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+unsubscr...@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/3540258e-cafa-40ab-b994-9fb1394495da%40www.fastmail.com.