sqlingvo

sqlingvo copied to clipboard

Given a table definition such as : ```sql create table sample_relation ( id text not null, b_id int not null, c_id int, unique(id, b_id, c_id), foreign key (id) references sample_relation_2(id),...

S4G4R

Firstly thanks for the lib =)... Two quick questions, if I define an enum as: ```clojure (sql/create-type sql-db :gender (sql/enum ["male" "female"])) ``` Is there no better api than: ```clojure...

Folcon

How do I pass arguments to SQL functions?

1

I want to pass the value of a var to my SQL function. ```clojure (sql/sql (sql/select db [:*] (sql/from `(:my-func ~arg)))) ``` But I get an error: ``` ExceptionInfo Can't...

asultanpur

Is there support for multi columns indexes (unique, primary key)?

1

I can't find any documentation or code.

schnipseljagd

describe differences between sqlingvo, honeysql, and korma?

2

It would be really helpful for me, especially as a novice clojure user, to have a description of the differences between `sqlingvo` and the others sql libraries along with the...

AlJohri

How to use LATERAL ?

1

I had a sql such as: ``` select * from t, LATERAL (select * from jsonb_to_recordset(meta->'conditions') as x(op text, condition jsonb,duration jsonb,time jsonb)) ``` how can i use it?

ZacksTsang

Interactive documentation with klipse

11

The only change required to make the code self-host compatible was to remove the `defdb` calls in `db.cljc`.

viebel

Support for ALTER TABLE?

1

Would you accept a PR to add ALTER TABLE functionality?

xpe

Why pass db into select, insert, create-table, etc when it's actually needed only in sql fn?

1

Hi Roman. After reading sqlingvo source I'm confused with `db` argument of functions such as `select`, `insert` and others. `db` contains information about how to escape various SQL literals, so...

mlapshin

How to implement TOP for SQL Server

1

SQL Server does not support LIMIT and OFFSET, but it does support TOP at the start of a SELECT statement, e.g. `SELECT TOP 500 * FROM Table` I looked at...

theronic