View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001752 | SkyChart | 1-Software | public | 17-07-28 17:14 | 19-02-10 10:41 |
Reporter | Sasa | Assigned To | Patrick Chevalley | ||
Priority | normal | Severity | feature | Reproducibility | have not tried |
Status | assigned | Resolution | open | ||
Platform | Linux 64-bit | OS | Lubuntu | OS Version | 17.04 |
Product Version | 4.1 SVN | ||||
Target Version | 4.4 | ||||
Summary | 0001752: MySQL support | ||||
Description | If 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. | ||||
Tags | No tags attached. | ||||
|
(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. |
|
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. |
|
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. |
|
When 4,2 will actually be released? |
|
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. |
|
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. |
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 |