mysql
This tutorial will guide you through accessing a MySQL database using the MySQL client CLI on a Linux server, listing all databases, accessing a specific database, showing all tables, counting records in a table, exporting a table using mysqldump, and finally, downloading the exported SQL file to a local macOS
databases
dsq is a free and open-source app that enables you to run SQL queries against JSON, CSV, Excel, Parquet, and more. It works on Windows, Linux and macOS. It can also work against log files such as Nginx Access Logs and Apache Access Logs. Features * Lightweight * Developer-friendly * Easy learning curve
libsql
SQLDump is a cross-platform command line utility to execute SQL queries and export results to a CSV file. It currently supports Oracle and MySQL. Usage To use you need Java installed java -jar SQLDump-0.4.jar -url [jdbc:oracle:thin:@hostname:port:sid] -user [username] -pass [password] -sql [query] Remember
database
What is an SQL Client? An SQL client is a software tool that allows users to connect to and interact with a database server using SQL (Structured Query Language). It provides an interface to execute SQL queries, manage database structures, and perform administrative tasks such as backups, updates, and migrations.
database
In today's data-driven world, efficient database management is crucial for businesses, developers, and data analysts alike. Whether you're a seasoned database administrator or a developer just starting out, having the right tools to interact with your SQL databases can significantly impact your productivity and efficiency. SQL
mysql
In today's digital landscape, data is one of the most valuable assets for any organization or individual. Ensuring that your data is backed up regularly and securely is critical to maintaining data integrity and availability. One of the most popular and efficient ways to back up a MySQL
Tutorials
Apache CouchDB is an open-source NoSQL database that is known for its ease of use, high availability, and resilience. It uses a schema-free, document-oriented data model and stores data in JSON format. One of its standout features is the ability to replicate data across multiple servers, making it highly reliable
Docker
Tutorial: Installing PostgreSQL with Docker Compose
database
A single file database is a database that stores all its data within a single file on the file-system. This design simplifies management, distribution, and deployment. Examples include SQLite and Microsoft Access. These databases are suitable for lightweight applications, mobile apps, and embedded systems where simplicity and ease of use
IoT
A Time Series Database (TSDB) is a specialized database designed to efficiently store, retrieve, and manage time-stamped data points. These data points are usually recorded in sequential order over time, making TSDBs particularly suitable for applications that involve continuous data collection. Use-Cases of Time Series Databases IoT and Sensor Data:
List
What is a Data warehouse Solution? A data warehouse solution is a centralized repository designed for the storage, analysis, and retrieval of large volumes of structured and unstructured data from multiple sources. It consolidates data from various operational systems, transforming it into a unified format to support business intelligence activities,
Next.js
In this tutorial, we'll guide you through integrating LibSQL with a React and Next.js application. What is LibSQL? LibSQL is a lightweight, efficient SQL database solution designed for modern web applications. It's open-source, highly customizable, and offers great performance, making it an excellent choice for
sqlite
In the ever-evolving world of database technology, finding tools that fit your specific project requirements can be challenging. Two emerging alternatives that are garnering attention are Turso.tech and LibSQL. Here’s why these platforms might be the perfect fit for your next project. What is Turso.tech? Turso.tech
data science
Welcome to our article about the best open-source self-hosted tools for data scientist and engineers. In this fascinating world of data, having the right tools at your disposal is crucial. From data cleaning to visualization, these open-source tools can make your life easier and enhance your workflow. 10 Reasons Why
data science
If you're a data engineer or data scientist, you understand the importance of a robust data observability tool. Enter Elementary, a native data observability solution designed specifically for data and analytics engineers. It's not just a tool, it's a comprehensive platform that integrates seamlessly