[Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
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
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
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc@infomarc.info> wrote:
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.
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
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga < chathuranga.jayaneththi@gmail.com> wrote:
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc@infomarc.info> wrote:
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.
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. 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
On Thu, Apr 25, 2013 at 12:00 PM, Kasun Chathuranga < chathuranga.jayaneththi@gmail.com> wrote:
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga < chathuranga.jayaneththi@gmail.com> wrote:
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc@infomarc.info> wrote:
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.
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
Le 2013-05-12 12:54, Kasun Chathuranga a écrit :
On Thu, Apr 25, 2013 at 12:00 PM, Kasun Chathuranga <chathuranga.jayaneththi@gmail.com <mailto:chathuranga.jayaneththi@gmail.com>> wrote:
On Tue, Apr 23, 2013 at 11:51 PM, Kasun Chathuranga <chathuranga.jayaneththi@gmail.com <mailto:chathuranga.jayaneththi@gmail.com>> wrote:
On Tue, Apr 23, 2013 at 5:51 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote:
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.
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
Wow, it's always nice to see inter-project collaboration! -- Marc Delisle http://infomarc.info
participants (2)
-
Kasun Chathuranga -
Marc Delisle