recentpopularlog in


« earlier   
GitHub - harelba/q: q - Run SQL directly on CSV or TSV files
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings.

q's web site is It contains everything you need to download and use q immediately.
csv  text  tools 
yesterday by lena
Online tool for converting CSV to JSON. Convert Excel to JSON. Transpose data. Output array or hash.
json  tools  csv  forwork 
yesterday by mattsaler
How to create a 1Password compatible CSV file
You can create and edit a CSV file to import data into 1Password from other programs.
1password  import  csv  security 
6 days ago by onefewercar
Database import from text/csv file and many to many relationship
I have a Windows SQL Server database with a many-to-many relationship between some articles and categories, the relation is made by an ArticleCategorie table with two columns => [ArticleID] - [CategorieID].

The problem now is that I have a CSV file which look like this (*picture) with two columns article id and article tags (let's say the article id is 5; and that it has 4 different categories which has respectively id 1,4,6 and 7) so here is how the CSV looks like* =>

database  import  csv  n:m 
10 days ago by ritzlea
Hey F#, load me this CSV file into a table! – Edgar Sánchez – Medium
So here’s the thing: I’ve got this CSV file, nothing fancy, but still it has got integers, decimals, strings, and dates in it, now I need to load its contents into a relational table, like in MariaDB…
type_providers  dabase  import  csv  f# 
10 days ago by ritzlea

Copy this bookmark:

to read