[B! SQL] nsyeeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nsyee id:nsyee

SQLã«é–¢ã™ã‚‹nsyeeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (90)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLç”¨SQLãƒ•ã‚¡ã‚¤ã‚¢ãƒ¼ã‚¦ã‚©ãƒ¼ãƒ«ã€Œsql_firewallã€ãƒªãƒªãƒ¼ã‚¹
å…ˆæ—¥ã€sql_firewallã¨ã„ã†PostgreSQLã®æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼ˆEXTENSIONï¼‰ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ https://news.ycombinator.com/it em?id=10109566 https://github.com/uptimejp/sql_firewall ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€PostgreSQLä¸Šã§å®Ÿè¡Œå¯èƒ½ãªSQLã‚’åˆ¶é™ã™ã‚‹ã“ã¨ã§ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ãã“ã¨ã‚’ç›®çš„ã¨ã—ãŸã‚‚ã®ã§ã™ã€‚ ä»Šå›žã¯ã“ã® sql_firewall ã«ã¤ã„ã¦ã€ãã®ä»•çµ„ã¿ã¨ä½¿ã„æ–¹ã‚’ç°¡å˜ã«ã”ç´¹ä»‹ã—ã¾ã™ã€‚ â– sql_fiewallã®ä»•çµ„ã¿ sql_firewallã«ã¯ã€ä»¥ä¸‹ã®3ã¤ã®å‹•ä½œãƒ¢ãƒ¼ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ å¦ç¿’ãƒ¢ãƒ¼ãƒ‰ï¼ˆlearningï¼‰ è¦å‘Šãƒ¢ãƒ¼ãƒ‰ï¼ˆpermissiveï¼‰ é˜²å¾¡ãƒ¢ãƒ¼ãƒ‰ï¼ˆenforcingï¼‰ å¦ç¿’ãƒ¢ãƒ¼ãƒ‰ã§ã¯PostgreSQLä¸Šã§å®Ÿè¡Œå¯èƒ½ãªSQLæ–‡ã‚’å¦ç¿’ã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚
nsyee 2015/08/28
postgresql

machine-learning

security

SQL
ãƒªãƒ³ã‚¯
SQL style guide by Simon Holywell
Overview General Do Avoid Naming conventions General Tables Columns Aliasing or correlations Stored procedures Uniform suffixes Query syntax Reserved words White space Indentation Preferred formalisms Create syntax Choosing data types Specifying default values Constraints and keys Designs to avoid Appendix Reserved keyword reference Column data types SQL style guide Overview You can use this set o
nsyee 2015/07/28
SQL

coding-style
ãƒªãƒ³ã‚¯
å·¨å¤§ãªãƒãƒƒãƒã‚’åˆ†å‰²ã—ã¦æ§‹æˆã™ã‚‹ ã€œSQLãƒãƒƒãƒãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯Bricolageã€œ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã®é’æœ¨å³°éƒŽï¼ˆid:mineroaokiï¼‰ã§ã™ã€‚ å¥½ããªRubyã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯10å¹´å‰ã‹ã‚‰String#slice(re, nth)ã§ã™ãŒã€ æœ€è¿‘ã¯Rubyã‚ˆã‚ŠCoffeeScriptã¨SQLã®ã»ã†ãŒæ›¸ãé‡ãŒå¤šãã¦æ‚©ã‚“ã§ã„ã¾ã™ã€‚ ä»Šæ—¥ã¯ã‚ãŸã—ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã€ŒãŸã¹ã¿ã‚‹ã€ã®èƒŒå¾Œã§åƒã„ã¦ã„ã‚‹ å·¨å¤§ãƒãƒƒãƒã®æ§‹æˆã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã¹ã¿ã‚‹ã®ãƒãƒƒãƒã¯ç´„3000è¡Œã®SQLã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ å‡¦ç†æ™‚é–“ãŒ1æ—¥ã§4æ™‚é–“ç¨‹åº¦ã‹ã‹ã‚‹ã€ãã“ãã“ã®è¦æ¨¡ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ ã“ã®ãƒãƒƒãƒå‡¦ç†ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’Bricolageï¼ˆãƒ–ãƒªã‚³ãƒ©ãƒ¼ã‚¸ãƒ¥ï¼‰ã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§æ§‹é€ åŒ–ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¨ã¯ ã¾ãšæœ€åˆã«ã€ã€ŒãŸã¹ã¿ã‚‹ã€ãŒã©ã†ã„ã†ã‚‚ã®ãªã®ã‹ã”ãç°¡å˜ã«ãŠè©±ã—ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã€ŒãŸã¹ã¿ã‚‹ã€ã¯ä¼æ¥ã®ã¿ã«æä¾›ã—ã¦ã„ã‚‹B2Bã®åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã§ã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ãƒ¬ã‚·ãƒ”æ¤œç´¢ã®åˆ†æžã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾
nsyee 2015/07/03
SQL

