日曆重複/重複事件 - 最佳存儲方法 - Calendar Recurring/Repeating Events - Best Storage Method
問題:
I am building a custom events system, and if you have a repeating event that looks like this:我正在構建一個自定義事件系統,如果您有一個如下所示的重複事件:
Event A repeats every 4 days starting on March 3, 2011事件 A 從 2011 年 3 月 3 日開始每 4 天重複一次
or或者
Event B repeats every 2 weeks on Tuesday starting on March 1, 2011事件 B 從 2011 年 3 月 1 日開始,每兩週重複一次
How can I store that in a Database in a way that would make it simple to lookup.如何以一種易於查找的方式將其存儲在數據庫中。 I don't want performance issues if there are a large number of events, and I have to go through each and every one when rendering the calendar.如果有大量事件,我不希望出現性能問題,並且在渲染日曆時我必須逐一檢查。
解決方案:
參考一: http://stackoom.com/question/LkUw參考二: Calendar Recurring/Repeating Events - Best Storage Method
「其他文章」
- 用 JavaScript 計算昨天的日期 - Calculate the date yesterday in JavaScript
- 允許保留 2 位小數 - Allow 2 decimal places in
- 在 Android 上防止屏幕旋轉 - Prevent screen rotation on Android
- 如何更新 RecyclerView 適配器數據 - How to update RecyclerView Adapter Data
- 日曆重複/重複事件 - 最佳存儲方法 - Calendar Recurring/Repeating Events - Best Storage Method
- (13:權限被拒絕)連接到上游時:[nginx] - (13: Permission denied) while connecting to upstream:[nginx]
- 如何使用 git 檢查 GitHub 拉取請求? - How can I check out a GitHub pull request with git?
- 正則表達式:刪除包含“幫助”等的行 - Regex: Remove lines containing “help”, etc
- >>>和>>之間的區別 - Difference between >>> and >>
- JavaScript 中反引號 (`) 的用法 - Usage of the backtick character (`) in JavaScript
- C 模板typedef - C template typedef
- 僅添加非空白更改 - Add only non-whitespace changes
- Python中exit()和sys.exit()之間的區別 - Difference between exit() and sys.exit() in Python
- Git:僅列出“未跟蹤”的文件(還有自定義命令) - Git: list only “untracked” files (also, custom commands)
- 谷歌使用什麼數據庫? - What database does Google use?
- 在CLR中投放與使用'as'關鍵字 - Casting vs using the 'as' keyword in the CLR
- 值對的 Java 集合? (元組?) - A Java collection of value pairs? (tuples?)
- 'git 責備' 有什麼作用? - What does 'git blame' do?
- 螞蟻警吿:“'includeantruntime'未設置” - ant warning: “'includeantruntime' was not set”
- 如何在不等待的情況下安全地調用 C# 中的異步方法 - How to safely call an async method in C# without await