databases

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.

2019/12/02 和Yi Wang沟通交流考虑SQLFLOW可以支持如下的特性

一、基础功能：好用的工具需要一个更加简易友好的界面，让业务开发/分析更加简单
1)设计分析类工具，提供自动联想输入、快速语法、常见语义错误，提升用户体验
应用场景：提供IDE的自动联想功能，提高开发效率；语法和基本语义提前检查，避免提交到后台，执行较长时间后报错
2)大数据量时时间较长，建议提供任务(job)管理、允许用户了解数据执行的状态、监控进度、提供动态调试、watch能力，方便用户感知和调优
应用场景：耗时任务可以快速了解整体进度，提供一些中间的过程信息、耗时等，方便用户进行调优,优化开发
3) 安全权限、用户管理、
应用场景：增加新的数据分析人员、用户权

With Hive connector

trino:default> CREATE TABLE one (a varchar);
            -> CREATE VIEW two AS SELECT * FROM one;
CREATE TABLE
CREATE VIEW

DROP TABLE is rejected on a view:

trino:default> DROP TABLE two;
Query 20210906_150832_00015_id3y3 failed: line 1:1: Table 'hive.default.two' does not exist, but a view with that name exists. Did you mean DROP VIEW hive.default.t

Java's iterators can skip over values :

https://github.com/RoaringBitmap/RoaringBitmap/blob/master/roaringbitmap/src/main/java/org/roaringbitmap/PeekableIntIterator.java

运行示例代码，如果把user对应的age和uid属性调换一下时，即使绑定了对应的tag，但是仍然按照数据库中顺序进行赋值，数据库的第一列uid对应的了user类的第一个属性age

Sep	OCT	Nov
	14
2020	2021	2022

databases

Here are 951 public repositories matching this topic...

Developer-Y / cs-video-courses

trimstray / test-your-sysadmin-skills

golang-migrate / migrate

sql-machine-learning / sqlflow

some feature i think sqlflow should support

trinodb / trino

DROP TABLE IF EXISTS silently ignores views

CREATE TABLE should reject if user chooses to bucketed on unsupported column type

Cumulative user memory overflow, visible in the UI

prest / prest

mattes / migrate

dahlia / awesome-sqlalchemy

rom-rb / rom

codingo / NoSQLMap

coollabsio / coolify

apptension / developer-handbook

RoaringBitmap / roaring

Add skippable iterators

dbeaver / cloudbeaver

gohouse / gorose

需要绑定的变量对应的tag未生效

smallnest / gen

wuseman / EMAGNET

probcomp / bayeslite

nodesocket / jsonlite

cossacklabs / acra

joaoh82 / rust_sqlite

openlink / virtuoso-opensource

IceFireDB / IceFireDB

go-gormigrate / gormigrate

collerek / ormar

paragonie / easydb

jtv / libpqxx

skytable / skytable

TablePlus / DBngin

ycd / manage-fastapi