SQLite Forum

Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER.
Login
Chronological Hierarchical 
That is almost the same.  The exception being that the `real primary key` must be provided everytime and is not actually the `rowid`, so you cannot leave it null.