Hi, Eric, Von: Eric Rubin-Smith > > So far no one has raised the idea of using a "big int" layer to implement > proper integer arithmetic past 64 bits. The fact that it hasn't been > mentioned makes me worry that it's a blatantly silly idea for SQLite for some > reason -- but I'm tossing it out there on the off chance that it's useful.
Actually, I did: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2014-July/054285.html > Personally, I would have loved to be able to use 128-bit integer math a few > weeks ago when I was investigating the idea of implementing a longest-prefix > search capability for IPv6 networks using SQLite's R*Tree. > I had to implement all the shifting and such in C, which is fine, but it > would have been pretty sexy to have gotten it all done in SQL. I'm not sure whether such functionalities are a must for SQLite core, but I think that extensions providing such functionalities should be possible. I'm not that much into SQLite internals yet, but I know that PostgreSQL allows extensions to define their own data types with their own parsers and syntax, which is used e. G. by the PostGIS extension. On the other hand, PostgreSQL has built-in "decimal" and "numeric" types which allow up to 131072 digits before and 16383 digits after the decimal point. http://www.postgresql.org/docs/current/static/datatype-numeric.html So one might argue such datatypes could also fit well into SQLite :-) Best regards Markus Schaber CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH Inspiring Automation Solutions 3S-Smart Software Solutions GmbH Dipl.-Inf. Markus Schaber | Product Development Core Technology Memminger Str. 151 | 87439 Kempten | Germany Tel. +49-831-54031-979 | Fax +49-831-54031-50 E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: http://store.codesys.com CODESYS forum: http://forum.codesys.com Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade register: Kempten HRB 6186 | Tax ID No.: DE 167014915 This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users