Search Results for "csv to database" - Page 2
Sort By:
Showing 170 open source projects for "csv to database"
View related business solutions-
Veeam Data Platform v13.1 - Get Your Free TrialTry Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
-
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
1
Java Data Loader
jdl is a loader utility for moving data from (CSV or XML) into a db.
usage: java [-options] -jar jarfile -c <arg> -d <arg> [-l <arg>] -c,--conn <arg> conn file -d,--data <arg> data file -l,--load <arg> load file Into src/test/resources you can find some sample (conn, data and load) files. -
2
xsd2pgschema
Relational database replication tool based on XML Schema
xsd2pgschema is a Java application suite, which converts XML Schema 1.1 (hierarchical data model) to PostgreSQL DDL (relational data model) and supports XML data migration into PostgreSQL based on the XML Schema without defects on information content. It also supports full-text indexing via either Apache Lucene or Sphinx Search utilizing the relational data model. File conversion from XML to CSV, TSV, or JSON is possible as well as mapping XML Schema to JSON Schema. Obtained PostgreSQL database can be optimized at user's discretion. Moreover, differential update, and XPath query evaluation over PostgreSQL are possible. PgSchema server, serialized relational data model server, can be used to speed up the analysis of complex XML Schema. ... -
3
ExcelToDatabase
An automated tool for batch-importing Excel data into a database
ExcelToDatabase is an automated tool for batch-importing Excel data into a database. It supports 10 popular databases including MySQL, Oracle, SQL Server, PostgreSQL, and so on. Supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience for simplified Excel import and export, making it easier than ever before. Whether you want one-click, batch, or personalized import/export, or use scheduled tasks for unattended full automation, ExcelToDatabase delivers unprecedented productivity improvements. ... -
4
ISQLHelper
SQL Server Helping Application For Developers
1.SQL Compare Compare and synchronize SQL Server database schemas effortlessly. 2.SQL Data Compare Identify and sync data differences between SQL Server databases. 3.Folder to SQL Compare Compare SQL script folders with live SQL Server databases. 4.SQL Trace / SQL Profiler (Azure Supported) Capture, trace, and analyze SQL Server events and performance — includes Azure SQL support. 5.SQL Table Documents Generate structured documentation for SQL Server table schemas. 6.SQL Data Export Export SQL Server data into multiple formats (CSV, Excel, JSON, etc.). 7.Excel to SQL Move Import Excel spreadsheets directly into SQL Server tables. 8.Import / Export Data Perform high-speed bulk data transfer between databases and formats. 9.Daily Tasks Automate and schedule routine SQL Server maintenance tasks. 10.Procedure Creation Easily design, edit, and manage stored procedures. 11.Script Maintenance Organize, version, and manage SQL scripts within the applica -
Build Agents and Models on One PlatformGemini Enterprise Agent Platform is Google Cloud's comprehensive platform for developers to build, scale, govern, and optimize agents and models. Choose from Google's most advanced models and third-party models like Anthropic's Claude Model Family.
-
5
nuBuilder Forte
nuBuilder Forte is a cloud database builder.
nuBuilder Forte is the 4th version of nuBuilder. A open-source browser-based tool created for developing web-based database applications. nuBuilder uses either MySQL or MariaDB databases and gives its users the ability to do database operations like... • Search, Create, Insert, Read, Update, Delete ✪ With low-code tools that create ... - Forms with the Form Builder - Fast Reports - Database queries with the SQL Builder - Customised date and number formats with the Format... -
6
FNProg2PDA is a freeware add-on tool for the FNProgramvare software (http://www.fnprg.com) to export data from the FNProgramvare databases (for assets, books, CD's, LP's, video's, DVD's, software or stamp collections) to BookBuddy, MovieBuddy or MusicBuddy as well as a Firebird, PostgreSQL, MariaDB, SQL Server, SQLite , xBase or HanDBase database, Calc orMS-Excel spreadsheet, CSV-, TSV-, JSON-, YAML- or XML file. Source files: https://github.com/TvBreukelen/fnpdbservices
-
7
ldif-extract
Extrect selected entries from LDIF files like grep
ldif-extract is a small 'grep' like tool to extract and convert data from LDIF files. It could be used standalone or also in a pipe together with other tools like ldapsearch. -
8
OpenSparrow
Advanced Data Management Platform | PHP + vanilla JS + Postgres!
...Perfect building HR/WMS/ERP/CRM systems, booking applications, task trackers and other custom application. Data Grid - Inline editing, error validation, status coloring, global search, and CSV export. Nested Relations - Support for "Drilldown" views to display nested data and sub-tables inside a record view. Visual Admin Panel - Configure schemas, form layouts, columns, and relations via GUI without writing code. Dashboard - Generate KPI widgets, interactive lists, and bar charts that aggregate live database data. Calendars - Map tables with dates to dynamic timelines and automate smart notifications for users. -
9
OctoSQL
Join, analyse and transform data from multiple databases
OctoSQL is predominantly a CLI tool which lets you query a plethora of databases and file formats using SQL through a unified interface, even do JOINs between them. (Ever needed to join a JSON file with a PostgreSQL table? OctoSQL can help you with that.) OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. At the same time it's an easily extensible full-blown dataflow engine, and you can use it to add a SQL interface... -
Train ML Models With SQL You Already KnowBuild and deploy ML models using familiar SQL. Automate data prep with built-in Gemini. Query 1 TB and store 10 GB free monthly.
-
10
LocustDB
Massively parallel, high performance analytics database
An experimental analytics database aiming to set a new standard for query performance and storage efficiency on commodity hardware. See How to Analyze Billions of Records per Second on a Single Desktop PC and How to Read 100s of Millions of Records per Second from a Single Disk for an overview of current capabilities. Download the latest binary release, which can be run from the command line on most x64 Linux systems, including Windows Subsystem for Linux. -
11
Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples
-
12
GETL
ETL engine based on Groovy
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with... -
13
pgloader
Migrate to PostgreSQL in a single command
pgloader is a data migration tool designed to load data into PostgreSQL from various sources. It automates the process of migrating databases, handling schema transformations and data type conversions. pgloader supports high-speed data loading using PostgreSQL's COPY command and provides detailed logs for monitoring the migration process. -
14
mysqly
PHP data framework for Mysql
Full-featured opensource small-overhead PHP data framework for Mysql built for fast and efficient development -
15
Box Spout
Read and write spreadsheet files (CSV, XLSX and ODS)
Spout is an open-source PHP library for reading and writing spreadsheet files, including CSV, XLSX, and ODS formats. It is designed to handle large files efficiently, making it ideal for applications that generate or process extensive data reports. Spout is lightweight, fast, and easy to use, offering a simple API to work with rows and cells without consuming excessive memory. -
16
UCanAccess
A pure Java JDBC driver for Microsoft Access database files
UCanAccess is a pure Java JDBC Driver implementation which allows Java developers and JDBC client programs to read/write Microsoft Access database (.mdb and .accdb) files. No ODBC needed. -
17
Open Source Data Quality and Profiling
World's first open source data quality & data preparation project
This project is dedicated to open source data quality and data preparation solutions. Data Quality includes profiling, filtering, governance, similarity check, data enrichment alteration, real time alerting, basket analysis, bubble chart Warehouse validation, single customer view etc. defined by Strategy. This tool is developing high performance integrated data management platform which will seamlessly do Data Integration, Data Profiling, Data Quality, Data Preparation, Dummy Data... -
18
Project Tracking Database
A Project Tracking LibreOffice Database Example
• It can be run as Stand-Alone or run from another App - I used KiCad (Simple Plugins) for this example. • There are two ODT forms - one is a smaller version of the larger form (thus, it omits some fields). The actual Database is the same so, records won’t be lost and either Form can be used. • The ODT forms simplify and un-clutter the display (all the other LibreOffice windows are not displayed). Of course, they are still available if opening the .ODB file. • FYI - I had planned to... -
19
CSV to sql convertor
This tool will help you to convert your CSV files to SQL files.
This tool will help you to convert your CSV files to SQL files with easy steps. Free to use. Requires Java to run. -
20
JuliaDB.jl
Parallel analytical database in pure Julia
JuliaDB is a package for working with large persistent data set. JuliaDB provides distributed table and array datastructures with convenient functions to load data from CSV. JuliaDB is Julia all the way down. This means queries can be composed with Julia code that may use a vast ecosystem of packages. -
21
SQLeo Visual Query Builder
Helping users to quickly understand SQL queries
SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ...) and permits to reverse engineer database models as db designers do. This SQL GUI supports all JDBC drivers: Oracle, MySQL, MSSQL, Firebird, HSQLDB, H2, PostgreSQL, CsvJdbc, SQLite, UCanAccess, MonetDB ... (but MySQL jdbc and CsvJdbc are the only driver included in the package) Can be compared with : FreeQueryBuilder... -
22
Library for parsing Excel (XLS) files, with a sample program for converting Excel files into CSV. This site is no longer being updated. A new release is available on the new site whose link is shown above.
-
23
jdbc2csv.jar
Command-line sql JDBC tool
jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate,... -
24
Orbada - Database manager
Database SQL, query tool, using JDBC for Oracle,SQLite,PostgreSQL,etc
ORBADA is a database, SQL, query client using JDBC drivers. It is a tool to administrate and manage database structure. It Is for Oracle, SQLite, Firebird, HSQLDB, DerbyDB, MySQL, PostgreSQL and other databases. -
25
Vytics Community
Query and plot data in seconds (Excel, CSV, SQL and NoSQL DBMS)
Vytics lets you query and plot csv data, Excel files, databases (SQL and NoSQL). You can also organize your queries, data and graphs into reports and projects.
