23 Apr
2013
23 Apr
'13
2:06 a.m.
Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp data
types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the syntax
for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2], however
the fractional seconds were discarded when storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature request
is important.
I have looked into the code to implement this feature request and the major
problem faced is the incompatibility of JavaScript timepicker used [4],
which only supports up to milliseconds (3 digits). I have been improving
this JS file to support microseconds, however it is a somewhat big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker project,
so it will be a part of the timepicker project as well. However, with the
second option it might take some time till they (hopefully) accept the
patch and do a release containing it.
Your thoughts on this would be highly appreciated.
[1] https://sourceforge.net/p/phpmyadmin/feature-requests/1397/
[2] https://dev.mysql.com/doc/refman/5.0/en/datetime.html
[3] https://dev.mysql.com/doc/refman/5.6/en/datetime.html
[4] http://trentrichardson.com/examples/timepicker/
--
Regards
Kasun Chathuranga
23 Apr
23 Apr
8:21 a.m.
New subject: [Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp
data types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the
syntax for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2], however
the fractional seconds were discarded when storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature
request is important.
I have looked into the code to implement this feature request and the
major problem faced is the incompatibility of JavaScript timepicker used
[4], which only supports up to milliseconds (3 digits). I have been
improving this JS file to support microseconds, however it is a somewhat
big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker
project, so it will be a part of the timepicker project as well.
However, with the second option it might take some time till they
(hopefully) accept the patch and do a release containing it.
Kasun,
I think it's best to send them a pull request, asking them about their
release plans. Forking their library in phpMyAdmin is problematic for
maintenance.
--
Marc Delisle
http://infomarc.info
2:21 p.m.
New subject: [Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
I have submitted a pull request here [1]. Eagerly waiting to see what their
reaction is :)
[1] https://github.com/trentrichardson/jQuery-Timepicker-Addon/pull/577
--
Regards
Kasun Chathuranga
Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp
data types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the
syntax for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2], however
the fractional seconds were discarded when storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature
request is important.
I have looked into the code to implement this feature request and the
major problem faced is the incompatibility of JavaScript timepicker used
[4], which only supports up to milliseconds (3 digits). I have been
improving this JS file to support microseconds, however it is a somewhat
big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker
project, so it will be a part of the timepicker project as well.
However, with the second option it might take some time till they
(hopefully) accept the patch and do a release containing it.
Kasun,
I think it's best to send them a pull request, asking them about their
release plans. Forking their library in phpMyAdmin is problematic for
maintenance.
25 Apr
25 Apr
2:30 a.m.
New subject: [Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga <
chathuranga.jayaneththi(a)gmail.com> wrote:
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc(a)infomarc.info> wrote:
My pull request has been merged to the code base with some modifications
and it will be included in their next release. I will implement the
functionality in phpMyAdmin code if this release happens soon.
Anyway, I will include the feature request as a part of my GSoC proposal
'Interface Improvements' and will implement it if my proposal gets accepted.
--
Regards
Kasun Chathuranga
Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
I have submitted a pull request here [1]. Eagerly waiting to see what
their reaction is :)
[1] https://github.com/trentrichardson/jQuery-Timepicker-Addon/pull/577
Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp
data types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the
syntax for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2], however
the fractional seconds were discarded when storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature
request is important.
I have looked into the code to implement this feature request and the
major problem faced is the incompatibility of JavaScript timepicker used
[4], which only supports up to milliseconds (3 digits). I have been
improving this JS file to support microseconds, however it is a somewhat
big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker
project, so it will be a part of the timepicker project as well.
However, with the second option it might take some time till they
(hopefully) accept the patch and do a release containing it.
Kasun,
I think it's best to send them a pull request, asking them about their
release plans. Forking their library in phpMyAdmin is problematic for
maintenance.
12 May
12 May
12:54 p.m.
New subject: [Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
On Thu, Apr 25, 2013 at 12:00 PM, Kasun Chathuranga <
chathuranga.jayaneththi(a)gmail.com> wrote:
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga <
chathuranga.jayaneththi(a)gmail.com> wrote:
[1] and I
will be working on implementing the feature request.
[1]
http://trentrichardson.com/examples/timepicker/jquery-ui-timepicker-addon.js
--
Regards
Kasun Chathuranga
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc(a)infomarc.info> wrote:
My pull request has been merged to the code base with some modifications
and it will be included in their next release. I will implement the
functionality in phpMyAdmin code if this release happens soon.
Version 1.3 of the timepicker which contains this code has been released Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
I have submitted a pull request here [1]. Eagerly waiting to see what
their reaction is :)
[1] https://github.com/trentrichardson/jQuery-Timepicker-Addon/pull/577
Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp
data types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the
syntax for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2],
however
the fractional seconds were discarded when
storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature
request is important.
I have looked into the code to implement this feature request and the
major problem faced is the incompatibility of JavaScript timepicker
used
[4], which only supports up to milliseconds (3
digits). I have been
improving this JS file to support microseconds, however it is a
somewhat
big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker
project, so it will be a part of the timepicker project as well.
However, with the second option it might take some time till they
(hopefully) accept the patch and do a release containing it.
Kasun,
I think it's best to send them a pull request, asking them about their
release plans. Forking their library in phpMyAdmin is problematic for
maintenance.
5:27 p.m.
New subject: [Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
Le 2013-05-12 12:54, Kasun Chathuranga a écrit :
On Thu, Apr 25, 2013 at 12:00 PM, Kasun Chathuranga
<chathuranga.jayaneththi(a)gmail.com
<mailto:chathuranga.jayaneththi@gmail.com>> wrote:
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga
<chathuranga.jayaneththi(a)gmail.com
<mailto:chathuranga.jayaneththi@gmail.com>> wrote:
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle
<marc(a)infomarc.info <mailto:marc@infomarc.info>> wrote:
Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
Wow, it's always nice to see inter-project collaboration!
--
Marc Delisle
http://infomarc.info
Hi all,
I am interested in the feature request #1397 [1], which
requests that
phpMyAdmin support fractional seconds in time,
datetime
and timestamp
data types.
After bit of research I found that these data types
support trailing
fractional seconds up to microseconds (6 digits).
For
example, the
syntax for datetime including fractional seconds
would be
'2013-04-23
11:21:07.145236'. This syntax is supported
from version
5.0 [2], however
the fractional seconds were discarded when
storing. From
version 5.6.4
onwards these fractional seconds are stored and
hence
this feature
request is important.
I have looked into the code to implement this feature
request and the
major problem faced is the incompatibility of
JavaScript
timepicker used
[4], which only supports up to milliseconds (3
digits). I
have been
improving this JS file to support microseconds,
however
it is a somewhat
big change.
I'd like to know whether I should simply alter the
external JS
file in
phpMyAdmin code or I should send a pull request
to the
timepicker
project, so it will be a part of the timepicker
project
as well.
However, with the second option it might take
some time
till they
(hopefully) accept the patch and do a release
containing it.
Kasun,
I think it's best to send them a pull request, asking them
about their
release plans. Forking their library in phpMyAdmin is
problematic for
maintenance.
I have submitted a pull request here [1]. Eagerly waiting to see
what their reaction is :)
[1]
https://github.com/trentrichardson/jQuery-Timepicker-Addon/pull/577
My pull request has been merged to the code base with some
modifications and it will be included in their next release. I will
implement the functionality in phpMyAdmin code if this release
happens soon.
Version 1.3 of the timepicker which contains this code has been released
[1] and I will be working on implementing the feature request.
[1]
http://trentrichardson.com/examples/timepicker/jquery-ui-timepicker-addon.js
--
Regards
Kasun Chathuranga
4093
days inactive
4112
days old
5 comments
2 participants
participants (2)
-
Kasun Chathuranga -
Marc Delisle