title: Shall I bother with storing DateTime data as julianday in SQLite?
body: <p>SQLite docs specifies that the preferred format for storing datetime values in the DB is to use Julian Day (using built-in functions).</p>
  
  <p>However, all frameworks I saw in python (pysqlite, SQLAlchemy) store the <code>datetime.datetime</code> values as ISO formatted strings. Why are they doing so?</p>
  
  <p>I'm usually trying to adapt the frameworks to storing datetime as julianday, and it's quite painful. I started to doubt that is worth the efforts.</p>
  
  <p>Please share your experience in this field with me. Does sticking with julianday make sense?</p>