1 |
On Tuesday, August 12, 2014 09:20:59 PM Alan McKinnon wrote: |
2 |
> On 12/08/2014 21:00, J. Roeleveld wrote: |
3 |
> > On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann |
4 |
<volkerarmin@××××××××××.com> wrote: |
5 |
> >> Am 12.08.2014 um 16:10 schrieb J. Roeleveld: |
6 |
> >>> On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: |
7 |
> >>>> On 12/08/2014 15:28, J. Roeleveld wrote: |
8 |
> >>>>> On 12 August 2014 14:06:07 CEST, Alan McKinnon |
9 |
> >> |
10 |
> >> <alan.mckinnon@×××××.com> |
11 |
> >> |
12 |
> >>> wrote: |
13 |
> >>>>>> On 12/08/2014 11:10, Mick wrote: |
14 |
> >>>>>>> I recall the devs explicitly stating early enough in the KDE4 |
15 |
> >>>>>> |
16 |
> >>>>>> development that |
17 |
> >>>>>> |
18 |
> >>>>>>> sqlite is not man enough for the job and advising everyone to |
19 |
> >> |
20 |
> >> move |
21 |
> >> |
22 |
> >>>>>> over to |
23 |
> >>>>>> |
24 |
> >>>>>>> mysql. |
25 |
> >>>>>>> |
26 |
> >>>>>>> Someone was looking at postgresql as an alternative to mysql, but |
27 |
> >> |
28 |
> >> I'm |
29 |
> >> |
30 |
> >>>>>> not sure |
31 |
> >>>>>> |
32 |
> >>>>>>> that this would bring any benefit. |
33 |
> >>>>>> |
34 |
> >>>>>> pg is a fine database, but for this use will always be a 2nd class |
35 |
> >>>>>> citizen. Most users will already have mysql installed, or will be |
36 |
> >>>>>> willing to install it. |
37 |
> >>>>>> |
38 |
> >>>>>> The number of folks with pg and without mysql will probably be |
39 |
> >> |
40 |
> >> small |
41 |
> >> |
42 |
> >>>>> Not necessarily. |
43 |
> >>>>> People who care about databases actually supporting SQL properly |
44 |
> >> |
45 |
> >> and |
46 |
> >> |
47 |
> >>>>> performing properly will prefer PostgreSQL. |
48 |
> >>>>> |
49 |
> >>>>> I don't like to be forced to run a MySQL instance as well. It's |
50 |
> >> |
51 |
> >> often the |
52 |
> >> |
53 |
> >>>>> laziness of developers that causes the difficulty of supporting a |
54 |
> >>>>> different database when they started with MySQL. If you start with |
55 |
> >> |
56 |
> >> a |
57 |
> >> |
58 |
> >>>>> different one, like PostgrSQL, supporting different database |
59 |
> >> |
60 |
> >> engines is |
61 |
> >> |
62 |
> >>>>> very simple. |
63 |
> >>>> |
64 |
> >>>> I don't think you read what I said. |
65 |
> >>> |
66 |
> >>> Sorry, didn't read the below in what you put. |
67 |
> >>> |
68 |
> >>>> I didn't say postgresql shouldn't be supported, I said it would |
69 |
> >> |
70 |
> >> always |
71 |
> >> |
72 |
> >>>> end up being a second class citizen as the number of people who'd be |
73 |
> >>>> happy with mysql will vastly outnumber the number of people who |
74 |
> >> |
75 |
> >> highly |
76 |
> >> |
77 |
> >>>> desire postgresql. So, logically, a postgresql driver in this case |
78 |
> >> |
79 |
> >> will |
80 |
> >> |
81 |
> >>>> probably just bitrot away. Whihc nicely explains the likely reason |
82 |
> >> |
83 |
> >> why |
84 |
> >> |
85 |
> >>>> that driver is not there. |
86 |
> >>> |
87 |
> >>> It wouldn't bitrot away as there would be people willing to keep it |
88 |
> >> |
89 |
> >> working, |
90 |
> >> |
91 |
> >>> provided it wouldn't require a MySQL -> SQL translator to be kept |
92 |
> >> |
93 |
> >> up-to-date. |
94 |
> >> |
95 |
> >>>> People like yourself who care about databases are very much in the |
96 |
> >>>> minority of users, even on Linux. Most users across the boards just |
97 |
> >>>> don't give a shit. Them's the breaks. |
98 |
> >>> |
99 |
> >>> Users never care about what they install. I just wish the majority of |
100 |
> >>> |
101 |
> >>> developers would actually be willing to follow some simple guidelines |
102 |
> >> |
103 |
> >> to make |
104 |
> >> |
105 |
> >>> it actually possible to others to write and maintain the drivers to |
106 |
> >> |
107 |
> >> connect to |
108 |
> >> |
109 |
> >>> different databases. |
110 |
> >>> |
111 |
> >>> Several attempts have been made by people to add support for |
112 |
> >> |
113 |
> >> different |
114 |
> >> |
115 |
> >>> databases to various projects. I've tried to do it myself on |
116 |
> >> |
117 |
> >> occasion, but |
118 |
> >> |
119 |
> >>> even when patches are accepted by upstream, they get broken by |
120 |
> >> |
121 |
> >> upstream at a |
122 |
> >> |
123 |
> >>> future release again because of the bad design that is often employed |
124 |
> >> |
125 |
> >> by lazy |
126 |
> >> |
127 |
> >>> developers. |
128 |
> >>> |
129 |
> >>> -- |
130 |
> >>> Joost |
131 |
> >> |
132 |
> >> wasn't qtsql once supposed to that? |
133 |
> > |
134 |
> > If a framework like qtsql is used, swapping the database is easy. |
135 |
> > |
136 |
> > Most developers seem to prefer to reinvent the wheel and often come up |
137 |
> > with something that vaguely resembles a circle and is held together with |
138 |
> > a mixture of glue and duck tape. |
139 |
> I blame php and others of it's ilk. |
140 |
|
141 |
My point exactly. |
142 |
|
143 |
> The good thing about php is that everyone and their dog can knock out |
144 |
> running code. |
145 |
> The bad thing about php is that they do. |
146 |
|
147 |
Not PHP's fault, lazy developers' fault. |
148 |
|
149 |
> Substitute mysql and bash if you will and tweak the content to suit - it |
150 |
> all works out the same. |
151 |
> |
152 |
> Sensible languages (like, oh I dunno - python maybe?) have this trick |
153 |
> about them - you have to work hard to write awful code. You also have to |
154 |
> work hard to write awesome code, but if you just follow the book you |
155 |
> usually end up with acceptable code. |
156 |
|
157 |
I agree, to a fashion. I've seen some really bad examples of Python code |
158 |
though. |
159 |
|
160 |
> I will refrain from commenting on perl. |
161 |
|
162 |
I'm surprised noone came up with a Desktop Environment (like KDE and Gnome) |
163 |
written as a perl one-liner yet. ;) |
164 |
|
165 |
-- |
166 |
Joost |