Skip to content

Mathieu Rodic

Full stack developer & Data scientist

  • Portfolio
  • Skills
  • Blog
  • Services
  • Contact

Database

Automatic migrations in SQLAlchemy with Alembic

2015-01-302015-01-30 by Mathieu Rodic

Background While using ORMs in Python offers a great deal of flexibility in many respects, one of the biggest drawbacks is database maintenance. What happens if you just alter the models in your code? If you do so, you will have to either: manually alter/drop/create the tables in your database – can seriously decrease maintainability, … Read more

Categories Database, Python, SQLAlchemy1 Comment

Use SQLAlchemy with Django

2014-12-202015-03-12 by Mathieu Rodic
chemistry-glassware

Why wouldn’t we use Django ORM? Using Django ORM is not suited for real database operations. Sure, it might look okay(ish) when you are only performing basic CRUD operations. But it will force you to perform database queries in the least optimized way (see N+1 SELECT issue)… Its syntax is inconsistent, and its lack of … Read more

Categories Database, ORM, Programming, Python8 Comments

Make a chatbot with Python and SQLite

2014-10-032017-02-13 by Mathieu Rodic
robot-phone

What is a chatbot? A chatbot, or chatterbot, is a computer program aiming at simulating a written conversation with a human user. Why making one? Well, first… because it’s fun! Since Alan Turing, chatbot programming has been a way to test computer’s ability to pretend like they are human (see Turing test). Also, chatbots can … Read more

Categories AI, Database, Programming, Python, SQLite42 Comments

Archives

  • January 2017
  • November 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • August 2012
  • April 2011

Pages

  • Blog
  • Portfolio
  • Skills
  • Services
  • Contact

Categories

  • AI
  • Apache2
  • C
  • Cryptography
  • Database
  • GIS
  • Graph
  • online tool
  • ORM
  • PHP
  • Programming
  • Python
  • Regexp
  • Sound
  • SQLAlchemy
  • SQLite

Recent Posts

  • Libavcodec tutorial: decode virtually any audio file in C/C++
  • Online conversion between geometric formats
  • Conversion between “CamelCase” and “snake_case” strings with Python
  • Automatic migrations in SQLAlchemy with Alembic
  • Use SQLAlchemy with Django
  • Weighted graphs: generate a layout in C++
  • Make a chatbot with Python and SQLite
  • Shortest encryption program in pure C
Copyright © 2023 · GeneratePress