[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-07-03 Thread IGnatius T Foobar
You mean like this? ;) [ https://code.citadel.org/citadel/citadel-docker ] I'd like to get things trending towards more deployment of the Docker image (or technically an OCI compatible container, since you don't have to run it under Docker, blah blah blah) The current distribution is

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-07-03 Thread LoanShark
>That seems to imply that Sqlite might be a better option than >MySQL/MariaDB because we do *not* want to require people to install a >working database server before Citadel can be installed. Devil's Advocate from an Armchair Programmer: these days, if you bundle an app as a Do

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-07-01 Thread IGnatius T Foobar
>If you want to stay with index/data for the database, I think I might go back >and see if I can finish up a database.c replacement with MySql.  What I Hey, I'm totally cool with moving to a SQL database, if someone else is doing to be doing the bulk of the work. Seriously. I am just o

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-30 Thread HarlowSolutions
If you want to stay with index/data for the database, I think I might go back and see if I can finish up a database.c replacement with MySql.  What I don't have is the statistics for a large email server (mine is very small).  I wrote a small C program that went through all the Berkley databases an

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-30 Thread IGnatius T Foobar
>Just to chime in, the database.c code is very clean.  The only problem I >have had with Berkeley is that if the code or system crashes, most of the >time, the database is corrupted and recover does not help sometimes and I >have to revert to a backup.  The code has become a lot more st

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-29 Thread HarlowSolutions
Just to chime in, the database.c code is very clean.  The only problem I have had with Berkeley is that if the code or system crashes, most of the time, the database is corrupted and recover does not help sometimes and I have to revert to a backup.  The code has become a lot more stable so not as b

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-23 Thread IGnatius T Foobar
Right, and we do table-level locking in the application before we even attempt to touch the database, so that has worked pretty well. I did end up using an alternate --prefix just to keep the build a little more solid, but that seems to just change the symbol names internally without actually

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-21 Thread LoanShark
> 2023-06-20 15:02 from IGnatius T Foobar >Subject: Re: Long term plans for phase-out of Berkeley DB? > > Heh. Most of the database layer is still pretty much the same code >you wrote 22 years ago. You did a great job on that. As I recall, I interpreted their documentation

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-20 Thread IGnatius T Foobar
Heh. Most of the database layer is still pretty much the same code you wrote 22 years ago. You did a great job on that. I've thought about switching to a SQL model. It would confer a lot of benefits. It would also open up a huge effort in getting all of the code converted over to actu

[Citadel Development] Re: Long term plans for phase-out of Berkeley DB?

2023-06-20 Thread LoanShark
> 2023-06-15 13:32 from IGnatius T Foobar >Subject: Long term plans for phase-out of Berkeley DB? > > A bit of thinking out loud with regard to long term plans for Citadel >Server. > > Berkeley DB seems to have gained a bad reputation in the open source >community.