batch
ãƒªãƒ³ã‚¯
Apache Drill 1.0ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã§Amazon S3ã¨é€£æºã—ã¦ã¿ãŸ | DevelopersIO
ã¯ã˜ã‚ã« Apache Drill 1.0ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸï¼ Drill 1.0 Released Apache Drillã¯ã€NoSQLå‘ã‘ã®SQLã‚¯ã‚¨ãƒªã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ä¸Šã®JSON/CSV/Parquetãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã€Hiveã‚½ãƒ¼ã‚¹ã€HBaseã€Mongo DBãªã©ã«ç›´æŽ¥SQLã‚¯ã‚¨ãƒªã‚’æŠ•ã’ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ä½•ã¯ã¨ã‚‚ã‚ã‚Œã€è§¦ã£ã¦ã¿ãªã„ã¨ã©ã‚“ãªãƒ¢ãƒŽãªã®ã‹ã‚ã‹ã‚Šã¾ã›ã‚“ã€‚æ—©é€Ÿè©¦ã—ã¦ã¿ã¾ã—ãŸï¼ ã‚„ã£ã¦ã¿ãŸ è©¦ã—ãŸç’°å¢ƒã¯EC2(on Amazon Linux 2015.03)ã§ã™ã€‚ ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— Drillã®å‹•ä½œã«ã¯JDK 7ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã®ã§ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã™ã€‚ $ java -version java version "1.7.0_79" OpenJDK Runtime Environment (amzn-2.5.5.1.59.amzn1-x86_64
nsyee 2015/05/22
Drill

S3

csv

SQL
ãƒªãƒ³ã‚¯
TOTO88 | Bocoran Slot Gacor Hari Ini
Mencari slot gacor hari ini? Anda berada di tempat yang tepat! Dalam dunia perjudian online, istilah "gacor" sering digunakan untuk menggambarkan slot yang sedang "panas" atau memiliki peluang tinggi untuk memberikan kemenangan besar kepada pem ain. Dalam artikel panjang ini, kita akan membahas segala sesuatu tentang slot gacor: cara menemukannya, strategi untuk bermain, dan tentu saja, rekomendasi
nsyee 2015/04/26
postgresql

SQL

event-stream
ãƒªãƒ³ã‚¯
Redirecting to https://sqlpad.github.io/sqlpad/#/
nsyee 2015/02/03
SQL

visualization

GUI
ãƒªãƒ³ã‚¯
http://kwatch.houkagoteatime.net/blog/2014/12/20/postgresql-features/
nsyee 2015/01/18
postgresql

SQL
ãƒªãƒ³ã‚¯
postgresql-typed
nsyee 2015/01/05
haskell

postgresql

type-check

SQL
ãƒªãƒ³ã‚¯
HRR: Project top page
What is HRR? Haskell Relational Record (HRR) is a query generator based on typed relational algebra and correspondence between SQL value lists and Haskell record types, which provide programming interfaces to Relational DataBase Management Systems (RDBMS). Abstracted - relations are expressed as high level expressions and they are translated into SQL statements. Drivers are provided for DB2, Postg
nsyee 2014/12/12
haskell

SQL
ãƒªãƒ³ã‚¯
zshã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«MySQLã«ã‚¯ã‚¨ãƒªã‚’æŠ•ã’ã‚‹ã®è¡“ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
nsyee 2014/12/05
zsh

mysql

SQL

shell
ãƒªãƒ³ã‚¯
opaleye
An SQL-generating DSL targeting PostgreSQL. Allows Postgres queries to be written within Haskell in a typesafe and composable fashion. [Skip to Readme] OpaleyeOpaleye.AdaptorsOpaleye.AggregateOpaleye.BinaryOpaleye.ColumnOpaleye.DistinctOpaleye.ExistsExperimentalOpaleye.Experimental.EnumOpaleye.FieldOpaleye.FunctionalJoinInternalOpaleye.Internal.AggregateOpaleye.Internal.BinaryOpaleye.Internal.Colu
nsyee 2014/12/02
SQL

DSL

postgresql

haskell
ãƒªãƒ³ã‚¯
ã‚ãªãŸãŒçŸ¥ã‚‰ãªã„ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«
1. ã‚ãªãŸãŒçŸ¥ã‚‰ãªã„ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ« @dbtech showcase tokoy 2014 å¥¥é‡Ž å¹¹ä¹Ÿ Twitter: @nippondanji mikiya (dot) okuno (at) gmail (dot) com 3. è‡ªå·±ç´¹ä»‹ â— MySQL ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ â€“ æ—¥ã€…ã®ã—ã”ã¨ â— ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°å…¨èˆ¬ â— Q&Aå›žç” â— ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ãªã© â— ãƒ©ã‚¤ãƒ•ãƒ¯ãƒ¼ã‚¯ â€“ è‡ªç”±ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®æ™®åŠ â— ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã¯ãªã„ â— ãƒ–ãƒã‚° ä»Šæ—¥ã¯å€‹äººã¨ã—ã¦ å‚åŠ ã—ã¦ã„ã¾ã™ã€‚ â€“ æ¼¢ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ â€“ http://nippondanji.blogspot.com/
nsyee 2014/11/19
SQL

DB
ãƒªãƒ³ã‚¯
Osquery
nsyee 2014/10/30
Linux

shell

SQL

facebook
ãƒªãƒ³ã‚¯
PIPESQL in Action
nsyee 2014/10/13
SQL

language

DSL
ãƒªãƒ³ã‚¯
Sqitch: Sensible database change management
Sensible database-native change management for framework-free development and dependable deployment. Download New to Sqitch? Organizations and Projects Using Sqitch
nsyee 2014/07/01
DB

SQL

migration
ãƒªãƒ³ã‚¯
Haskell-rerational-recordã§DBæ“ä½œã™ã‚‹ã®ãŒæ¥½ã—ã™ãŽã‚‹ä»¶ã€œãã®ï¼‘ã€œ - Creatable a => a -> IO b
ã©ãƒ¼ã‚‚ã€ã„ã¤ã‚‚ã®ã¡ã‚…ãƒ¼ã‚“ã•ã‚“ã§ã™ã€‚ ä¸€ãƒ¶æœˆãã‚‰ã„å‰ã«ã€ã‚‚ãã‚‚ãHaskellä¼šã¨ã„ã†ãƒãƒƒã‚«ã‚½ãƒ³ã§æ—¥æ¯”é‡Žã•ã‚“(@khibino)ã¨ã”ä¸€ç·’ã—ãŸã®ã§ã€ æ—¥æ¯”é‡Žã•ã‚“ã®é–‹ç™ºã—ãŸhaskell-rerational-record(ä»¥ä¸‹HRR)ã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ï¼ˆè‰²ã€…æ•™ã‚ã‚Šã¾ãã‚Šã¤ã¤ï¼‰ã„ã˜ã„ã˜ã—ã¦ã„ã¾ã—ãŸã€‚ ãŠä»•äº‹ã®ã¡ã‚…ãƒ¼ã‚“ã•ã‚“ã¯ã‚ã‚Šã¨ã‚´ãƒªã‚´ãƒªSQLã‚’æ›¸ãã‚ã‘ã§ã™ã‘ã©ã€ã‚ã®ã€ã‚ã‚Œã§ã™ã‚ˆã€è¾›ã„ã‚“ã§ã™ã€‚ ã‚‚ãã‚‚ãä¼šã§ã‚‚æ—¥æ¯”é‡Žã•ã‚“ã¨åªç®¡æ„šç—´ã‚Šã¾ãã£ã¦ã¾ã—ãŸã‘ã©ã€SQLã¨ã‹ãã€ã“ã‚“ãªã‚‚ã®äººé–“ã®æ›¸ãã‚‚ã®ã˜ã‚ƒãªã„ã§ã™ã€‚ ãï¼Ÿ ãã‚“ãªã‚ã‘ã§ã€Haskellã‚’ç”¨ã„ã¦å¦‚ä½•ã«è‹¦ã—ã¾ãšæ¥½ã—ãRDBã¨æˆ¯ã‚Œã‚‹ã‹ã€ã¨ã„ã†ã®ãŒæœ¬æ—¥ã®ãŠé¡Œã§ã™ã€‚ HRRã®ç‰¹å¾´ åŸºæœ¬çš„ã«ã¯SQLã‚’ãƒ¢ãƒŠãƒ‡ã‚£ãƒƒã‚¯ã«ç”Ÿæˆã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€‚ æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§å¿…è¦ã«ãªã‚‹ã‚ˆã†ãªã»ã¨ã‚“ã©ã®ã‚¯ã‚¨ãƒªã¯ã“ã‚Œã ã‘ã§æ›¸ãäº‹ãŒã§ãã¾ã™ã€‚ HRRã«ã¯ã€ã–ã£ã¨æ¬¡ã®ã‚ˆã†ãª
nsyee 2014/06/21
haskell

HRR

SQL
ãƒªãƒ³ã‚¯
Presto: Free, Open-Source SQL Query Engine for any Data
Calling our Presto community speakers â€“ we want to hear from you! Fill out out community call for papers to speak at upcoming meetups andÂ conferences. What is Presto?Presto is an open source SQL query engine thatâ€™s fast, reliable, and efficient at scale. Use Presto to run interactive/ad hoc queries at sub-second performance for your high volume apps.
nsyee 2014/06/21
Presto

facebook

SQL

distributed
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
nsyee 2014/06/11
haskell

SQL
ãƒªãƒ³ã‚¯
DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains
A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux.
nsyee 2014/06/10
SQL

IDE

IntelliJ
ãƒªãƒ³ã‚¯
Citus Data | Distributed Postgres. At any scale.
POSETTE: An Event for Postgres 2025 will happen virtually Jun 10-12, 2025. Call for Speakers is open!Â ðŸ’¥
nsyee 2014/06/05
CitusDB

SQL

distributed
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