{"id":6626,"date":"2022-02-18T19:44:08","date_gmt":"2022-02-18T19:44:08","guid":{"rendered":"https:\/\/contentlab.com\/?p=6626"},"modified":"2022-02-24T19:17:11","modified_gmt":"2022-02-24T19:17:11","slug":"using-a-database-ready-hackathon-starter-kit-with-cockroachdb","status":"publish","type":"post","link":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/","title":{"rendered":"Using a Database-Ready Hackathon Starter Kit with CockroachDB"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6626\" class=\"elementor elementor-6626\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7e393c9f elementor-section-boxed elementor-section-height-default elementor-section-height-default qodef-elementor-content-no\" data-id=\"7e393c9f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-592430a4\" data-id=\"592430a4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7021941f elementor-widget elementor-widget-text-editor\" data-id=\"7021941f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 30-04-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><!-- wp:paragraph --><\/p>\n<p>Getting projects started can be challenging. Sometimes half our battle is just setting up the project to run. Hackathon and game jam projects take a lot of time, so preparing and getting our apps up and running can make a huge difference in our progress and polish.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>Inspired by Sahat\u2019s <a href=\"https:\/\/github.com\/sahat\/hackathon-starter\">Hackathon Starter<\/a> project, we built a project for Node.js. We designed the project for ideas that can benefit from having a queryable database during hackathons. Our hackathon starter kit gets you started by providing both a React frontend app and a backend that can easily store and access your data on a CockroachDB. With this setup, you can jump right into your project\u2019s ideation and creation.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>This article walks through our <a href=\"https:\/\/github.com\/instafluff\/DBHackathonStarterKit\">DBHackathon Starter Kit<\/a>, each component of its code, and how to build and run it.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading {\"level\":1} --><\/p>\n<h1 id=\"a-hackathon-kit-for-databases\">A Hackathon Kit for Databases<\/h1>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>Data has become a critical piece that drives apps. For example, a location app needs a searchable list of countries and locations, and apps that allow account creation need to store and look up users. However, configuring and iterating on a data-driven application can still be a challenge to get started and often confusing to dig through the documentation and examples.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>This starter kit\u2019s goal is to help minimize that ramp-up time for hackathon developers working with JavaScript. The kit makes it easy to import and work with the project\u2019s data through CockroachDB.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading --><\/p>\n<h2 id=\"cockroachdb-and-cockroachcloud-1\">CockroachDB and <a>CockroachCloud<\/a>&nbsp;<\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p><a href=\"https:\/\/www.cockroachlabs.com\/get-started-cockroachdb\/\">CockroachDB<\/a> is a free, highly scalable SQL database solution that we can deploy on our servers. <a href=\"https:\/\/www.cockroachlabs.com\/docs\/cockroachcloud\/free-faqs\">CockroachCloud<\/a> is the cloud version that Cockroach Labs deploys and manages, so we can just connect to and use it.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>After importing data into the CockroachDB, we can use existing SQL tools to sift through the data and run queries on it directly.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>The Cockroach Labs team currently provides a free beta CockroachCloud tier to which the starter kit connects. You can use the tier for proofs-of-concept and smaller programs. The account is free forever, so sign up <a href=\"https:\/\/cockroachlabs.cloud\/signup\">on the CockroachCloud website<\/a> to use CockroachCloud with the starter kit.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading --><\/p>\n<h2 id=\"what-the-starter-kit-does-out-of-the-box\">What the Starter Kit Does Out of the Box<\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>The starter kit\u2019s code does much of the initial work for us. The code uses Sequelize.js to connect to CockroachDB and provides functions to import, add, update, and remove data with examples in a test() function and a \/test endpoint. We organized the kit so that it\u2019s easy to define a custom DB model and iterate on it.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>We can quickly load data from CSV or JSON objects into the CockroachDB then query and use the data. We also created a server and client-side <a href=\"https:\/\/contentlab.com\/how-to-build-a-sales-dashboard-with-react\/\">React<\/a> app that we can turn into an easily demonstrable app. We can build it for release by running npm build in the app folder.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading --><\/p>\n<h2 id=\"primary-technologies-and-project-structure\">Primary Technologies and Project Structure<\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>The main tech stack this kit relies on includes:<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:list --><\/p>\n<ul>\n<li><a href=\"http:\/\/nodejs.org\/\">Node.js<\/a>, the project\u2019s main server<\/li>\n<li><a href=\"https:\/\/expressjs.com\/\">Express<\/a>, the backend APIs<\/li>\n<li><a href=\"https:\/\/reactjs.org\/\">React.js<\/a>, the frontend app<\/li>\n<li><a href=\"https:\/\/www.cockroachlabs.com\/\">CockroachDB and CockroachCloud<\/a>, for storing the data<\/li>\n<li><a href=\"https:\/\/sequelize.org\/\">Sequelize<\/a>, for object-relational mapping (ORM) to connect to the CockroachDB<\/li>\n<\/ul>\n<p><!-- \/wp:list --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>We organized the project to keep the DB model and server code at the top level and the frontend React app inside the app folder.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>Let\u2019s go through the contents of each folder and index.js:<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:list --><\/p>\n<ul>\n<li><strong>app<\/strong>: Contains the entire frontend application. You can edit src\/App.js to update the starter client app, which provides an interface to control the server and add data to the set.<\/li>\n<li><strong>data<\/strong>: Sample CSV datasets that the example DB models use and can be easily imported into the database. (Source: <a href=\"https:\/\/datahub.io\/core\/language-codes\">ISO Language Codes Dataset<\/a>, <a href=\"https:\/\/datahub.io\/core\/country-list\">Country List<\/a>)<\/li>\n<li><strong>db<\/strong>: Code for defining your DB model. The DB_*.js files are model examples that demonstrate how to import data into CockroachDB easily. You can use these examples as reference templates for new projects.<\/li>\n<li><strong>utils<\/strong>: Some useful basic utility functions.<\/li>\n<li><strong>index.js<\/strong>: The main server code with the DB model instance and routes. It needs editing.<\/li>\n<\/ul>\n<p><!-- \/wp:list --><\/p>\n<p><!-- wp:heading {\"level\":1} --><\/p>\n<h1 id=\"getting-started\">Getting Started<\/h1>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>To use this starter kit, first, clone or download the <a href=\"https:\/\/github.com\/instafluff\/MLHackathonStarterKit\">repository<\/a>.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>Next, open the project directory inside a prompt or terminal and run npm install to set up its dependencies.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>Then, set up the CockroachDB and CockroachCloud connection by creating a .env file at the project root. Add environment variables to the file based on the connection string and password.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>If you haven\u2019t set up CockroachDB yet, you can sign up for CockroachCloud for free. Or, you can download and install CockroachDB Core if you wish to run the project from a local database.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>For CockroachCloud, download the cc-ca.crt file to your project folder. When you\u2019ve completed this part, you should have a connection URL that looks like this:<\/p>\n<p><!-- \/wp:paragraph --><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac06342 elementor-widget elementor-widget-code-highlight\" data-id=\"ac06342\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>  postgres:\/\/instafluff:z6NShLj3ux@free-tier4.aws-us-west-2.cockroachlabs.cloud:26257\r\n  \/defaultdb?sslmode=require&options=--cluster=instafluff-288\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-28f2ef1 elementor-widget elementor-widget-text-editor\" data-id=\"28f2ef1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #00b2a9; font-size: 32px;\">Example .env File<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df9e7b5 elementor-widget elementor-widget-code-highlight\" data-id=\"df9e7b5\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>  COCKROACHDB_USER=instafluff\r\n  COCKROACHDB_PASS=z6NShLj3ux\r\n  COCKROACHDB_HOST=free-tier4.aws-us-west-2.cockroachlabs.cloud\r\n  COCKROACHDB_PORT=26257\r\n  COCKROACHDB_DATABASE=instafluff-288.defaultdb\r\n  COCKROACHDB_CERTIFICATE=cc-ca.crt\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c06e4a elementor-widget elementor-widget-text-editor\" data-id=\"1c06e4a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Finally, we run node index.js to run the server.<\/p>\n<p>In another prompt or terminal window in the project directory, run cd app, and npm start to start the React app. Then you see the client-side app, and you can interact with the buttons to run the test() function and search languages by language code.<\/p>\n<p>\u00a0<\/p>\n<h2 id=\"language-code-search\">Language Code Search<\/h2>\n<p>Let\u2019s take a quick detour to look at the Language Code Search example to better understand how the starter kit works.<\/p>\n<p>When we open db\/DB_Languages.js, we see the code for this model\u2019s column definitions and functions. The model initializes by loading from a CSV file containing language codes and their corresponding names in English. Then, the test function contains examples of how to remove, update, and query the data.<\/p>\n<p>Because the data persists inside the CockroachDB through restarts of the server, we can update any entry and it will stay updated in the database. We can also search for languages using the two-letter language code using the React app by typing the code into the Search text box and clicking the\u00a0<span style=\"font-weight: bolder;\">Run<\/span>\u00a0button.<\/p>\n<p>You can try looking up different languages by code such as\u00a0<span style=\"font-weight: bolder;\">fr<\/span>,\u00a0<span style=\"font-weight: bolder;\">es<\/span>, or\u00a0<span style=\"font-weight: bolder;\">de<\/span>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45e64ab elementor-widget elementor-widget-image\" data-id=\"45e64ab\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 30-04-2024 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"534\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-1024x683.png\" class=\"attachment-large size-large wp-image-6627\" alt=\"\" srcset=\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-1024x683.png 1024w, https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-300x200.png 300w, https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-768x513.png 768w, https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-1536x1025.png 1536w, https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1-1320x881.png 1320w, https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/image1.png 1912w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f77a584 elementor-widget elementor-widget-text-editor\" data-id=\"f77a584\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h1 id=\"what-s-next\">What\u2019s Next?<\/h1>\n<p>The hackathon starter kit helps build Node.js apps based on an example database app. The kit provides the basics needed to understand better how to create a data-driven app quickly.<\/p>\n<p>Now that you are ready with this starter kit, how about building something fun?<\/p>\n<p>We included an example dataset for a list of countries and their two-letter codes in\u00a0<span style=\"font-weight: bolder;\">DB_Countries.js<\/span>\u00a0as another reference for creating a DB model.<\/p>\n<p>You can try some of these other ideas:<\/p>\n<ul style=\"font-size: 20px; background-color: #ffffff;\">\n<li style=\"font-size: 20px;\">World Cities lookup for latitude\/longitude on a map<\/li>\n<li style=\"font-size: 20px;\">Historical weather data lookup and analysis<\/li>\n<li style=\"font-size: 20px;\">Movies titles and reviews<\/li>\n<li style=\"font-size: 20px;\">Animal information lookup app<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>If you make improvements to the\u00a0<a href=\"https:\/\/github.com\/instafluff\/DBHackathonStarterKit\">GitHub repository<\/a>, please consider submitting a pull request so other developers benefit from your changes.<\/p>\n<p>Happy learning!<\/p>\n<p>To start on your next project,\u00a0<a href=\"https:\/\/cockroachlabs.cloud\/signup\">sign up for Cockroach Cloud<\/a>\u00a0and try CockroachDB for yourself.<\/p>\n<p>\u00a0<\/p>\n<p><br \/><br \/><em>If you\u2019re interested in developing expert technical content that performs, <a href=\"https:\/\/contentlab.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">let\u2019s have a conversation<\/a> today.<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Getting projects started can be challenging. Sometimes half our battle is just setting up the project to run. Hackathon and game jam projects take a lot of time, so preparing and getting our apps up and running can make a huge difference in our progress and polish. Inspired by Sahat\u2019s Hackathon Starter project, we built [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":6772,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[278,18,240],"tags":[272,271,269],"hashtags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab\" \/>\n<meta property=\"og:description\" content=\"Getting projects started can be challenging. Sometimes half our battle is just setting up the project to run. Hackathon and game jam projects take a lot of time, so preparing and getting our apps up and running can make a huge difference in our progress and polish. Inspired by Sahat\u2019s Hackathon Starter project, we built [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Technical Content Marketing | ContentLab\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-18T19:44:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-24T19:17:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1746\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ContentLab\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:site\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ContentLab\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\"},\"author\":{\"name\":\"ContentLab\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\"},\"headline\":\"Using a Database-Ready Hackathon Starter Kit with CockroachDB\",\"datePublished\":\"2022-02-18T19:44:08+00:00\",\"dateModified\":\"2022-02-24T19:17:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\"},\"wordCount\":1163,\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png\",\"keywords\":[\"JavaScript\",\"Node.js\",\"React\"],\"articleSection\":[\"Hands-on Tutorial\",\"Portfolio\",\"Web\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\",\"url\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\",\"name\":\"Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png\",\"datePublished\":\"2022-02-18T19:44:08+00:00\",\"dateModified\":\"2022-02-24T19:17:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png\",\"width\":1746,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/contentlab.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using a Database-Ready Hackathon Starter Kit with CockroachDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/contentlab.com\/#website\",\"url\":\"https:\/\/contentlab.com\/\",\"name\":\"Technical Content Marketing | ContentLab\",\"description\":\"Technical Content Marketing Done Right.\",\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/contentlab.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/contentlab.com\/#organization\",\"name\":\"ContentLab.io\",\"url\":\"https:\/\/contentlab.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"width\":768,\"height\":768,\"caption\":\"ContentLab.io\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/ContentLabIO\",\"https:\/\/www.linkedin.com\/company\/17893315\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\",\"name\":\"ContentLab\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"caption\":\"ContentLab\"},\"description\":\"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.\",\"sameAs\":[\"https:\/\/contentlab.op\"],\"url\":\"https:\/\/contentlab.com\/author\/contentlab\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab","og_description":"Getting projects started can be challenging. Sometimes half our battle is just setting up the project to run. Hackathon and game jam projects take a lot of time, so preparing and getting our apps up and running can make a huge difference in our progress and polish. Inspired by Sahat\u2019s Hackathon Starter project, we built [&hellip;]","og_url":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/","og_site_name":"Technical Content Marketing | ContentLab","article_published_time":"2022-02-18T19:44:08+00:00","article_modified_time":"2022-02-24T19:17:11+00:00","og_image":[{"width":1746,"height":530,"url":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","type":"image\/png"}],"author":"ContentLab","twitter_card":"summary_large_image","twitter_creator":"@ContentLabIO","twitter_site":"@ContentLabIO","twitter_misc":{"Written by":"ContentLab","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#article","isPartOf":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/"},"author":{"name":"ContentLab","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532"},"headline":"Using a Database-Ready Hackathon Starter Kit with CockroachDB","datePublished":"2022-02-18T19:44:08+00:00","dateModified":"2022-02-24T19:17:11+00:00","mainEntityOfPage":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/"},"wordCount":1163,"publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"image":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","keywords":["JavaScript","Node.js","React"],"articleSection":["Hands-on Tutorial","Portfolio","Web"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/","url":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/","name":"Using a Database-Ready Hackathon Starter Kit with CockroachDB &#183; Technical Content Marketing | ContentLab","isPartOf":{"@id":"https:\/\/contentlab.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage"},"image":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","datePublished":"2022-02-18T19:44:08+00:00","dateModified":"2022-02-24T19:17:11+00:00","breadcrumb":{"@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#primaryimage","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","width":1746,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/contentlab.com\/using-a-database-ready-hackathon-starter-kit-with-cockroachdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/contentlab.com\/"},{"@type":"ListItem","position":2,"name":"Using a Database-Ready Hackathon Starter Kit with CockroachDB"}]},{"@type":"WebSite","@id":"https:\/\/contentlab.com\/#website","url":"https:\/\/contentlab.com\/","name":"Technical Content Marketing | ContentLab","description":"Technical Content Marketing Done Right.","publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contentlab.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/contentlab.com\/#organization","name":"ContentLab.io","url":"https:\/\/contentlab.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","width":768,"height":768,"caption":"ContentLab.io"},"image":{"@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ContentLabIO","https:\/\/www.linkedin.com\/company\/17893315\/"]},{"@type":"Person","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532","name":"ContentLab","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","caption":"ContentLab"},"description":"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.","sameAs":["https:\/\/contentlab.op"],"url":"https:\/\/contentlab.com\/author\/contentlab\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/contentlab.com\/wp-content\/uploads\/2022\/02\/40.png","_links":{"self":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/6626"}],"collection":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/comments?post=6626"}],"version-history":[{"count":14,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/6626\/revisions"}],"predecessor-version":[{"id":6810,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/6626\/revisions\/6810"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media\/6772"}],"wp:attachment":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media?parent=6626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/categories?post=6626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/tags?post=6626"},{"taxonomy":"hashtags","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/hashtags?post=6626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}