{"action":"created","issue":{"url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/2546","labels_url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/2546/labels{/name}","comments_url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/2546/comments","events_url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/2546/events","html_url":"https://github.com/numixproject/numix-icon-theme-circle/issues/2546","id":106391726,"number":2546,"title":"Are we doing this efficiently?","user":{"login":"Foggalong","id":5920259,"avatar_url":"https://avatars.githubusercontent.com/u/5920259?v=3","gravatar_id":"","url":"https://api.github.com/users/Foggalong","html_url":"https://github.com/Foggalong","followers_url":"https://api.github.com/users/Foggalong/followers","following_url":"https://api.github.com/users/Foggalong/following{/other_user}","gists_url":"https://api.github.com/users/Foggalong/gists{/gist_id}","starred_url":"https://api.github.com/users/Foggalong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Foggalong/subscriptions","organizations_url":"https://api.github.com/users/Foggalong/orgs","repos_url":"https://api.github.com/users/Foggalong/repos","events_url":"https://api.github.com/users/Foggalong/events{/privacy}","received_events_url":"https://api.github.com/users/Foggalong/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/labels/question","name":"question","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-09-14T17:34:24Z","updated_at":"2015-09-16T08:27:46Z","closed_at":null,"body":"I want to also start a discussion about how we develop the icon themes for different platforms. Currently the setup is worked such that icons are added to each platform individually and if the icons are used on multiple platforms then they will eventually be move across. This process is slow and often leaves icons being left behind.\r\n\r\nI envisage a numixproject/numix-circle which contains all the raw icon files with easy to recognise names and then a build script which generates the content for Linux, Android, etc. It would mean that rather than contributing an icon to the Linux version specifically people would be contributing an icon for Circle in general.\r\n\r\nWe could also use this as an opportunity to fix #2430 by renaming this repo to the new one and creating a new repo for numix-icon-theme-circle.\r\n\r\nI don't know if this is something people would be on board with doing and any feedback would be appreciated.\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/26678530-are-we-doing-this-efficiently?utm_campaign=plugin&utm_content=tracker%2F514195&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F514195&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/comments/140668210","html_url":"https://github.com/numixproject/numix-icon-theme-circle/issues/2546#issuecomment-140668210","issue_url":"https://api.github.com/repos/numixproject/numix-icon-theme-circle/issues/2546","id":140668210,"user":{"login":"ChuckDaniels87","id":8478202,"avatar_url":"https://avatars.githubusercontent.com/u/8478202?v=3","gravatar_id":"","url":"https://api.github.com/users/ChuckDaniels87","html_url":"https://github.com/ChuckDaniels87","followers_url":"https://api.github.com/users/ChuckDaniels87/followers","following_url":"https://api.github.com/users/ChuckDaniels87/following{/other_user}","gists_url":"https://api.github.com/users/ChuckDaniels87/gists{/gist_id}","starred_url":"https://api.github.com/users/ChuckDaniels87/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChuckDaniels87/subscriptions","organizations_url":"https://api.github.com/users/ChuckDaniels87/orgs","repos_url":"https://api.github.com/users/ChuckDaniels87/repos","events_url":"https://api.github.com/users/ChuckDaniels87/events{/privacy}","received_events_url":"https://api.github.com/users/ChuckDaniels87/received_events","type":"User","site_admin":false},"created_at":"2015-09-16T08:27:46Z","updated_at":"2015-09-16T08:27:46Z","body":"I've been running some tests with **SQLite**, it works like a charm to keep a _db_ of icons and requests, including hardcoded icons tracking and mixing OS (*Android and GNU/Linux distros*). It is lighweight, really simple to use, omnipresent (it comes installed in almost any distro and _Android_) easily scriptable and there are nice graphical tools to manipulate it (p.e. **sqliteman**).\r\n\r\nI've found also some drawbacks, mostly with git version control. Databases are binary files, impact in git repository is obvious, mostly in log files. There are common solutions:\r\n* Do not store database in the repo (kinda obvious). Store it externally.\r\n* Store _dumped database_ in the repository. You can easily dump into text file with SQLite needed information to recreate database and later recreate database from that [[1]](http://stackoverflow.com/a/550988)[[2]](http://stackoverflow.com/questions/13271643/git-hook-for-diff-sqlite-table)[[3]](https://ongardie.net/blog/sqlite-in-git/):\r\n    1. ```sqlite3 .dump > icons.txt```\r\n    2. ```sqlite3 icons.db < icons.txt```\r\n* Do not use SQLite directly, use _csv_ plain files\r\n\r\nWell, these are just some thoughts. I got not much experience managing _DBs_ if someone knows more about this please correct my post. :wink:\r\n"}}