All Projects → echlebek → Nutes

echlebek / Nutes

Licence: mit
SQL import of USDA nutrient database

Labels

Projects that are alternatives of or similar to Nutes

Mycat2
MySQL Proxy using Java NIO based on Sharding SQL,Calcite ,simple and fast
Stars: ✭ 750 (+12400%)
Mutual labels:  sql
Code Audit Challenges
Code-Audit-Challenges
Stars: ✭ 779 (+12883.33%)
Mutual labels:  sql
Ezsql
PHP class to make interacting with a database ridiculusly easy
Stars: ✭ 804 (+13300%)
Mutual labels:  sql
Usql
Universal command-line interface for SQL databases
Stars: ✭ 6,869 (+114383.33%)
Mutual labels:  sql
Smartsql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Stars: ✭ 775 (+12816.67%)
Mutual labels:  sql
Fluentpdo
A PHP SQL query builder using PDO
Stars: ✭ 783 (+12950%)
Mutual labels:  sql
Db Dumper
Dump the contents of a database
Stars: ✭ 744 (+12300%)
Mutual labels:  sql
Ray.aurasqlmodule
Aura.Sql module for Ray.Di
Stars: ✭ 5 (-16.67%)
Mutual labels:  sql
Elasticsearch Sql
Use SQL to query Elasticsearch
Stars: ✭ 6,563 (+109283.33%)
Mutual labels:  sql
Csvq
SQL-like query language for csv
Stars: ✭ 804 (+13300%)
Mutual labels:  sql
Azuredatastudio
Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
Stars: ✭ 6,605 (+109983.33%)
Mutual labels:  sql
Imguicolortextedit
Colorizing text editor for ImGui
Stars: ✭ 772 (+12766.67%)
Mutual labels:  sql
Privesc
A collection of Windows, Linux and MySQL privilege escalation scripts and exploits.
Stars: ✭ 786 (+13000%)
Mutual labels:  sql
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+128433.33%)
Mutual labels:  sql
Typeorm
TypeORM module for Nest framework (node.js) 🍇
Stars: ✭ 807 (+13350%)
Mutual labels:  sql
Mit 15 003 Data Science Tools
Study guides for MIT's 15.003 Data Science Tools
Stars: ✭ 743 (+12283.33%)
Mutual labels:  sql
Sql Formatter
A whitespace formatter for different query languages
Stars: ✭ 779 (+12883.33%)
Mutual labels:  sql
Xojo Sqlbuilder
Xojo classes to build a SQL statement
Stars: ✭ 6 (+0%)
Mutual labels:  sql
Records
SQL for Humans™
Stars: ✭ 6,761 (+112583.33%)
Mutual labels:  sql
Imdbpy
IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies
Stars: ✭ 792 (+13100%)
Mutual labels:  sql

nutes

PostgresQL import of USDA nutrient database.

Requires:

  • curl
  • make
  • postgresql
  • go

The Makefile will:

  1. Download the USDA nutrient database
  2. Prepare the text files for import (convert to UTF-8, use TSV)
  3. Create a database schema according to the USDA's documentation.
  4. Import the data files into the database.

For this to work you will likely need to edit the Makefile to fit your particular postgresql install. By default psql is assumed to work without username, password, or database. (Tested using Postgres.app on my mac)

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].