Skip to content
#

Database

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 14,437 public repositories matching this topic...

sheetjs
SheetJSDev
SheetJSDev commented Oct 11, 2020

While I try to change header titles by passing array of titles to options like below it does not override the headers. Instead it writes new headers first and original data with old headers again from next cell.

I am experiencing the same problem.

In addition, sheets js is mutating the header array passed in, which is not something I would ever expect.

Example:

const head
cockroach
vlolla
vlolla commented Oct 8, 2020

Currently the M/D/Y format for time does not parse:

demo@127.0.0.1:61487/defaultdb> select '12/4/2011 15:03'::timestamptz;
ERROR: parsing as type timestamp: field day value 2011 is out of range
SQLSTATE: 22008

On psql, this parses successfully, which we should look to imitate:

otan=# select '12/4/2011 15:03'::timestamptz;
      timestamptz
------------------------
 201
dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

📚 C/C++ 技术面试基础知识总结,包括语言、程序库、数据结构、算法、系统、网络、链接装载库等知识及面试经验、招聘、内推等信息。This repository is a summary of the basic knowledge of recruiting job seekers and beginners in the direction of C/C++ technology, including language, program library, data structure, algorithm, system, network, link loading library, interview experience, recruitment, recommendation, etc.

  • Updated Oct 12, 2020
  • C++
bricelam
bricelam commented Oct 7, 2020

Today, we translate this as @value IS NULL OR LTRIM(RTRIM(@value)) = N''. But I have a few questions:

  1. Why do we trim both the start and the end? Just one would produce the same result with less processing.
  2. More importantly, why do we trim at all? As we know from our StartsWith research, N' ' = N'' returns true in SQL Server.

IMHO, the translation should be `@value IS NULL OR @valu

Wikipedia
Wikipedia
You can’t perform that action at this time.