20 Mar 2020 |
@ruihildt:matrix.org | My other solution would be to store user timespan by 1/4 hours (96 / day) and then use a day to compare which ones of the 96 are the most selected. I could then constraint to the meeting duration. | 14:01:44 |
@tykaynchu:matrix.org | yup you can make some slicing restrictions | 14:02:22 |
@ruihildt:matrix.org | But it seems to me db intensive. (I have no idea though, I'm started programming recently) | 14:02:24 |
@tykaynchu:matrix.org | depending on your needs, "morning, noon, afternoon, evening" could be enough | 14:02:45 |
@ruihildt:matrix.org | To be really useful, it would need to be at least by half hour. | 14:03:41 |
@tykaynchu:matrix.org | you can have a look at the database i proposed for the backend, it already works | 14:04:14 |
@tykaynchu:matrix.org | it is not necessary greedy in the database | 14:06:53 |
@ruihildt:matrix.org | Migrations folder is empty? | 14:07:38 |
@tykaynchu:matrix.org | but yeah, framadate has not been build to have anyone else than the creator of a poll to select date and times | 14:08:39 |
@tykaynchu:matrix.org | with a little tweak it could be done though | 14:08:51 |
@ruihildt:matrix.org | I can't find the db schema, I looked at the migrations, but the folder i sempty. | 14:11:25 |
@tykaynchu:matrix.org | In reply to @ruihildt:matrix.org Migrations folder is empty? there is a migration folder, where ? | 14:11:38 |
@tykaynchu:matrix.org | yeah, in symfony you have to initiate the schema | 14:11:55 |
@ruihildt:matrix.org | https://framagit.org/tykayn/date-poll-api/-/tree/master/src%2FMigrations | 14:12:04 |
@tykaynchu:matrix.org | yeah, that is normal | 14:13:03 |
@tykaynchu:matrix.org | you need to follow the main readme.md | 14:13:31 |
@tykaynchu:matrix.org | oh i can drop you a database export | 14:15:27 |
@ruihildt:matrix.org | I wanted to have a look at the structure of the database.^^ | 14:17:31 |
@ruihildt:matrix.org | I'm really only used to NodeJS, I'll try to build following the readme. | 14:18:23 |
@tykaynchu:matrix.org | Download api_localhost-2020_03_20_15_18_08-dump.sql | 14:18:31 |
@tykaynchu:matrix.org | ah maybe i can make a visual export | 14:19:14 |
@ruihildt:matrix.org | I will also fix my postgresql install, for some reason it doesn't work anymore since I updated manjaro. | 14:19:49 |
@tykaynchu:matrix.org | mh, i dunno if you can import mysql stuff to postgre | 14:20:25 |
@tykaynchu:matrix.org | Download framadate-api.png | 14:23:48 |
@tykaynchu:matrix.org | there, sqlfairy does nice renders | 14:24:30 |
@tykaynchu:matrix.org | https://www.cipherbliss.com/exporter-une-visualisation-de-son-schma-sql/ | 14:25:42 |
@ruihildt:matrix.org | Yeah it's really nice. :) | 14:26:03 |
@ruihildt:matrix.org | tykayn: what's stack_of_votes for? | 16:56:11 |
@ruihildt:matrix.org | FYI, I'm thinking of using https://fullcalendar.io/ for all things calendar and timespan selection. | 17:01:05 |
@ruihildt:matrix.org | And I found someone having implemented the same concept: https://omnipointment.com | 17:47:28 |