On 7/1/20 10:12 PM, Mike Bayer wrote:
>
> I think you might be reading that phrase (not sure where you read it)
> too literally. per https://www.sqlite.org/lang_createtable.html#rowid
>
> > With one exception noted below, if a rowid table has a primary key
> that consists of a single column and
On Wed, Jul 1, 2020, at 9:52 PM, Richard Damon wrote:
> I am using SQLAlchemy ORM with a SQLite database, and many of my tables
> will have a simple integer primary key, with lots of foreign keys
> referencing them. It should improve efficiency if that integer primary
> key was the alias for the
I am using SQLAlchemy ORM with a SQLite database, and many of my tables
will have a simple integer primary key, with lots of foreign keys
referencing them. It should improve efficiency if that integer primary
key was the alias for the ROWID that you get by defining the column as
INTEGER PRIMARY