DummyJSON
Schemaverse
DummyJSON | Schemaverse | |
---|---|---|
21 | 12 | |
1,350 | 350 | |
- | - | |
7.2 | 0.0 | |
about 1 month ago | almost 3 years ago | |
EJS | PLpgSQL | |
GNU General Public License v3.0 or later | PostgreSQL License |
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.
DummyJSON
-
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.
Schemaverse
- 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
What are some alternatives?
wundergraph-demo - This Repository demonstrates how to combine 7 APIs (4 Apollo Federation SubGraphs, 1 REST, 1 standalone GraphQL, 1 Mock) into one unified GraphQL API which is then securely exposed as a JSON API to a NextJS Frontend.
sqlraytracer - Everyone writes a Raytracer eventually. This is mine.
fake-store-api - FakeStoreAPI is a free online REST API that provides you fake e-commerce JSON data
Game-Of-Life-T-SQL
dummy-products-api - An api to fetch dummy e-commerce product :tshirt: :dress: :jeans: :womans_clothes: JSON data with placeholder images.
BFree - BFree: Enabling Battery-free Sensor Prototyping with Python
datoji - A tiny JSON storage service. Create, Read, Update, Delete and Search JSON data.
docker-schemaverse - Docker container for running Schemaverse Schemaverse for Docker
json-server - Get a full fake REST API with zero coding in less than 30 seconds (seriously)
Kavita - Kavita is a fast, feature rich, cross platform reading server. Built with the goal of being a full solution for all your reading needs. Setup your own server and share your reading collection with your friends and family.
autoserver - Create a full-featured REST/GraphQL API from a configuration file
Space-mining-poker