Agreed long overdue if only to get rid of the chars outside A-Z, a-z, 0-9.
However I did take a look at this some time back (OK, may be 4 - 5 years ago) but the file database was not the easiest to understand and one feature I did wnt to look at was adding in removal of all non alphanumeric chars subject to a set up parameter, similar to many other bbs products eg SBBS, Maximus, Adept etc.
One area to consider is to change the database system and move it to a rdbms or dbms such as Mysql/Mariadb then gradually move over all of the others.
Having done that it should be a lot easier to create a description editor to utilise the new DB system.
Currently the DB is created in a linear form so if you wish to change a block of scriptive text it need to be placed at the end of the DB moving the old pointer to the new and marking the old as deleted.
I did struggle to see and understand the DB system used in mbse but it may be just a new look with fresh eyes but I still like the idea of moving it all to Mysql which if for no other reason would allow more than one instance of mbse to be in operation on the same box or in two or more using connectible server instance on one of the systems in a network.
Anyone any thoughts on the above?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I do seem to recall looking at that in the distant past but ignored it
as wanting to use a sql based product so that only the needed columns
are retrieved as required.
Vincent
On 31/03/14 14:53, Robert James Clay wrote:
On Sun, Mar 30, 2014 at 6:41 PM, Vincent (Bryan) Coen
vcoen@users.sf.net vcoen@users.sf.net wrote:
One area to consider is to change the database system and move it
to a rdbms or dbms
such as Mysql/Mariadb then gradually move over all of the others.
I've thought of using SQLite for something like that, since it has
the functionality but doesn't require having a separate DB server
available...
On Tue, Apr 1, 2014 at 4:09 PM, Vincent (Bryan) Coen vcoen@users.sf.net wrote:
I do seem to recall looking at that in the distant past but ignored it
as wanting to use a sql based product so that only the needed columns
are retrieved as required.
Well, it is an "sql based product" (https://sqlite.org/); perhaps
you're thinking of something else?
I haven't tried using the C library for any projects as yet, but do
use the Perl DBI interface as well as the command line & gui DB apps.
--
Robert J. Clay
rjclay@gmail.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Agreed long overdue if only to get rid of the chars outside A-Z, a-z, 0-9.
However I did take a look at this some time back (OK, may be 4 - 5 years ago) but the file database was not the easiest to understand and one feature I did wnt to look at was adding in removal of all non alphanumeric chars subject to a set up parameter, similar to many other bbs products eg SBBS, Maximus, Adept etc.
One area to consider is to change the database system and move it to a rdbms or dbms such as Mysql/Mariadb then gradually move over all of the others.
Having done that it should be a lot easier to create a description editor to utilise the new DB system.
Currently the DB is created in a linear form so if you wish to change a block of scriptive text it need to be placed at the end of the DB moving the old pointer to the new and marking the old as deleted.
I did struggle to see and understand the DB system used in mbse but it may be just a new look with fresh eyes but I still like the idea of moving it all to Mysql which if for no other reason would allow more than one instance of mbse to be in operation on the same box or in two or more using connectible server instance on one of the systems in a network.
Anyone any thoughts on the above?
On Sun, Mar 30, 2014 at 6:41 PM, Vincent (Bryan) Coen
vcoen@users.sf.net wrote:
I've thought of using SQLite for something like that, since it has
the functionality but doesn't require having a separate DB server
available...
--
Robert J. Clay
rjclay@gmail.com
I do seem to recall looking at that in the distant past but ignored it
as wanting to use a sql based product so that only the needed columns
are retrieved as required.
Vincent
On 31/03/14 14:53, Robert James Clay wrote:
Related
Tickets: #1
On Tue, Apr 1, 2014 at 4:09 PM, Vincent (Bryan) Coen vcoen@users.sf.net wrote:
Well, it is an "sql based product" (https://sqlite.org/); perhaps
you're thinking of something else?
I haven't tried using the C library for any projects as yet, but do
use the Perl DBI interface as well as the command line & gui DB apps.
--
Robert J. Clay
rjclay@gmail.com