uds5501

5th Jan 2024

I will be updating this gist as I dig deeper into the optimization planner. My research will be strictily bound to SELECT qeury right now.

When running an explain query, you can find the output like ->

MariaDB [sample_db]> explain select * from sample_table;
+------+-------------+--------------+------+---------------+------+---------+------+------+-------+
| id   | select_type | table        | type | possible_keys | key  | key_len | ref  | rows | Extra |
+------+-------------+--------------+------+---------------+------+---------+------+------+-------+

uds5501

import sys

REDIS_CONFIG_MASTER_NAME = "mymaster"

def generate_sentinels(num_pairs, num_sentinels):
    docker_compose = ""
    for i in range(1, num_sentinels + 1):
        docker_compose += f"  redis-sentinel-{i}:\n"
        docker_compose += f"    container_name: 'redis-sentinel-{i}'\n"
        docker_compose += f"    image: redis:6.0-alpine\n"

uds5501

import { createMuiTheme, ThemeProvider } from "@material-ui/core/styles";
import React, { useState } from "react";
import Switch from "@material-ui/core/Switch";

export default function Dashboard() {
  const [darkState, setDarkState] = useState(false);
  const palletType = darkState ? "dark" : "light";
  const mainPrimaryColor = darkState ? orange[500] : lightBlue[500];
  const mainSecondaryColor = darkState ? deepOrange[900] : deepPurple[500];
  const darkTheme = createMuiTheme({

uds5501

import { createMuiTheme, ThemeProvider } from "@material-ui/core/styles";
import React, { useState } from "react";
import Switch from "@material-ui/core/Switch";

export default function Dashboard() {
  const [darkState, setDarkState] = useState(false);
  const palletType = darkState ? "dark" : "light";
  const darkTheme = createMuiTheme({
    palette: {
      type: palletType,

uds5501

import { createMuiTheme, ThemeProvider } from "@material-ui/core/styles";
import React, { useState } from "react";

export default function Dashboard() {
  const [darkState, setDarkState] = useState(false);
  const palletType = darkState ? "dark" : "light";
  const darkTheme = createMuiTheme({
    palette: {
      type: palletType,
    }

uds5501

import { createMuiTheme, ThemeProvider } from "@material-ui/core/styles";
import React, { useState } from "react";

export default function Dashboard() {
  const [darkState, setDarkState] = useState(false);
  const palletType = darkState ? "dark" : "light";
  const darkTheme = createMuiTheme({
    palette: {
      type: palletType,
    }

uds5501

Uddeshya Singh | @uds5501 | FOSSASIA

Overview:

In this summer period, I worked on FOSSASIA's Open Event projects (comprising of Open Event Server and Open Event Frontend). The Open Event , popularly know as Eventyay, is an open sourced event management platform which enables users to host conferences and various kinds of meet-ups and helps them customize their event according to their requirements. Sophisticated features like tickets, payment collections and call for speakers have been provided and can be further fine tuned into several tracks, venues and sessions.

My main goal of this period was to focus on making the Eventyay platform more stable for new users while laying down foundations for making the platform smoother in terms of payment gateway integrations and payment workflows.

uds5501

from flask import Flask
from flask_rest_jsonapi import Api
from your_project.permission import permission_manager

app = Flask(__name__)

api = Api()
api.init_app(app)
api.permission_manager(permission_manager)

uds5501

from flask import request
from flask_rest_jsonapi import ResourceDetail, ResourceList, ResourceRelationship
from flask_rest_jsonapi.exceptions import ObjectNotFound
from sqlalchemy.orm.exc import NoResultFound

from app.api.bootstrap import api
from app.api.helpers.db import get_count, safe_query
from app.api.helpers.exceptions import ForbiddenException, ConflictException, MethodNotAllowed
from app.api.helpers.permission_manager import has_access
from app.api.helpers.utilities import require_relationship

uds5501

from marshmallow_jsonapi import fields
from marshmallow_jsonapi.flask import Relationship

from app.api.helpers.utilities import dasherize
from app.api.schema.base import SoftDeletionSchema
from utils.common import use_defaults


@use_defaults()
class TaxSchemaPublic(SoftDeletionSchema):