The Wayback Machine - https://web.archive.org/web/20200612090210/https://github.com/topics/sql-query
Skip to content
#

sql-query

Here are 391 public repositories matching this topic...

meticoeus
meticoeus commented Apr 6, 2020

I have an interface with multiple implementing types. Two of these types happen to share a property that is not in the interface. This property is calculated from the data in the same column in the table for both types so each type uses sqlDeps in the field data passed to join-monster. When I query the interface and use fragments to get this overlapping property (among others unique to each type

Liuzhj
Liuzhj commented Mar 14, 2020

目前遇到的问题/使用障碍

  • 目前已经支持了6种数据库,是否会支持impala? 或者hive等其他。感觉实现方式上不是很困难。建议考虑。
  • 对于数据库的备份,还原等,有一个开源项目用起来还可以,支持多种数据库的备份还原,建议考虑。phpbu
  • 对于mysql或者pg数据库集群的使用,在添加实例的时候需要指定实例的状态是master 还是slave,在实际工作中,主从节点的角色是变化的,人为切换或者故障切换,此时实例的状态就和管理平台上的状态不对应,会造成疑问。想知道此问题有没有进一步的方案或计划?
  • 有没有一种办法,能以网状图或者其他图表的形式,把一个集群内的所有节点关联起来,这样对于集群管理来说,应该是非常好的使用体验。
  • 有没有考虑支持集群节点自发现? 比如手
ahmad-moussawi
ahmad-moussawi commented Mar 28, 2019
new Query("Users")
.Comment("Fetch invalid users")
.WhereTrue("Invalid");

We can log it using

queryFactory.Logger = (compiled, query) =>
{
    logger.LogInformation("// " + query.GetComment() + "\n" + compiled.ToString() + "\n", compiled.Bindings);
};

Output

// Fetch invalid users
SELECT * FROM [Users] WHERE [Invalid] = 1
iamshreeram
iamshreeram commented Sep 4, 2019

Hi, I'm following the document - https://tabix.io/doc/Install/.

Docker is failing to pull the images. This issue is fixed at #66. But doc needs update - Below is the docker log while building the image -

Status: Downloaded newer image for debian:jessie
 ---> 2c5f66c0d4e0
Step 2/12 : ENV APP_HOME /usr/src/app
 ---> Running in 9367e950f6ad
Removing intermediate container 9367e950f6a
alexlipa91
alexlipa91 commented Sep 27, 2019

Hi there, probably stupid question but is there any detailed doc of what kind of content the config json can contain? I see you can setup username and password for each kernel: is this an authentication against the livy server?
Is there a way to specify the address of the server?
Also, is it possible to customize the location of the config.json file?

Thanks!

vscode-sqltools
pataquets
pataquets commented Oct 19, 2017

Docker Hub allows you to create Automated Builds from source: https://docs.docker.com/docker-hub/builds/
It would add another packaging/distribution/installation method, whose buildings would be triggered automatically on each commit. It also allows to create different image tags from git tags & branches.
Also, documentation could easily include a canonical docker run statement to quickly spin

database
TonnyJe
TonnyJe commented Apr 26, 2020

Version: ^3.0

Bug Description

Wrong SQL generation for joining tables with DELETE.

Steps To Reproduce

This code

$this->database->table('is_document_item')
                ->where('document.code', 202750006)
                ->where('amount', 0)
                ->fetchAll();

generates this query:

SELECT `is_document_item`.`id` 
FROM `is_document_item` 
LE
lorenzofox3
lorenzofox3 commented Dec 11, 2018

Feature request:

Select builders are often used in sub query with aliases.
It would be a nice syntax addition if instead of using an object we could output the builder with a alias directly thanks to an as method

//currently 
sh.select().from({
  as:'foo',
  value:sh.select().from('users').where('age','>',42).noop()
});

could be written:

sh.sele

Improve this page

Add a description, image, and links to the sql-query topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the sql-query topic, visit your repo's landing page and select "manage topics."

Learn more

You can’t perform that action at this time.