Open-source alternatives to Sql Server Samples

sql.js is a serverless, in-memory SQL database engine that ports SQLite to WebAssembly for use within a web browser. It provides a JavaScript interface to initialize relational databases, execute SQL queries, and manage structured data without requiring a backend server. The project enables the import and export of database states using typed arrays, allowing in-memory data to be persisted as files. It supports high-precision integer retrieval via BigInt and utilizes prepared statements to increase execution speed and security. The engine includes capabilities for client-side data management

This project is a relational SQL sample database and synthetic testing dataset. It provides a standardized data model of a fictional digital media store, encompassing business entities such as artists, albums, tracks, customers, and invoices. The dataset is designed as a cross-dialect SQL collection, using compatible scripts to ensure consistent data seeding and environment parity across different database server engines. It combines imported metadata with fictitious personal details to create realistic records for software prototyping and demonstrations. The project covers capabilities for

This project is a containerized IPTV service that aggregates channel playlists from multiple public sources and serves them alongside Electronic Program Guide (EPG) XML data. It functions as an automated playlist aggregator and EPG provider, designed to run as a self-maintaining system that keeps channel listings current without manual intervention. The service distinguishes itself by combining playlist aggregation, EPG serving, and automated updates into a single containerized deployment. It refreshes aggregated channel data on a recurring schedule, pulling from multiple public repositories

This project is a Sina Weibo web scraper and social media data pipeline designed to extract user profiles, posts, comments, and multimedia assets. It functions as a containerized data crawler that automates the collection and local storage of social media content and engagement metrics. The system includes a processing layer that uses large language models to analyze scraped text, generating summaries and sentiment analysis. It differentiates itself through a deployment-ready container model featuring an HTTP interface for managing extraction tasks and monitoring job progress. The crawler co

Lets-chat is a self-hosted team communication platform and XMPP chat server designed for private messaging. It provides a containerized communication environment for small teams to exchange messages and files, featuring a programmable REST API for automating conversations and managing messages from external tools. The platform functions as an XMPP gateway and server, ensuring interoperability with other compliant messaging clients. It distinguishes itself by supporting enterprise identity management, allowing administrators to verify user identities through local accounts or external director

Redis is a high-performance in-memory key-value store that functions as a distributed cache, message broker, and NoSQL database. It provides sub-millisecond read and write access to data stored in RAM and can operate as a vector database for indexing high-dimensional embeddings. The system supports a wide range of data storage and synchronization primitives, including the management of strings, hashes, lists, sets, and JSON documents. It enables real-time data operations through atomic transactions, hybrid persistence using snapshots and append-only logs, and high-availability configurations

This project is a self-hosted, web-based interface designed for interacting with large language models. It provides a centralized dashboard that enables users to manage model communications, maintain persistent conversation histories, and organize prompt libraries within a private, containerized environment. The platform distinguishes itself through robust administrative and security controls, including support for enterprise identity providers, password-based access, and request rate limiting. It facilitates flexible connectivity by allowing users to configure custom network proxies, manage

Memgraph is an in-memory, distributed graph database designed for high-performance labeled property graph management. It utilizes a Cypher query engine for declarative data retrieval and manipulation, providing a scalable knowledge graph backend that integrates vector search and graph traversals. The system distinguishes itself as a real-time graph analytics platform, employing native C++ and CUDA implementations to execute complex network analysis and dynamic community detection on streaming data. It provides specialized support for AI integration, including GraphRAG capabilities, the constr

MeTube is a self-hosted, containerized media downloader that provides a web-based interface for archiving online video content. It functions as a manager for the command-line tool yt-dlp, automating the retrieval, organization, and post-processing of media files directly to your local hardware. The application distinguishes itself by supporting authenticated downloads, allowing users to inject browser-derived session cookies to access private or restricted content. It also features advanced post-processing capabilities, including the automatic embedding of metadata, chapter markers, and subti

Nitter is a privacy-focused, alternative web interface for viewing public social media content. It functions as a server-side proxy that fetches and renders external posts, allowing users to browse content without requiring a personal account or executing third-party tracking scripts. By stripping away user identifiers and tracking mechanisms, the application provides a lightweight, anonymous viewing experience. The project distinguishes itself through its emphasis on network-level privacy and self-sovereignty. It supports routing traffic through Tor and I2P networks to bypass censorship and

Datasette is a tool for publishing and sharing SQLite databases as public websites. It functions as a data publishing system that provides searchable interfaces and JSON APIs to expose the contents of SQLite files. The project enables both server-side and client-side execution. It can operate as an API server or as a database browser that runs entirely within a web browser using WebAssembly, allowing for serverless database access. The system supports a variety of deployment strategies, including containerized images for cloud hosting and a local development server for testing. It includes c

Delta is a lakehouse table format that brings ACID transactions and data warehouse consistency to large scale data lakes on cloud object storage. It serves as an ACID transaction manager, coordinating atomic commits and serializable isolation for concurrent reads and writes across distributed compute engines. The project provides a multi-engine interoperability layer that uses format translation to allow diverse SQL engines and processing frameworks to read and write the same tables. It functions as a data versioning system, utilizing a transaction log to enable time travel, historical snapsh

PokeAPI is a read-only RESTful web interface and comprehensive knowledge base providing structured data about Pokémon species, moves, and game series entities. It functions as a containerized data service designed to deliver game statistics and entity details for programmatic use in applications. The service enables the retrieval of comprehensive Pokémon game data and the referencing of game entity metadata. Users can access this information through both REST and GraphQL interfaces to fetch specific data points and populate external application interfaces.

