Skip to content

Instantly share code, notes, and snippets.

View pprathameshmore's full-sized avatar
🎯
Focusing

Prathamesh More pprathameshmore

🎯
Focusing
View GitHub Profile
@roshancharlie
roshancharlie / SQL-Murder-Mystery-Solution.md
Last active February 6, 2023 13:21
The SQL Murder Mystery Walk Through

Start

Key to The SQL Murder Mystery

See the Clue As Given in Question

The crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City

select * from crime_scene_report
where date=20180115 and type = 'murder' and city = 'SQL City';

Output

>Description-

@AstralJohn
AstralJohn / Reset Udemy Progress.md
Last active October 1, 2024 15:36
Reset Udemy Progress

Reset Udemy Progress

Last Updated: 06/18/2024

Step 1. Go to the Udemy course in your browser

Go to the course and have any video up. The following code relies on the right sidebar to be visible to uncheck all your progress.

Step 2. Open browser console

You can do this with ctrl+shift+j and making sure the console tab is selected for chrome/brave

@michaelmcshinsky
michaelmcshinsky / api-core.js
Last active December 8, 2023 13:51
A comprehensive starter solution to making API calls structured and manageable in code architecture and development teams.
import apiProvider from './provider';
export class ApiCore {
constructor(options) {
if (options.getAll) {
this.getAll = () => {
return apiProvider.getAll(options.url);
};
}
const express = require('express');
const app = express();
const path = require('path');
const multer = require('multer');
const port = 3000;
app.use('/uploads', express.static(path.join(__dirname, '/uploads')));
const express = require('express');
const mongoose = require('mongoose');
const bodyParser = require('body-parser');
const app = express();
const PORT = 3000;
mongoose.connect('DB_URL', { dbName: 'todo' }, (err) => {
if (!err) {
console.log('Connected to database');
@LukeSkyRunner
LukeSkyRunner / javascript-nested-data-structure-practice.markdown
Created January 2, 2020 02:58
Javascript Nested Data Structure Practice
@bradtraversy
bradtraversy / docker-help.md
Last active November 4, 2024 16:36
Docker Commands, Help & Tips

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

@justsml
justsml / fetch-api-examples.md
Last active August 20, 2024 19:31
JavaScript Fetch API Examples
@keyurgolani
keyurgolani / dao.js
Last active June 17, 2024 03:44
Node.js Data Access Object (DAO) Template with Self Implemented Connection Pooling
var mysql = require("mysql");
// Configure your logger here
var logger = require("../utils/logger");
// Add a properties file here with the configurations
// For properties file format visit https://github.com/steveukx/properties
var properties = require('properties-reader')('properties.properties');
function getConnection() {
var connection = mysql.createConnection({
host: properties.get('mysql.host'),
@barbietunnie
barbietunnie / udemy-courses-download-using-cookies.md
Last active November 6, 2024 00:25
Downloading Udemy videos with youtube-dl

How to download your Udemy course videos using youtube-dl

$ youtube-dl --list-extractors | grep udemy

Steps

  1. Get link to the course to download. e.g. https://www.udemy.com/course-name/
  2. Login into udemy website, save the cookie from chrome using Chrome (Cookie.txt)[1] export extension. Save it to file udemy-cookies.txt
  3. Get the link of the video that you want to download. usually in format. Use the command provided below where you have to replace the {course_link} and {path_to_cookies_file} with respective paths.
$ youtube-dl {course_link} --cookies {path_to_cookies_file}