[azlev]

I didn't get the date as text and the amount as real in table transactions.

[FrancoisBosun]

SQLite, as used in the article, has a very simple data model: 64 bit ints, 64 bit floats, and textual data. If you used a different database engine, you would probably use the datatypes it offers instead.

[memset]

Agree with this! I just used SQLite as kind of a pseudocode for demonstrating the concept.

[azlev]

Ah, thank you. I understood that it was a Clickhouae schema, it's not.