110 reputation
4
bio website enrmarc.github.io
location Spain
age
visits member for 2 years, 10 months
seen Jun 26 at 16:15

Software developer.


Sep
24
awarded  Autobiographer
Sep
4
comment Best way to handle temporary data
Thanks. I'm not sure about triggers, I need to execute PHP code.
Sep
4
comment Best way to handle temporary data
@Kin MySQL 5.1.70
Sep
4
asked Best way to handle temporary data
Sep
4
accepted Nested one to many relationships?
Sep
2
awarded  Scholar
Sep
2
accepted Bus time schedule database design
Sep
2
comment Nested one to many relationships?
Thanks. I'll take your design into consideration.
Sep
2
comment Nested one to many relationships?
Thanks. Now my question is: Is ok to include line_id in table Times just for the sake of clear SQL queries? (or performance maybe)
Sep
2
comment Nested one to many relationships?
@ypercube but I think that would obfuscate the query. I will have to to something like this select * from times t, stops s, lines l, where l.id = s.line_id and s.id = t.stop_id and l.id = 1 and s.id = 1;
Sep
2
comment Nested one to many relationships?
@Rachcha For example: if I want to select all the arrival times from stop 1 and line 1: select * from times where stop_id = 1 and line_id = 1;"
Sep
2
asked Nested one to many relationships?
Jul
24
comment Bus time schedule database design
Is route_actual_times table similar to my times table? Maybe I'm doing it right
Jul
24
comment Bus time schedule database design
Yes that would work if the frequency was the same (9:15, 9:30, 9:45, 10:00, ...), but the fact is that is not. This would be the a real schedule of the example above: 9:15, 9:31, 9:44, 10:02, ... so I need to store this times.
Jul
23
comment Bus time schedule database design
Thanks. I must keep track of all times because the delta value for each line stop is innacurate and the goal of my system is to predict the next arrival time. So the idea is that the users can introduce the time they take the bus with specifc station and line ... then the system can calculate a median (or something like that) to predict the arrival time.
Jul
22
awarded  Student
Jul
22
asked Bus time schedule database design
Feb
19
awarded  Supporter