[Monotone-devel] Re: Deleting

[graydon hoare]

Peter Simons wrote:

> Isn't sqlite supposed to have some kind of user front-end,
> from which you can speak SQL to the database? That doesn't
> seem to be included in the monotone distribution? Because
> IMHO SQL-access to the database really is all I'll ever
> need. And a bit of documentation about the table format,
> maybe. :-)

yeah, monotone debug '<sql statement>' works. even dumps results if you 
do a select statement.

otherwise yeah, the sqlite command-line tool works. the schema is 
documented in, er, schema.sql :)

> Nonetheless, some standard operations would be nice to have
> in Monotone; deleting a whole branch seems the most obvious
> to me. That's exactly what I need right now.

yes, the raw SQL is not the sort of interface I want to encourage. it's 
just for manual fiddling.

> I think, though, that such operations on the _depot_ would
> be more important. Currently, I re-build them from the
> scratch every time I've messed something up, but that's not
> really a good solution ... at least if you mess things up as
> often as I do.

see depot_schema.sql. unfortunately depots hold (forward) packet 
streams, not general version databases, so if you delete a base version 
(fdata, mdata) packet nobody will be able to rebuild anything from your 
depot. Yet Another Reason for netsync.

-graydon