berry120

United Kingdom

berry120.blogspot.com

Age: 25

I'm an avid programmer, enjoy creating things, enjoy a good puzzle and especially enjoy foxing people with a Java puzzle now and again!

Outside of my coding life, I have a number of other interests, including outdoors activities such as hiking / geocaching / letterboxing. I'm also fond of music - I enjoy listening to it as well as playing the piano and violin.

1d
awarded Good Answer
Nov
21
awarded Famous Question
Nov
19
awarded Popular Question
Nov
12
comment Making a JPanel disappear on Jbutton click
Have you looked at using a CardPanel?
Nov
5
revised How to recognize rectangles in this image?
Remove broken image
Nov
3
accepted Select rows with closest timestamp
Nov
3
comment Select rows with closest timestamp
Ah, I see - now however I think the subquery is causing an issue with the temporary table (getting a Can't reopen table: 'time_intervals' error.)
Nov
3
comment Select rows with closest timestamp
Hmm, for some reason the min(abs( line seems to be causing the query to return just one row - any ideas?
Nov
3
comment Select rows with closest timestamp
Thanks for trying to get this working - looks like an interesting approach!
Nov
2
comment Select rows with closest timestamp
+1, this is much better than anything I've come up with previously!
Nov
2
comment Select rows with closest timestamp
@Horaciux Hopefully the update has made it clearer, but the rule is the closest timestamp to the ideal timestamp (biased towards the earlier value in case of an equal offset.) The data is from a weather station which usually sends back packets every two seconds, but in certain cases (communication error, power failure, etc.) will skip some values.
Nov
2
comment Select rows with closest timestamp
@JeremyMiller Always specified in seconds, but can be greater than 60. Whatever "counts" is whatever is closest to the ideal values - I've updated the question to (hopefully) make this clearer.
Nov
2
revised Select rows with closest timestamp
added 568 characters in body
Nov
2
asked Select rows with closest timestamp
Nov
2
answered How can I stop JavaFX Parent Node getting click after drag between children
Oct
31
awarded Nice Answer
Oct
28
awarded Popular Question
Oct
23
awarded Yearling
Oct
23
awarded Yearling
Oct
22
awarded Yearling
1 2 3 4 5