[opensuse-web] Pg Port of OSEM now live
OSEM, Thought you would like to see the results of a *LOT* of work: http://pgconf.us/ Outside of the base port to Pg there are a few things we have done including: 1. Allowing for 5 minute precision with scheduling. * Not everyone runs on 15 minutes 2. Cleaning up the internal schedule so that the colors are translucent. * This allows for easy visuals of the time underneath the talk 3. Adding flat pages * We added flat pages that can be edited with markdown. Right now they are specific to policies and venue extra (client on venue on the URL above to see what I mean) 4. Changing routes to make sure that / shows the current conference not the current conference listing Things we are working on: 1. Add event/Multi-Event * Currently there is no way to add an event outside of the submission process. That makes adding ad-hoc events difficult. For one recruited (versus self-submission) speaker, I had to add the talk as myself and then run an update on the database to make the speaker own the talk. * Multi-Event, lunches, breaks, coffee breaks, lightning talks etc... are all multi-events. The idea is this, using the new add event page you can say: We have three lunches, two coffee breaks, and four keynotes. This will cause a "conference" track that has those events in the schedule for placement. In short, there would be three lunches to place on the schedule etc... 2. External conferences * This is a simple feature but as the application has the ability to have a directory listing of conference we wanted the ability to say, "Hey, LFNW is happening. Let's list them in our conference listing" and have the "View Conference" link go to their site. 3. The model * With the greatest respect to the awesome conference application you have written, it is clear that a DBA wasn't involved. One of the first things I noticed was the table events has a column called state. The current value of this is one of: confirmed, new, unconfirmed rejected etc... However, there is zero constraints to this column. At a minimum we need a check constraint on that column. In a better world it would be a foreign key to a look up table. JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- To unsubscribe, e-mail: opensuse-web+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-web+owner@opensuse.org
#4 we also added "conference sponsor" abilities. As you will see when you view the site. -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- To unsubscribe, e-mail: opensuse-web+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-web+owner@opensuse.org
JD, the page looks awesome and I can imagine how much work there was involved! I know that we still need to review and merge the PG pull request, sorry for the delay. I will definitely after the holidays have a more detailed look into it. Thanks for all the effort you put in, much appreciated! Christian On 01/05/2017 06:51 PM, Joshua D. Drake wrote:
OSEM,
Thought you would like to see the results of a *LOT* of work:
Outside of the base port to Pg there are a few things we have done including:
1. Allowing for 5 minute precision with scheduling. * Not everyone runs on 15 minutes 2. Cleaning up the internal schedule so that the colors are translucent. * This allows for easy visuals of the time underneath the talk 3. Adding flat pages * We added flat pages that can be edited with markdown. Right now they are specific to policies and venue extra (client on venue on the URL above to see what I mean) 4. Changing routes to make sure that / shows the current conference not the current conference listing
Things we are working on:
1. Add event/Multi-Event * Currently there is no way to add an event outside of the submission process. That makes adding ad-hoc events difficult. For one recruited (versus self-submission) speaker, I had to add the talk as myself and then run an update on the database to make the speaker own the talk.
* Multi-Event, lunches, breaks, coffee breaks, lightning talks etc... are all multi-events. The idea is this, using the new add event page you can say:
We have three lunches, two coffee breaks, and four keynotes. This will cause a "conference" track that has those events in the schedule for placement. In short, there would be three lunches to place on the schedule etc...
2. External conferences * This is a simple feature but as the application has the ability to have a directory listing of conference we wanted the ability to say, "Hey, LFNW is happening. Let's list them in our conference listing" and have the "View Conference" link go to their site.
3. The model
* With the greatest respect to the awesome conference application you have written, it is clear that a DBA wasn't involved. One of the first things I noticed was the table events has a column called state. The current value of this is one of: confirmed, new, unconfirmed rejected etc...
However, there is zero constraints to this column. At a minimum we need a check constraint on that column. In a better world it would be a foreign key to a look up table.
JD
-- To unsubscribe, e-mail: opensuse-web+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-web+owner@opensuse.org
On 01/05/2017 06:51 PM, Joshua D. Drake wrote:
OSEM,
Thought you would like to see the results of a *LOT* of work:
Awesome
[...]
3. The model
* With the greatest respect to the awesome conference application you have written, it is clear that a DBA wasn't involved. One of the first things I noticed was the table events has a column called state. The current value of this is one of: confirmed, new, unconfirmed rejected etc...
However, there is zero constraints to this column. At a minimum we need a check constraint on that column. In a better world it would be a foreign key to a look up table.
Well, that's opinionated... and quite DBA centric. :-) I also come from a database intensive background and I used to do things like having a table for storing the different states. But that's not how things are done in Ruby on Rails, and it's for good reasons. I agree that a text field is not an optimal solution either (I would prefer ActiveHash or ActiveRecord::Enum), but the definition of "better world" may vary based in the experience of the developers. :-) Cheers. -- Ancor González Sosa YaST Team at SUSE Linux GmbH -- To unsubscribe, e-mail: opensuse-web+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-web+owner@opensuse.org
On 01/09/2017 12:43 AM, Ancor Gonzalez Sosa wrote:
On 01/05/2017 06:51 PM, Joshua D. Drake wrote:
However, there is zero constraints to this column. At a minimum we need a check constraint on that column. In a better world it would be a foreign key to a look up table.
Well, that's opinionated... and quite DBA centric. :-) I also come from a database intensive background and I used to do things like having a table for storing the different states. But that's not how things are done in Ruby on Rails, and it's for good reasons.
No it isn't for good reasons. It is for poorly educated reasons. That said, that is *all* I will say on the matter. I am not interested in a platform argument. Sincerely, JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- To unsubscribe, e-mail: opensuse-web+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-web+owner@opensuse.org
participants (3)
-
Ancor Gonzalez Sosa
-
Christian Bruckmayer
-
Joshua D. Drake