Schemaverse
The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself! (by Abstrct)
DummyJSON
DummyJSON.com provides different types of REST Endpoints filled with JSON data which you can use in developing the frontend with your favorite framework and library without worrying about writing a backend. (by Ovi)
Schemaverse | DummyJSON | |
---|---|---|
12 | 21 | |
350 | 1,341 | |
- | - | |
0.0 | 7.2 | |
over 2 years ago | 23 days ago | |
PLpgSQL | EJS | |
PostgreSQL License | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Schemaverse
Posts with mentions or reviews of Schemaverse.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-01.
- Ask HN: Are there any websites for SQL puzzle games?
- Exercises like SQL Murder Mystery?
-
Spacetraders is an online multiplayer game based entirely on APIs. You have to build your own management and UI on your own with any programming language.
If you like programming games and you like SQL you might like the Schemaverse https://schemaverse.com/
-
Linux distro downloads MySQL database password with curl to “fix” security bug
or, alternatively, always treat your database roles as though they can be directly manipulated by the end user, and you'll eliminate an entire class of injection vulnerabilities.
my favorite example of this is SchemaVerse, a game fully implemented in pgsql.
https://schemaverse.com/
-
TIL about the Financial Modeling World Cup, which is essentially the World Cup for Competitive excel users. Participants solve real-life case studies by building financial models in Microsoft Excel. $25,000 prize fund.
Not exactly the same, but it's in the same vein: https://schemaverse.com/
-
Hacker News top posts: Nov 29, 2021
Schemaverse, a space based strategy game to learn PostgreSQL\ (15 comments)
- Schemaverse, a space based strategy game to learn PostgreSQL
-
Schemaverse space based strategy game to learn PostgreSQL
Yeah, he's pretty unstoppable lately but there have been a couple new players starting to improve a lot too.
I'll happily share his secret too. He recognized that it's not about any single metric, it's all about optimizing for the trophies https://github.com/Abstrct/Schemaverse/tree/master/trophies
DummyJSON
Posts with mentions or reviews of DummyJSON.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-04-17.
-
Next Auth boilerplate TS
# next auth secret created by open ssl NEXTAUTH_SECRET=8xvug0aweP+j06DbfOLH9fAU7Bf2nLBLnYHQiFPB9Pc= #local NEXTAUTH_URL="http://localhost:3000" NEXT_PUBLIC_API_URL="https://dummyjson.com" # deveploment NEXTAUTH_DEBUG=true
-
Integrating GraphQL Codegen + React Query + Clerk JWT Tokens
import { useAuth } from "@clerk/nextjs"; import axios, { AxiosError, isAxiosError } from "axios"; interface GraphQLResponse { data: T; errors?: { message: string }[]; } export const useFetchGraphQLData = ( query: string ): ((variables?: TVariables) => Promise) => { const { getToken } = useAuth(); const url = "https://dummyjson.com"; // Replace this with your GraphQL API URL return async (variables?: TVariables) => { const token = await getToken(); try { const response = await axios.post>( url, { query, variables, }, { headers: { "Content-Type": "application/json", Authorization: token ? `Bearer ${token}` : "", }, } ); if (response.data.errors) { throw new Error(response.data.errors[0].message); } return response.data.data; } catch (error) { if (isAxiosError(error)) { const serverError = error as AxiosError>; if (serverError && serverError.response) { const errorMessage = serverError.response.data.errors?.[0]?.message || "Error in GraphQL request"; throw new Error(errorMessage); } } throw error; } }; };
-
looking for resource site for GET-POST practice (html)
DummyJSON is a set of endpoints you can use to try out different requests without using a commercial API which may or may not ban you or limit your access..
-
UI for fake REST API challenge. How would you rate my skills?
This particular interface was built around https://dummyjson.com/ fake REST API.
-
What are some of the simplest web applications and/or API's out there that are popular
https://dummyjson.com has a few good endpoints for building out basic apps.
-
Web service
Buenas te dejo algunas que conozco https://dummyjson.com/ https://www.jsonapi.co/public-api https://github.com/public-apis/public-apis
-
Spacetraders is an online multiplayer game based entirely on APIs. You have to build your own management and UI on your own with any programming language.
I've been using https://dummyjson.com/ to prototype my Web Components, but this probably works better.
-
Create a Shopping Cart with Vuejs and Pinia
I will use DummyJSON, to get dummy/fake JSON data to use as placeholder in development and prototyping, without worrying about writing a backend.
-
Authentication in Nextjs
import { NextPage } from 'next' import { useState } from 'react' import { setCookie } from 'cookies-next' import { useRouter } from 'next/router' import { useAuthStore } from '~/store/useAuthStore' // import our useAuthStore const SignIn: NextPage = (props) => { // set UserInfo state with inital values const [userInfo] = useState({ email: 'kminchelle', password: '0lelplR' }) const router = useRouter() // import state from AuthStore const setUser = useAuthStore((state) => state.setUser) const setAuthentication = useAuthStore((state) => state.setAuthentication) const login = async () => { // do a post call to the auth endpoint const res = await fetch('https://dummyjson.com/auth/login', { method: 'post', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ username: userInfo.email, password: userInfo.password, }), }) // check if response was ok if (!res.ok) { return console.error(res) } // retrieve data from the response const data = await res.json() // check if we have data if (data) { setUser(data) // set data to our user state setAuthentication(true) // set our authentication state to true setCookie('token', data?.token) // set token to the cookie router.push('/') // redirect to home page } } return (
Login
Username (userInfo.email = event.target.value)} required /> Password (userInfo.password = event.target.value)} name="psw" required /> Login -
Serverless API Deployment with AWS Lambda and API Gateway
import json import requests def lambda_handler(event, context): base_url = 'https://dummyjson.com/' product_id = '1' resp = requests.get(url=base_url+'products/'+product_id) if resp.status_code != 200: raise Exception('Failed to retrieve product: '+resp.text) return { 'statusCode': resp.status_code, 'body': resp.json() } Q. what this code does? 1.Imports the necessary modules (JSON and requests). 2.Defines a base URL and a product ID that will be used to construct the API URL. 3.Sends a GET request to the API using the requests library, passing in the full API URL. 4.Checks the response status code to make sure that the request was successful (status code 200). 5.If the response status code is not 200, raise an exception with an error message that includes the response text. 6.If the response status code is 200, return a dictionary containing the response status code and the parsed JSON response body. ●Test the function.