Authors: George Mitenkov, Nuno Lopes, Juneyoung Lee
Date: 15.10.2021
This May, together with Nuno Lopes and Juneyoung Lee we made a proposal to add a new
Authors: George Mitenkov, Nuno Lopes, Juneyoung Lee
Date: 15.10.2021
This May, together with Nuno Lopes and Juneyoung Lee we made a proposal to add a new
-- Note: example given is for SQLite but can be adapted to other SQL | |
-- This is a fast query to sample random rows | |
-- It gets a list of existing row identifiers (rowids), | |
-- materializes, sorts, and picks 10. | |
SELECT * FROM test | |
WHERE rowid IN | |
(SELECT rowid FROM test | |
ORDER BY random() LIMIT 10); |
Transaction fees as they are currently implemented in the original Bitcoin code suffer from a few problems:
I'm proposing changing the rules miners use to decide what transactions to include in their blocks, and changing the way clients tell users whether or not any particular transaction "needs" a fee to be confirmed in a reasonable amount of time.