Jeremy Purser jeremypurser

software engineer

jeremypurser / august2020vscode.json

Last active November 15, 2020 23:01

	{
	"editor.lightbulb.enabled": true,
	"editor.parameterHints.enabled": true,
	"editor.renderWhitespace": "none",
	"editor.snippetSuggestions": "inline",
	"editor.cursorBlinking": "solid",
	"editor.tabSize": 2,
	"editor.lineNumbers": "relative",
	"editor.wordWrap": "on",
	"emmet.triggerExpansionOnTab": true,

jeremypurser / vscodesettings.json

Last active November 29, 2019 19:41

	{
	"editor.lightbulb.enabled": false,
	"editor.parameterHints.enabled": true,
	"editor.renderWhitespace": "all",
	"editor.snippetSuggestions": "none",
	"editor.tabSize": 2,
	"editor.wordWrap": "on",
	"emmet.triggerExpansionOnTab": true,
	"files.trimTrailingWhitespace": true,
	"javascript.suggest.enabled": true,

jeremypurser / sdc_db_queries

Last active September 19, 2019 03:16

	POSTGRES

	API
	CREATE
	Query: insert into houses (imgurl, location, type, title, cost, stars, reviewcount)
	values ('sdcimg-204.jpg', 'Brooklyn', 'apartment', 'Williamsburg Condo', 300, 2, 200);
	Time: 10.658 ms
	Time: 7.829 ms
	< -- after tuning, index column -- >
	Time: 31.365 ms

jeremypurser / sdc_db_queries

Created September 17, 2019 03:15

	POSTGRES

	CREATE
	Query: insert into houses (imgurl, location, type, title, cost, stars, reviewcount) values ('sdcimg-204.jpg', 'Brooklyn', 'apartment', 'Williamsburg Condo', 300, 2, 200);
	Time: 10.658 ms
	Time: 7.829 ms
	< -- after tuning, index column -- >
	Time: 31.365 ms
	Time: 8.616 ms
	< -- set table to unlogged -- >

jeremypurser / fec_sample_api_output.json

Created August 23, 2019 23:01

Sample output from GET /movies