hugsql.org

GENERAL
META
HTML
LINK ANALYSIS
SERVER
IP

Hugsql.org receives any estimated 264 unique visitors and 4 unique page views per day. Revenue gained from these much visits may be $0 per day from various advertising sources. The estimated worth of site is $33. Similarweb global rank is 20,703,897. Maximum no. of users comes from .

Linode, LLC is ISP, hosted on IP 72.14.183.53 in Country United States.

Website Age n/a
Alexa Rank no-data
Country United States
IP Address 72.14.183.53

META INFORMATION

Title

HugSQL Doc***entation

Description

Keywords

Content Type

utf-8

No	Meta Name	Value
1	viewport	width=device-width, initial-scale=1

GENERAL HTML INFORMATION

Type	Status
HTML 5
Responsive Website

HTML SIZE INFORMATION

Text / Code Ratio 35.00 %

hugsql.org has a website text/code ratio of 35.00 %. Search engine crawlers tend to not pick up pages with inadequate content.

IMPORTANT HTML TAGS AND COUNTS

Titles

H10
H20
H37
H425
H519
H62

No	Text
1	ınstallation
2	Getting started
3	Using hugsql
4	Hugsql in detail
5	Hugsql adapters
6	Faq
7	License

No	Text
1	Start with sql
2	Now some clojure
3	Def-db-fns
4	Def-sqlvec-fns
5	Other useful functions
6	Create,drop,... (ddl)
7	ınsert
8	Update
9	Delete
10	Select
11	Transactions
12	Clojure expressions
13	Snippets
14	Advanced usage
15	Sql file conventions
16	Command
17	Result
18	Parameter types
19	Default adapter
20	Create an adapter
21	Adapters from the community
22	Comparison with yesql
23	Does hugsql support my wacky sql?
24	What about dsls for sql?
25	Preventing sql ınjection

No	Text
1	Retrieving last ınserted ıd or record
2	Aside: param name deep get
3	Aside: namespaced keywords
4	Aside: the colon
5	Now back to the parameter types...
6	Sql values
7	Sql value lists
8	Sql tuples
9	Sql tuple lists
10	Sql ıdentifiers
11	Sql ıdentifier lists
12	Raw sql (keywords)
13	Snippets
14	Snippet lists
15	Custom parameter types
16	Clojure.java.jdbc adapter
17	Next.jdbc adapter
18	Clojure.jdbc adapter
19	Setting an adapter

No	Text
1	Optıon #1: ınsert ... returnıng
2	Optıon #2: get generated keys / last ınsert ıd / ınserted record

Text Styling

STRONG0
B17
EM19
I1
U0
CITE0

No	Text
1	sqlvec (5)
2	single-line comment expression
3	multi-line comment expression
4	BATCH INSERTS:
5	So why build a another similar library?
6	Yes
7	HugSQL and HoneySQL are not mutually exclusive
8	Value Parameters
9	Identifier Parameters
10	Raw SQL (Keyword) Parameters
11	Snippet Parameters
12	Custom Parameter Types
13	Clojure Expressions

No	Text
1	HugSQL is a Clojure library for embracing SQL.
2	right tool for the job
3	HugSQL defaults to using the clojure.java.jdbc library to run underlying database commands. If you would prefer to use another underlying database library instead of clojure.java.jdbc, such as clojure.jdbc, please see HugSQL Adapters
4	The Princess Bride
5	The Princess Bride
6	The Princess Bride
7	It's worth noting that a snippet returns an sqlvec. This small detail gives you a great deal of flexibility in providing snippets to your HugSQL queries. Why? Because you don't necessarily need to create your own snippet DSL: you could use another library for this. It is the best of both worlds! This exercise is left to the reader.
8	Please note that as of clojure.java.jdbc 0.5.8 and HugSQL 0.4.7, the above additional options are now required to be a hashmap instead of keyword arguments as in previous versions. In clojure.java.jdbc 0.5.8 the deprecated usage will emit a warning. In clojure.java.jdbc 0.6.0 the usage is deprecated and not allowed. See the clojure.java.jdbc changelog for details.
9	The use of a tuple in the above manner is not supported by all databases. Postgresql, MySQL, and H2 support it. Derby, HSQLDB, and SQLite do not support it.
10	The use of a tuple list in the above manner is not supported by all databases. Postgresql, MySQL, H2, Derby, and SQLite support it. HSQLDB does not support it.
11	BATCH INSERTS: It should be noted that Tuple List Parameter support is only support for SQL INSERT...VALUES (...),(...),(...) syntax. This is appropriate for small-ish multi-record inserts. However, this is different than large batch support. The underlying JDBC driver for your database has a limit to the size of the SQL and the number of allowed bind parameters. If you are doing large batch inserts, you should map or doseq over your HugSQL-generated insert function within a transaction.
12	If you are taking identifiers from user input, you should use the :quoting option to properly quote and escape identifiers to prevent SQL injection!
13	You should take special care to always properly validate any incoming user input before using Raw SQL Parameters to prevent an SQL injection security issue.
14	using SQL
15	embraces
16	--Curtis Summers (Feb 2016)
17	think in SQL
18	If you are taking identifiers from user input, you should use the :quoting option to prevent SQL injection! See Identifier Parameters for details.
19	Raw SQL (Keyword) Parameters are exactly what they seem, and it is your responsibility to sanitize any usage of this parameter type when using user input.

