Why not do UUIDs as a string or blob? And dates as strings, or integer / real timestamps? It conceptually simplifies things in so many ways that benefit the ap

Why not do UUIDs as a string or blob? And dates as strings, or integer / real timestamps? It conceptually simplifies things in so many ways that benefit the app developer, not just the sqlite devs and low-spec hardware. Simpler documentation, shorter learning curve, smaller surface area for bugs, smaller binary size, etc. There's a trend to add bloat and complexity to everything in software these days, but I'm so glad that a few projects like SQLite are pushing against that.