Securo is a self-hosted personal finance management platform designed to provide users with complete control over their private financial data. By deploying the application within their own infrastructure, users can aggregate bank accounts, track income and expenses, and monitor investment portfolios while maintaining data privacy. The system supports multi-user access, allowing for collaborative expense tracking and shared financial management within a single environment. The platform distinguishes itself through the integration of local artificial intelligence, which enables users to query

EspoCRM is an open-source customer relationship management platform and SQL-based business application. It serves as a centralized web interface for tracking leads, opportunities, and contacts, providing a sales pipeline manager and a customizable business logic engine. The platform is distinguished by its ability to function as a custom business application builder, allowing for the creation of tailored entities and automated workflows. It integrates marketing automation tools for campaign coordination and a structured customer support ticketing system for case management. The system covers

Mamba is a package manager for scientific and data science workflows that implements a high-performance dependency solver in C++. It uses a SAT-based resolution model and a specialized library for metadata processing to calculate compatible package versions across different operating systems. The project provides a standalone executable runtime, allowing the creation of isolated package environments without requiring a pre-existing system installation. It ensures reproducible environment setup by utilizing lock files to pin exact package versions and channels. The system supports containeriz

ai-goofish-monitor is an AI-driven marketplace monitor and containerized web scraper designed to track online listings. It uses multimodal large language models and natural language prompts to analyze product text and images, determining if items meet specific requirements. The system employs an anti-detection workflow that rotates network proxies and authenticated accounts to bypass rate limits. It captures browser cookies and session states to mimic real user behavior during automated requests. The project includes a task scheduler using cron expressions and an embedded SQLite database for

Blackcandy is a self-hosted music streaming server and digital music library manager. It allows users to host personal collections of audio files on a private server for streaming to web browsers and dedicated mobile applications. The system includes a media library sync engine that monitors file system changes in the background and uses parallel processing to keep the music database synchronized. It manages library organization by extracting audio metadata and fetching artist and album imagery from external databases. The platform provides capabilities for remote audio playback, music libra

RocketMQ is a distributed messaging and streaming platform designed for building event-driven applications. It serves as middleware to decouple services using publish-subscribe and request-reply patterns, and functions as a transactional messaging system that ensures atomicity by linking message delivery to local transaction outcomes. The platform includes specialized capabilities as a Kubernetes-native message broker for container orchestration environments and an MQTT broker for ingesting event data from mobile applications and hardware terminals. The system covers high-throughput data str

dalle-mini is a text-to-image model and generative AI system designed to transform natural language descriptions into synthetic images. It functions as an image generation training toolkit and a generative model capable of creating visual representations from text prompts. The project provides a containerized deployment for consistent execution across different computing environments. It includes the necessary scripts and configuration files to train custom generative models from datasets. The system utilizes an autoregressive transformer architecture that treats visual data as discrete toke

Relax is a headless content management system and visual website builder. It allows for the creation and organization of digital content delivered via a GraphQL API to a React frontend, utilizing a component-based visual editor to construct web pages and layouts without writing manual code. The platform integrates a dockerized content manager for simplified deployment and uses a schema-driven approach to structure data architecture and entry types. It features a dynamic administrative experience built with React and Redux to manage site states and user interfaces. The system provides broad c

This project is a GraphQL web application with a React frontend that utilizes server-side rendering to generate HTML on the server for improved initial load times and search engine indexing. The application supports both static site generation for fast delivery via pre-rendered HTML files and containerized deployment to ensure consistent runtime behavior across different environments. The project includes capabilities for GraphQL data integration, frontend asset optimization through code-splitting, and component UI verification using snapshot testing. It also provides a mechanism for managin

Astron-agent is an orchestration platform for designing and executing complex agentic workflows that combine language models with external tools and business systems. It provides a production-ready environment for deploying AI services within private intranets using container orchestration for scalable management. The platform distinguishes itself by linking large language model decision-making with robotic process automation to execute tasks across enterprise applications. It further supports enterprise requirements through a multi-tenant infrastructure that utilizes isolated memory and iden

BabyBuddy is a self-hosted infant care tracking application designed for logging feedings, diaper changes, and growth metrics to monitor child development. It functions as a private data store for sensitive health and activity records, providing a containerized environment for managing childcare data across different hardware architectures. The system integrates with home automation hubs and provides a RESTful API to enable programmatic recording and querying of care data. It supports collaborative caregiver management, allowing multiple family members or professional caregivers to share acce

Vue-pure-admin is a Vue 3 admin dashboard template and frontend boilerplate designed for developing backend management tools. It functions as a TypeScript web application scaffold that integrates Vite for the build pipeline and Element Plus for the UI framework. The project provides a responsive admin interface that adapts to both desktop and mobile screens. It is structured as an enterprise frontend architecture to support the creation of scalable professional web applications. The system includes capabilities for bootstrapping backend management systems, optimizing bundle sizes, and deploy

This project serves as a comprehensive technical reference for the architecture and design of data-intensive applications. It provides a structured analysis of the fundamental principles required to build reliable, scalable, and maintainable software systems, covering the core trade-offs inherent in modern data infrastructure. The repository explores the mechanics of distributed data management, including strategies for replication, partitioning, and achieving consensus across multiple nodes. It details the design of storage engines, indexing techniques, and transaction management models, whi

OpenObserve is a unified observability data platform designed to ingest, store, and analyze logs, metrics, and traces. It functions as a cloud-native monitoring tool that centralizes telemetry from diverse sources, including standard collectors and cloud service providers, into a single, scalable system. By utilizing a columnar storage engine backed by object storage, the platform enables efficient long-term data retention and high-performance analytical querying. The platform distinguishes itself through deep integration with artificial intelligence, allowing users to query data using natura