updating Trac database with direct SQL requests

[phep]

Hi,

I'd like to update some custom or standard fields in the database of one of my Trac instances using SQL requests. I run this instance on my laptop with tracd and I'm always the only user (I turned this instance into a personal task manager, sort of).

I've had a look at the ticket, ticket_change and ticket_custom tables and I feel comfortable at dealing with the data in those 3 tables.

Yet I wonder if updating the database with SQL requests while tracd is running could have side effects in case there are some locks of any sort, or if this could affect some caching mechanism ?

Thanks in advance,

phep

[RjOllos]

There is some caching, so your best move would be to stop the server, make the database edits, start the server.

Ryan