No	Text
1	Included here for reference, but this is unnecessary if you are using the hugsql meta clojar.

LINK ANALYSIS

Total Link Count: 136

Internal Link Count : 85

No	Text	Type
1	HugSQL Doc***entation	text
2	simple conventions	text
3	SQL Value Parameters	text
4	SQL Identifiers	text
5	SQL Keywords	text
6	implement your own parameter types	text
7	Clojure Expressions	text
8	Snippets	text
9	protocol-based adapters	text
10	HugSQL Adapters	text
11	Advanced Usage	text
12	deep-get parameter name access	text
13	Insert section	text
14	sqlvec	text
15	transaction	text
16	Snippets	text
17	Snippets	text
18	Hugsql Adapters	text
19	HugSQL in Detail	text
20	Clojure expressions	text
21	Snippets	text
22	Clojure expressions	text
23	Snippets	text
24	Value Parameters	text
25	Value List Parameters	text
26	Tuple Parameters	text
27	Tuple List Parameters	text
28	Identifier Parameters	text
29	Identifier List Parameters	text
30	Identifier Parameters	text
31	Raw SQL (Keyword) Parameters	text
32	Snippets	text
33	Custom Parameter Types	text
34	Clojure Expressions	text
35	Introduction	text
36	Installation	text
37	Getting Started	text
38	Start with SQL	text
39	Now Some Clojure	text
40	Using HugSQL	text
41	def-db-fns	text
42	def-sqlvec-fns	text
43	Other Useful Functions	text
44	Create,Drop,...(DDL)	text
45	Insert	text
46	Update	text
47	Delete	text
48	Select	text
49	Transactions	text
50	Clojure Expressions	text

External Link Count : 51

No	Text	Type
1	API Docs ➚	text
2	View on GitHub ➚	text
3	clojure.java.jdbc	text
4	next.jdbc	text
5	clojure.jdbc	text
6	Leiningen	text
7	Apache Derby	text
8	H2	text
9	HSQLDB	text
10	MS SQL Server jTDS	text
11	MySQL	text
12	Postgresql	text
13	SQLite	text
14	The Princess Bride example application	text
15	The Princess Bride example application	text
16	API docs ➚	text
17	def-db-fns-from-string ➚	text
18	def-sqlvec-fns-from-string ➚	text
19	map-of-db-fns ➚	text
20	map-of-sqlvec-fns ➚	text
21	map-of-db-fns-from-string ➚	text
22	map-of-sqlvec-fns-from-string ➚	text
23	sqlvec and alias snip ➚	text
24	sqlvec-fn and alias snip-fn ➚	text
25	db-run ➚	text
26	db-fn ➚	text
27	Postgresql supports this	text
28	another library	text
29	clojure.java.jdbc changelog	text
30	clojure.java.jdbc	text
31	clojure.java.jdbc	text
32	next.jdbc	text
33	clojure.jdbc	text
34	hugsql.adapter/HugsqlAdapter protocol	text
35	clojure.java.jdbc	text
36	next.jdbc	text
37	clojure.jdbc	text
38	HugSQL Adapter for postgres.async	text
39	HugSQL Adapter for ClickHouse	text
40	Add an issue	text
41	Yesql	text
42	adapter for postgres.async	text
43	map-of-db-fns	text
44	conman	text
45	Add an issue!	text
46	File an issue.	text
47	Honey SQL	text
48	SQL parameter binding	text
49	Layerware, Inc.	text
50	Apache License, Version 2.0	text
51	Layerware, Inc.	text