並び順

ブックマーク数

期間指定

  • から
  • まで

1 - 28 件 / 28件

新着順 人気順

sql server query comment outの検索結果1 - 28 件 / 28件

  • 関数名、メソッド名、変数名でよく使う英単語のまとめ

    プログラミングをしていると関数名、メソッド名、変数名をどうするか悩みます。 ロジックより命名に時間を費やすこともざらにあります。翻訳したり、一般的な命名規則なのかいつも検索して大変です。 よく使うサイトの内容をコピってメモしておく 関数名とメソッド名の違いについて よく使う英単語のまえに、いつもごっちゃにして使っているけど、定義はこんな感じ 「関数」と「メソッド」の違い 似ているところ どちらも何か(引数)を入れると処理をして何か(戻り値)を返してくれます。 違うところ やってること自体は大差ありません。概念としては違います。 メソッドはオブジェクト指向で登場する用語で、オブジェクトの動作を定義したものです。 まずオブジェクトありきなのですね。一方の関数は、オブジェクト云々は関係ありません。 個人的な使い分け Java で登場する関数は「メソッド」です。C 言語で登場する関数は「関数」と呼

      関数名、メソッド名、変数名でよく使う英単語のまとめ
    • How I built a modern website in 2021

      How I built a modern website in 2021September 29th, 2021 — 34 min read For over half of 2021, I worked on a complete rewrite of kentcdodds.com. You're reading this on the rewrite of this site! Are you using dark mode or light mode? Have you signed in and selected your team yet? Have you tried to call into the Call Kent Podcast? This blog post isn't about these and other features of the new site, b

        How I built a modern website in 2021
      • MySQL JOIN Types Poster - Steve Stedman

        So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and I keep it posted on the wall at the office. This way when I am trying to explain JOIN types, I just refer to the poster. I have created the poster below to help describe JOIN types in My S

          MySQL JOIN Types Poster - Steve Stedman
        • Databases in 2022: A Year in Review

          Another year has gone by, and I’m still alive. As such, it is an excellent time to reflect on what happened in the world of databases last year. It was quiet in the streets as the benchmark wars between DBMS vendors have quieted down. I had fun writing last year’s retrospective, so I am excited to share with you the things that stand out from 2022 and my thoughts on them. Big Database Funding Has

            Databases in 2022: A Year in Review
          • 実例で学ぶ MySQL/MariaDB デバッグ - nayuta-yanagisawa's blog

            この記事では、MySQL/MariaDB のバグを修正するための典型的な手順を、具体例を通して解説する。次の MariaDB のバグを例として取り上げるが、基本的なデバッグの手順は MySQL でもまったく同様である。 MDEV-24868: Server crashes in optimize_schema_tables_memory_usage after select from information_schema.innodb_sys_columns なお、MySQL/MariaDB のデバッグ方法についての包括的な解説を与えるのは、この記事のスコープ外である。デバッグ手法の詳細を知りたい場合は、以下の一連の記事を参照してほしい。 Debugging MySQL/MariaDB (1): Build and Test Debugging MySQL/MariaDB (2): DBU

              実例で学ぶ MySQL/MariaDB デバッグ - nayuta-yanagisawa's blog
            • Using go fix to modernize Go code - The Go Programming Language

              The Go Blog Using go fix to modernize Go code Alan Donovan 17 February 2026 The 1.26 release of Go this month includes a completely rewritten go fix subcommand. Go fix uses a suite of algorithms to identify opportunities to improve your code, often by taking advantage of more modern features of the language and library. In this post, we’ll first show you how to use go fix to modernize your Go code

                Using go fix to modernize Go code - The Go Programming Language
              • Go 1.17 Release Notes - The Go Programming Language

                Introduction to Go 1.17 The latest Go release, version 1.17, arrives six months after Go 1.16. Most of its changes are in the implementation of the toolchain, runtime, and libraries. As always, the release maintains the Go 1 promise of compatibility. We expect almost all Go programs to continue to compile and run as before. Changes to the language Go 1.17 includes three small enhancements to the l

                  Go 1.17 Release Notes - The Go Programming Language
                • Mastodon: Ruby on Rails Open Source Web App

                  The product https://joinmastodon.org Mastodon is a free, open-source social network server based on ActivityPub where users can follow friends and discover new ones. On Mastodon, users can publish anything they want: links, pictures, text, and video. All Mastodon servers are interoperable as a federated network. Open source The project is open source at https://github.com/mastodon/mastodon License

                    Mastodon: Ruby on Rails Open Source Web App
                  • Parsing SQL - Strumenta

                    The code for this tutorial is on GitHub: parsing-sql SQL is a language to handle data in a relational database. If you worked with data you have probably worked with SQL. In this article we will talk about parsing SQL. It is in the same league of HTML: maybe you never learned it formally but you kind of know how to use it. That is great because if you know SQL, you know how to handle data. However

                      Parsing SQL - Strumenta
                    • The Part of PostgreSQL We Hate the Most

                      This article was written in collaboration with Bohan Zhang and originally appeared on the OtterTune website. There are a lot of choices in databases (897 as of April 2023). With so many systems, it’s hard to know what to pick! But there is an interesting phenomenon where the Internet collectively decides on the default choice for new applications. In the 2000s, the conventional wisdom selected MyS

                        The Part of PostgreSQL We Hate the Most
                      • A can of shardines: SQLite multitenancy with Rails

                        There is a pattern I am very fond of - “one database per tenant” in web applications with multiple, isolated users. Recently, I needed to fix an application I had for a long time where this database-per-tenant multitenancy utterly broke down, because I was doing connection management wrong. Which begat the question: how do you even approach doing it right? And it turns out I was not alone in this.

                        • やられAWS環境「AWSGoat」でペンテストを学習 - まったり技術ブログ

                          ⚠️ AWSGoat Module 2 のネタバレあり はじめに AWSGost とは 攻撃方法の分類 インフラの料金 ラボ環境の構築 AWSGost リポジトリをフォーク Actions secrets でクレデンシャルを設定 GitHub Actions でデプロイ Module 2の大体の流れ Step 1. SQL Injection 解法 脆弱性があるコード Step 2. File Upload and Task Metadate リバースシェルの用意 待ち受け側 Step 3. ECS Breakout and Instance Metadata 現ユーザの権限を確認 リソースへのアクセスを試行 ケイパビリティを確認 (www-data ユーザ) コンテナ内でroot権限を取得 sudo可能なコマンドを確認 Vim経由でroot権限のシェルを取得 ケイパビリティを確認 (ro

                            やられAWS環境「AWSGoat」でペンテストを学習 - まったり技術ブログ
                          • Lesser Known PostgreSQL Features

                            In 2006 Microsoft conducted a customer survey to find what new features users want in new versions of Microsoft Office. To their surprise, more than 90% of what users asked for already existed, they just didn't know about it. To address the "discoverability" issue, they came up with the "Ribbon UI" that we know from Microsoft Office products today. Office is not unique in this sense. Most of us ar

                              Lesser Known PostgreSQL Features
                            • ChatGPT Containers can now run bash, pip/npm install packages, and download files

                              Sponsored by: Teleport — Secure, Govern, and Operate AI at Engineering Scale. Learn more ChatGPT Containers can now run bash, pip/npm install packages, and download files 26th January 2026 One of my favourite features of ChatGPT is its ability to write and execute code in a container. This feature launched as ChatGPT Code Interpreter nearly three years ago, was half-heartedly rebranded to “Advance

                                ChatGPT Containers can now run bash, pip/npm install packages, and download files
                              • What's New in Emacs 28.1?

                                Try Mastering Emacs for free! Are you struggling with the basics? Have you mastered movement and editing yet? When you have read Mastering Emacs you will understand Emacs. It’s that time again: there’s a new major version of Emacs and, with it, a treasure trove of new features and changes. Notable features include the formal inclusion of native compilation, a technique that will greatly speed up y

                                • Ubuntu 24.04 LTS (Noble Numbat) Release Notes

                                  Noble Numbat Release Notes Table of Contents Introduction New features in 24.04 LTS Known Issues Official flavours More information Introduction These release notes for Ubuntu 24.04 LTS (Noble Numbat) provide an overview of the release and document the known issues with Ubuntu and its flavours. For details of the changes applied since 24.04, please see the 24.04.2 change summary. Support lifespan

                                  • 週刊Railsウォッチ: Rack 3アップグレードガイド、Stimpack gemほか(20220926前編)|TechRacho by BPS株式会社

                                    週刊Railsウォッチについて 各記事冒頭には🔗でパーマリンクを置いてあります: 社内やTwitterでの議論などにどうぞ 「つっつきボイス」はRailsウォッチ公開前ドラフトを(鍋のように)社内有志でつっついたときの会話の再構成です👄 お気づきの点がありましたら@hachi8833までメンションをいただければ確認・対応いたします🙏 TechRachoではRubyやRailsなどの最新情報記事を平日に公開しています。TechRacho記事をいち早くお読みになりたい方はTwitterにて@techrachoのフォローをお願いします。また、タグやカテゴリごとにRSSフィードを購読することもできます(例:週刊Railsウォッチタグ) 🔗Rails: 先週の改修(Rails公式ニュースより) 公式更新情報: Ruby on Rails — Bugfixes, improvements an

                                      週刊Railsウォッチ: Rack 3アップグレードガイド、Stimpack gemほか(20220926前編)|TechRacho by BPS株式会社
                                    • In-depth Guide to ActiveRecord load_async in Rails 7

                                      The In-depth Guide to ActiveRecord load_async in Rails 7 Updated Mar 1, 2022 17 minute read Rails 7 introduces ActiveRecord load_async method that runs SQL queries asynchronously in the background thread. This seemingly simple change of just adding a single new method that takes no arguments has profound implications for database layer interactions. In this tutorial, we’ll deep dive into the intri

                                        In-depth Guide to ActiveRecord load_async in Rails 7
                                      • GitHub - taishi-i/awesome-ChatGPT-repositories: A curated list of resources dedicated to open source GitHub repositories related to ChatGPT and OpenAI API

                                        awesome-chatgpt-api - Curated list of apps and tools that not only use the new ChatGPT API, but also allow users to configure their own API keys, enabling free and on-demand usage of their own quota. awesome-chatgpt-prompts - This repo includes ChatGPT prompt curation to use ChatGPT better. awesome-chatgpt - Curated list of awesome tools, demos, docs for ChatGPT and GPT-3 awesome-totally-open-chat

                                          GitHub - taishi-i/awesome-ChatGPT-repositories: A curated list of resources dedicated to open source GitHub repositories related to ChatGPT and OpenAI API
                                        • 週刊Railsウォッチ: マイグレーションをStrategyパターンで拡張可能にほか(20220704前編)|TechRacho by BPS株式会社

                                          週刊Railsウォッチについて 各記事冒頭には🔗でパーマリンクを置いてあります: 社内やTwitterでの議論などにどうぞ 「つっつきボイス」はRailsウォッチ公開前ドラフトを(鍋のように)社内有志でつっついたときの会話の再構成です👄 お気づきの点がありましたら@hachi8833までメンションをいただければ確認・対応いたします🙏 TechRachoではRubyやRailsなどの最新情報記事を平日に公開しています。TechRacho記事をいち早くお読みになりたい方はTwitterにて@techrachoのフォローをお願いします。また、タグやカテゴリごとにRSSフィードを購読することもできます(例:週刊Railsウォッチタグ) 🔗Rails: 先週の改修(Rails公式ニュースより) 参考: Comparing @{2022-06-23}...main@{2022-06-30} ·

                                            週刊Railsウォッチ: マイグレーションをStrategyパターンで拡張可能にほか(20220704前編)|TechRacho by BPS株式会社
                                          • Spring AIとgpt-ossでプライベートAIアプリを作るチュートリアル - IK.AM

                                            gpt-ossの登場により、プライベートAIアプリでもそこそこの品質が期待できるようになりました。 改めて、Spring AIで簡単なAIアプリを作ってみましょう。利用するバージョンはSpring Boot 3.5、Spring AI 1.1です。 gpt-ossをOpenAI API互換で利用できる基盤として今回はOllamaを使います。 なお、本記事の内容はプライベートAIでなくてももちろん利用可能です。 目次 チュートリアルのゴールOllamaのインストールモデルのロードOllamaのOpenAI APIの動作確認Spring AIアプリの雛形作成ChatClientの利用Chat APIのHTTPログを確認Structured Outputの利用Chat Memoryの利用VectorStoreの利用ファイルからドキュメントをロード関連するドキュメントをChat APIのプロンプト

                                              Spring AIとgpt-ossでプライベートAIアプリを作るチュートリアル - IK.AM
                                            • June 2025 (version 1.102)

                                              Release date: July 9, 2025 Update 1.102.1: The update addresses these issues. Update 1.102.2: The update addresses these issues. Update 1.102.3: The update addresses these issues. Downloads: Windows: x64 Arm64 | Mac: Universal Intel silicon | Linux: deb rpm tarball Arm snap Welcome to the June 2025 release of Visual Studio Code. There are many updates in this version that we hope you'll like, some

                                                June 2025 (version 1.102)
                                              • January 2022 (version 1.64)

                                                Update 1.64.1: The update addresses these security issues. Update 1.64.2: The update addresses these issues. Downloads: Windows: x64 Arm64 | Mac: Universal Intel silicon | Linux: deb rpm tarball Arm snap Welcome to the January 2022 release of Visual Studio Code. There are many updates in this version that we hope you will like, some of the key highlights include: New Side Panel - Display more view

                                                  January 2022 (version 1.64)
                                                • Yandex scrapes Google and other SEO learnings from the source code leak

                                                  Search Engine Land » SEO » Yandex scrapes Google and other SEO learnings from the source code leak Yandex scrapes Google and other SEO learnings from the source code leak Yandex isn't Google, but there is a lot SEOs can learn about how a modern search engine is built from reviewing this codebase. “Fragments” of Yandex’s codebase leaked online last week. Much like Google, Yandex is a platform with

                                                    Yandex scrapes Google and other SEO learnings from the source code leak
                                                  • 週刊Railsウォッチ: Arel::Nodes::NodeにAPIドキュメントが追加、rubocop-mdほか(20230405前編)|TechRacho by BPS株式会社

                                                    こんにちは、hachi8833です。RubyKaigi 2023の各種イベントが発表されていますね。 People are returning back to in-person conference. What about social events? Check out https://t.co/ubqYPF2oKo for tentative schedule of parties and related events! #rubykaigi — RubyKaigi (@rubykaigi) March 10, 2023 参考: Ruby on Rails | endoflife.date ひさびさにLightning Talkも #rubykaigi に帰ってきた〜 🤩 日/英可, 4/19まで!!! :gong: "Your talk can be spoken in eith

                                                      週刊Railsウォッチ: Arel::Nodes::NodeにAPIドキュメントが追加、rubocop-mdほか(20230405前編)|TechRacho by BPS株式会社
                                                    • Sketch of a Post-ORM

                                                      I’ve been writing a lot of database access code as of late. It’s frustrating that in 2023, my choices are still to either write all of the boilerplate by hand, or hand all database access over to some inscrutable “agile” ORM that will become a crippling liability in the 2-3y timescale. This post is about how I want to use databases, from the perspective of an application server developer—not a DBA

                                                        Sketch of a Post-ORM
                                                      • PgBouncer is useful, important, and fraught with peril

                                                        Updated 2024-09-17 to reflect updated PgBouncer support for protocol-level prepared statements 🐘 To start, I want to say that I’m appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and I’m thankful for the incredible amount of work and improvements that go into it as well. I also think community and industry enthusiasm aro

                                                          PgBouncer is useful, important, and fraught with peril
                                                        • SQL to NoSQL: Modernizing data access layer with Amazon DynamoDB | Amazon Web Services

                                                          AWS Database Blog SQL to NoSQL: Modernizing data access layer with Amazon DynamoDB In Part 1 of our series, we explored how to effectively migrate from SQL to Amazon DynamoDB. After establishing data modeling strategies discussed in Part 2, we now explore key considerations to analyze and design filters, pagination, edge cases, and aggregations, building upon the data models designed to create an

                                                            SQL to NoSQL: Modernizing data access layer with Amazon DynamoDB | Amazon Web Services
                                                          1