[Opendnssec-develop] Database conversion tool

Jerry Lundström jerry at opendnssec.org
Tue Jul 3 08:38:29 UTC 2012

On Tue, Jul 3, 2012 at 10:31 AM, Siôn Lloyd <sion at nominet.org.uk> wrote:
> One thing that I was thinking about is where we have used tinyint or
> mediumint in the mysql schema but integer in the sqlite schema. However I
> think there should be no real issues unless someone has more than 127 HSMs
> or 8,388,607 zones/policies (good luck with that).

Oh, maybe we should fix that for 1.4?

> The other thing is that in sqlite timestamps are stored as varchars; that
> should not be a problem, just something to be aware of.

MySQL is good at eating a lot of different timestamps layout but it
might not be as easy going from MySQL to SQLite, I'll keep that in
mind thanks.


More information about the Opendnssec-develop mailing list