View Issue Details

IDProjectCategoryView StatusLast Update
0001752SkyChart1-Softwarepublic19-02-10 10:41
ReporterSasa Assigned ToPatrick Chevalley  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status assignedResolutionopen 
PlatformLinux 64-bitOSLubuntuOS Version17.04
Product Version4.1 SVN 
Target Version4.4 
Summary0001752: MySQL support
DescriptionIf there is no special reasons for existence, mySQL support may be removed completely.

Reasons:

1. Double engine support (mySQL and SQlite). Make a maintenance complex.
2. MySQL is real RMDBS and much slower than SQLite. Especially record addition may be much faster with low level binding with SQlite.
TagsNo tags attached.

Activities

Sasa

17-07-28 18:24

reporter   ~0003943

Last edited: 17-07-28 19:01

(RMDBS -> RDBMS, mistyping)

Of course, I have read Help section about MySQL. According to it, MySQL was first used database engine, until June 2005 when SQLite become default one.

Sharing one database across a local network is one benefit of RDBMS sever, however, I find CDC more suitable as single use app for (advanced) amateur astronomers, in which case use of a RDBMS sever is an overkill.

SQLite database file may be used as well across a local network, in contrary to client connection on centralized RDBMS server - simple sharing file rules is used.

In both cases, some actions must be carefully controlled, as loading and refreshing different catalogs. For instance, one client only may request loading and updating the same (or any) catalog, etc. I'm not certain that is forbidden by default, except some quite basic (database engine depending) lock/unlock mechanism.

Of course, all this is my point of view only.

Patrick Chevalley

17-07-29 17:31

administrator   ~0003946

I agree this can be a simplification, specifically if some day I need to replace the libsql component.

Maybe for the next version (4.2) I can just remove the database selection dialog but let the mysql code in place to not break eventual existing users but show a warning.

And if I not receive complaint about this change I remove the code for 4.4.

Patrick Chevalley

18-10-03 10:37

administrator   ~0004918

For version 4.2 I make a change so it show a message on startup if Mysql is in use. Also Mysql can no more be selected in the options.
https://github.com/pchev/skychart/commit/02a5c93253365588aff312e7a051dab7ecbe5100

I change the target for this issue to 4.4 to totally remove the Mysql code.

Sasa

19-02-05 00:26

reporter   ~0005328

When 4,2 will actually be released?

Patrick Chevalley

19-02-06 13:34

administrator   ~0005337

I was waiting for stable Lazarus 2.0. This is done since yesterday, so now as soon there is no more open issue for 4.2 we can go.

Patrick Chevalley

19-02-06 14:01

administrator   ~0005342

I just do some bug triage and the roadmap for 4.2 is now at 100%
So I hope for a release after the new changes are in beta for some days, probably in about 15 days.

Issue History

Date Modified Username Field Change
17-07-28 17:14 Sasa New Issue
17-07-28 18:24 Sasa Note Added: 0003943
17-07-28 18:25 Sasa Note Edited: 0003943
17-07-28 18:27 Sasa Note Edited: 0003943
17-07-28 18:27 Sasa Note Edited: 0003943
17-07-28 18:50 Sasa Note Edited: 0003943
17-07-28 19:01 Sasa Note Edited: 0003943
17-07-29 17:31 Patrick Chevalley Assigned To => Patrick Chevalley
17-07-29 17:31 Patrick Chevalley Status new => assigned
17-07-29 17:31 Patrick Chevalley Target Version => 4.2
17-07-29 17:31 Patrick Chevalley Note Added: 0003946
18-10-03 10:37 Patrick Chevalley Target Version 4.2 => 4.4
18-10-03 10:37 Patrick Chevalley Note Added: 0004918
19-02-05 00:26 Sasa Note Added: 0005328
19-02-06 13:34 Patrick Chevalley Note Added: 0005337
19-02-06 14:01 Patrick Chevalley Note Added: 0005342