Skip to content
This repository was archived by the owner on Feb 18, 2025. It is now read-only.

Sqlite support -- without sqlite#97

Merged
shlomi-noach merged 64 commits intomasterfrom
sqlite-support
Mar 15, 2017
Merged

Sqlite support -- without sqlite#97
shlomi-noach merged 64 commits intomasterfrom
sqlite-support

Conversation

@shlomi-noach
Copy link
Collaborator

@shlomi-noach shlomi-noach commented Mar 12, 2017

This is one-step-down from #63 ; it's all the same: full support for sqlite backend, along with schema changes, query changes. However in this PR sqlutils.go doesn't actually import _ "github.com/mattn/go-sqlite3.

(Do note sqlite3 is included in vendor/ in this PR) sqlite3 removed from vendor/ until I figure out what's the best way to incorporate it (maybe just binary? Future PR to tell)

Reason is still ongoing thoughts about the compilation process. sqlite3 is heavyweight to compile. While go build -i does the job reasonably well, there is a once-in-a-while long compilation time. I'll be looking into using sqlite3 as .so shared file via go1.7.

So in this PR everything supports sqlite, but sqlite is not strictly included and is effectively disabled.

Shlomi Noach added 30 commits December 25, 2016 14:40
@shlomi-noach shlomi-noach temporarily deployed to production March 12, 2017 11:32 Inactive
@shlomi-noach shlomi-noach deployed to production/github-mysqlutil March 12, 2017 12:13 Active
@shlomi-noach shlomi-noach deployed to production/github-mysqlutil March 15, 2017 05:53 Active
@shlomi-noach shlomi-noach deployed to production/github-mysqlutil March 15, 2017 09:40 Active
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:41 Inactive
@shlomi-noach shlomi-noach deployed to production/hubot-slack March 15, 2017 09:42 Active
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:42 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:42 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:42 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:43 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:43 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:43 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:43 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:44 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:44 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:44 Inactive
@shlomi-noach shlomi-noach temporarily deployed to production March 15, 2017 09:45 Inactive
@shlomi-noach
Copy link
Collaborator Author

This branch, and its predecessor sqlite, have been running in production for almost a month. I'm going to merge this.

This PR includes rehaul of indexes on all tables. Users of orchestrator: first time you will run orchestrator where this branch is merged, you will notice a single long-db-deployment operation.

@shlomi-noach shlomi-noach merged commit 6f6c800 into master Mar 15, 2017
@shlomi-noach shlomi-noach deleted the sqlite-support branch March 15, 2017 11:44
@shlomi-noach shlomi-noach mentioned this pull request Mar 15, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants