SQL CRUD Query Generator - Online SELECT INSERT UPDATE DELETE
Fill in a table name and columns, and the tool writes the correct SQL INSERT, UPDATE, DELETE, and SELECT queries. For quick scaffolding.
UD5 Toolkit
A comprehensive guide to HTTP request methods β GET, POST, PUT, DELETE, PATCH, HEAD, OPTIONS, TRACE, and CONNECT. Learn when to use each method, their properties, and RESTful API best practices.
The GET method is used to retrieve data from a specified resource. It is the most common HTTP method and forms the backbone of data retrieval on the web. GET requests should only retrieve data and have no other side effects β they are considered safe and idempotent.
GET /api/users/123 HTTP/1.1
Host: api.example.com
Accept: application/json
Authorization: Bearer token_here
Every HTTP response includes a status code. Here are the most commonly used codes you'll encounter when working with RESTful APIs.
| 200 | OK β Request succeeded |
| 201 | Created β Resource created |
| 202 | Accepted β Processing |
| 204 | No Content β Success, no body |
| 301 | Moved Permanently |
| 302 | Found β Temporary redirect |
| 304 | Not Modified β Use cache |
| 307 | Temporary Redirect (preserve method) |
| 400 | Bad Request β Malformed syntax |
| 401 | Unauthorized β Authentication required |
| 403 | Forbidden β No permission |
| 404 | Not Found β Resource doesn't exist |
| 405 | Method Not Allowed |
| 409 | Conflict β State conflict |
| 422 | Unprocessable Entity |
| 429 | Too Many Requests β Rate limit |
| 500 | Internal Server Error |
| 502 | Bad Gateway |
| 503 | Service Unavailable |
| 504 | Gateway Timeout |
| Action | Method | Endpoint | Example | Response |
|---|---|---|---|---|
| List all | GET | /users |
/api/users |
200 + array |
| Get one | GET | /users/{id} |
/api/users/42 |
200 + object |
| Create | POST | /users |
/api/users |
201 + object |
| Full update | PUT | /users/{id} |
/api/users/42 |
200 / 204 |
| Partial update | PATCH | /users/{id} |
/api/users/42 |
200 / 204 |
| Delete | DELETE | /users/{id} |
/api/users/42 |
200 / 204 |
| Nested resource | GET | /users/{id}/posts |
/api/users/42/posts |
200 + array |
/api/resource
Read data? β GET
Create new? β POST
Replace all? β PUT
Change part? β PATCH
Remove? β DELETE
Common questions about HTTP methods, RESTful API design, and best practices.
POST /users β server assigns ID and returns /users/123). Use PUT when the client specifies the exact URI (e.g., PUT /users/123 β the client knows the ID). POST is for creating subordinate resources where the server controls the naming; PUT is for upsert operations where the client controls the resource identifier.
Access-Control-Allow-Methods and Access-Control-Allow-Origin indicating what's permitted.
HttpOnly cookie flag. Most modern web servers (Apache, Nginx, IIS) disable TRACE by default for security reasons.
/api/search is appropriate. Some APIs use POST /api/users/search with a JSON body containing filter criteria. While GET is ideal for simple queries, POST is acceptable for complex search operations.
Use /users not /user. Consistency makes your API predictable and intuitive for developers.
Prefix endpoints with /v1/ or use header-based versioning to avoid breaking existing clients.
Always return the appropriate HTTP status code. Don't return 200 OK with an error message in the body.
Set Content-Type, Accept, and caching headers. Use Location header for 201 responses.
Fill in a table name and columns, and the tool writes the correct SQL INSERT, UPDATE, DELETE, and SELECT queries. For quick scaffolding.
Search and copy HTML entities for arrows, math, currency, and symbols. See the glyph and code. Fast reference.
Select text and see the Selection object properties. Create ranges programmatically. Understand how richβtext editors work.
Interactive cheatsheet for JavaScript regular expressions with live examples. Click any token to see its explanation and test it on sample text immediately.
Generate strong random strings for API tokens, session secrets, or encryption keys. Uses crypto.getRandomValues().
Create a Blob from text or a file and generate a temporary URL for it. Understand the Blob API. Dev demo.
Select an activity, enter your weight and duration, and see the estimated calories burned. Based on MET values.
Sortable list of cooking oils with smoke points and best uses. Choose the right fat for the right heat.
Easily compute posterior probabilities given prior, likelihood, and marginal likelihood. Visual diagram. All local.
Guided breathing exercises with animated circle for inhale/hold/exhale. Includes box breathing, 4-7-8, and resonant breathing patterns. Customizable intervals.
Virtual paper fortune teller. Pick a color, count, and reveal a random fortune. Nostalgic fun.
Search for common ingredient substitutions (e.g., buttermilk, egg, cornstarch). Quick reference for when you're missing something. Local data.
Drag words to the correct position in a sentence using in, on, at. Visual feedback.
Search for the NaOH and KOH sap values of various oils. Reference for cold process soap makers.
Choose base metal thickness and welding position to get the right rod diameter and amperage range. Beginner welder's quick reference.
Generate the doGet() and doPost() boilerplate for a Google Apps Script web app. Ready to paste into the editor.
Control a lunar module and try to land softly on the moon. Manage fuel and thrust. Classic arcade physics. Canvas.
Paste raw email headers and get a human-readable breakdown of the delivery route, authentication results, and delays. Private analysis.
Drag the virtual ring to perform multiplication, division, and unit conversions. Rediscover preβelectronic calculator charm.
Calculate maximum shutter speed before star trailing (NPF rule) and estimate trail length for creative effects.
Drag and drop pieces to set up a chess position. Generate FEN string and copy to share. Analyze openings. Local only.
Enter a common chemical name to see summary hazard pictograms and precautions. Quick reference.
Search and filter all CSS properties that can be animated. See value types and example keyframes. Quick dev reference.
Convert a small image into a Base64 data URI and get a Markdown image tag. Perfect for README files and noteβtaking apps. Local.
Generate dynamic placeholder images by specifying width, height, colors, and text. View instantly as a URL you can embed in mockups. Canvas-based.
Select wax type, candle diameter, and wick size to estimate total burn time.
Answer questions about project type and strength needed to get a joint recommendation. Animations.
Enter number of rooms and get an estimate of how many moving boxes in each size you'll need. Plan your move efficiently. Local tool.
Practice carrom shots on a virtual board. Visualize rebounds and plan your strike on the physical board.
Recreate the target CSS linear gradient by adjusting stops and colors. A unique game for frontβend developers to master gradients.