Skip to content
#

Database

database logo

A database is a structured set of data held in a computer, most often a server. Databases use a database management system (DBMS) that interacts with users, similar to a lookup table. Modern databases are designed to allow for creation, querying, updating, and administration of the data it holds.

Here are 2,316 public repositories matching this topic...

sheetjs
defusioner
defusioner commented Feb 25, 2021

Hi, I'm trying to read a CSV file like this (;, delimiters):

A;B;C;D
1,1;2,2;3,3;4,1
1,1;2,2;3,3;4,1
1,1;2,2;3,3;4,1

What happens: semicolon from the first line does not become the main separator, the comma from the second line does and it breaks the file's logic.

Code that reads:

X.read(e.target.result, { type: 'string' })

Result

{
      A1: { t: 's', v:
postgres
okbrown
okbrown commented Jan 10, 2020

Hi, First and foremost, I think this is a great start at making something really simple and effective. Thank you!!

However... I have always found template strings a little odd especially in this context.
Let us say we have

const query = `SELECT ${distinct}, ${columns} FROM ${table} ${innerJoins} WHERE ${where}`;
(Where distinct, columns, table etc are their own strings made up of other

Wikipedia
Wikipedia