[{"_1":2,"_155":-5,"_156":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_134":135},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":17},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":11,"_131":-5,"_132":133},"canonicalUrl","https://hub.docker.com/r/bbalaran/database/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","bbalaran","reponame","database","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":17,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2016-02-03T02:58:11.342555Z","description","Thesis database","is_private","last_updated","2016-02-11T22:49:46.392829Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.distribution.manifest.v1+prettyjws","name","pull_count",1006,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# database\n<<<<<<< 682da9f7a2ec82ed02470fe36d7dc628d96ddb14\n\nschema: halcyon\n```Shell\n\\d+ halcyon\n```\n#### Tables\n \nhalcyon.\"Test_Hourly_Watches\"\n* repo_id INTEGER, \n* repo_name TEXT, \n* star_count SMALLINT, \n* date DATE, _{(date is of form YYYY-MM-DD)\n* hour SMALLINT\n\n\n\n\nhalcyon.\"Test_Repos\"\n* id INTEGER, \n* repo_name TEXT, _{(repo_name is of form login_of_owner/name_of_repository. So owner name can be generated from the field)\n* description TEXT, \n* language CHARACTER VARYING(40), \n* num_stars INTEGER, \n* org INTEGER _{(org is 0 if there is no org associated with repo)\n \n\n\n\n\n\n#### Queries\n\n```SQL\nselect * from halcyon.\"Test_Hourly_Watches\" limit 5\n```\n```SQL\nselect * from halcyon.\"Test_Repos\" limit 5\n```\n```SQL\nselect repo_id, repo_name, language, num_stars, count(*) AS stars from halcyon.\"Test_Hourly_Watches\" \nInner Join halcyon.\"Test_Repos\" On repo_id = id\nwhere num_stars > 0 \n AND date >= current_date - 47\n AND date <= current_date - 40\ngroup by repo_id, repo_name, language, num_stars order by num_stars desc\n```\n\n#### Docker Container\n\n\nSQL database container\n\nBuild Image: \n\n```bash\ndocker build -t custom_psql .\n```\n\nRun Container: \n```bash\ndocker run -d --name custom_psql_running -p 5432:5432 custom_psql\n```\n\nExec into container: docker \n```bash\nexec -it custom_psql_running psql -U postgres\n```\n\n```bash\ndocker run -it --link custom_psql:postgres --rm postgres sh -c 'exec psql -h \"$POSTGRES_PORT_5432_TCP_ADDR\" -p \"$POSTGRES_PORT_5432_TCP_PORT\" -U postgres'\n```\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",118065915,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",598461,"full_size",118002181,"id",1983463,"images",[97],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":103,"_109":103,"_110":-5,"_111":112,"_59":62,"_113":-5},"architecture","amd64","digest","sha256:81aed380d461aa505402744073bbe60b12aab162ec16d06a73d172af652cf7c0","features","","last_pulled","2026-09-23T22:45:42.048845469Z","last_pushed","2016-02-11T22:49:46Z","os","os_features","os_version","size",118002597,"variant","2016-02-11T22:49:45.935924Z","last_updater","last_updater_username","media_type","latest","repository",510261,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":136,"_143":144,"_132":153,"_154":11},{"_36":137,"_38":138,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":139,"_53":31,"_28":29,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":140,"_75":17,"_76":142,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":141},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_145":60,"_146":-5,"_147":-5,"_148":149},"count","next","previous","results",[150],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":151,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[152],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":103,"_109":103,"_110":-5,"_111":112,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]}}}

bbalaran/database

Tags for bbalaran/database