564
edits
User:Ddahl: Difference between revisions
Jump to navigation
Jump to search
→a list of Places code pain points. Mostly questions about perceived complexity in the places codebase
| Line 6: | Line 6: | ||
* Schema warts | * Schema warts | ||
** naming conventions | |||
sqlite> .schema moz_bookmarks | sqlite> .schema moz_bookmarks | ||
| Line 28: | Line 30: | ||
This is a non-convention in database schema design. | This is a non-convention in database schema design. | ||
** a row from moz_bookmarks: | |||
25792|2||25789|2|All Bookmarks|||1232646170341394|1232646170342806 | |||
Why is a folder in the places UI kept as a record in the bookmarks table? If it is not really a bookmark, do not store it in the bookmarks table. the reason databases have various tables is usually so that you can keep like items together. | |||