Hace poco salio una entrevista con el creador de sqlite, contando como llego a crear la BD mas popular e instalada del mundo:
https://corecursive.com/066-sqlite-with-richard-hipp/
De lo mas interesante:
Cita:
|
Richard:Yes, so we’ll do billions of tests.
|
(Son en realidad como 100.000 test con un parametrizador que genera el resto)
Cita:
He came up with this huge corpus of SQL statements, and he ran them against every database engine that he could get his hands on. We wanted to make sure everybody got the same answer, and he managed to segfault every single database engine he tried, including SQLite, except for Postgres. Postgres always ran and gave the correct answer. We were never able to find a fault in that...
We crashed Oracle, including commercial versions of Oracle. We crashed DB2. Anything we could get our hands on, we tried it and we managed to crash it, but the point was that we wanted to make sure that SQLite got the same answers for all of these queries, or equivalent answers, because a lot of these queries, they’re indeterminate and the rows might come out in a different order because you [crosstalk 00:25:10] order by clause, so we wanted to make sure that all the database engines got equivalent answers. Mostly, we wanted to make sure that SQLite was getting the same answers everybody else is.
|
No es broma cuando se dice que sqlite & postgresql son las BD open source mas robutas y mejor testeadas. Y el resultado?:
Cita:
Getting that last 5% is really, really hard and it took about a year for me to get there, but once we got to that point, we stopped getting bug reports from Android.
Adam:Oh, wow.
Richard:Yeah. IT just worked from there on out. It made a huge, huge difference. We just didn’t really have any bugs for the next eight or nine years.
|
1 año de sudar todo una baterias de test, 8 sin bugs? Impresionante.
P.D: Si alguien se le quiere medir a hacer una BD estoy en eso:
https://tablam.org
03-07-2021
Temas Similares
Mode Lineal
