並び順

ブックマーク数

期間指定

  • から
  • まで

1 - 28 件 / 28件

新着順 人気順

compatibility level sql server queryの検索結果1 - 28 件 / 28件

  • Announcing a new IDE for PostgreSQL in VS Code from Microsoft | Microsoft Community Hub

    Announcing a new IDE for PostgreSQL in VS Code from Microsoft We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows. With this extension, you can now manage database objects, draft queries with intelligent assistance from context-aware IntelliSense and our ‘

      Announcing a new IDE for PostgreSQL in VS Code from Microsoft | Microsoft Community Hub
    • Modern Node.js Patterns for 2025

      Node.js has undergone a remarkable transformation since its early days. If you’ve been writing Node.js for several years, you’ve likely witnessed this evolution firsthand—from the callback-heavy, CommonJS-dominated landscape to today’s clean, standards-based development experience. The changes aren’t just cosmetic; they represent a fundamental shift in how we approach server-side JavaScript develo

      • Databases in 2024: A Year in Review

        Like a shot to your dome piece, I'm back to hit you with my annual roundup of what happened in the rumble-tumble game of databases. Yes, I used to write this article on the OtterTune blog, but the company is dead (RIP). I'm doing this joint on my professor blog. There is much to cover from the past year, from 10-figure acquisitions, vendors running wild in the streets with license changes, and the

          Databases in 2024: A Year in Review
        • Your URL Is Your State

          Couple of weeks ago when I was publishing The Hidden Cost of URL Design I needed to add SQL syntax highlighting. I headed to PrismJS website trying to remember if it should be added as a plugin or what. I was overwhelmed with the amount of options in the download page so I headed back to my code. I checked the file for PrismJS and at the top of the file, I found a comment containing a URL: /* http

          • 缶つぶし機とソフトウェア移行技術 - Refactoring to Rust の読書感想文 - じゃあ、おうちで学べる

            はじめに ——あるいは、「知っている」と「理解している」の間 Rustのことは、知っていた。学習もしていた。実務でも使っていた。 でも、それは知っているつもりだった。 知ってるつもり 無知の科学 (ハヤカワ文庫NF) 作者:スティーブン スローマン,フィリップ ファーンバック早川書房Amazon 日々Rustで開発し、BoxとRcとArcを使い分け、tokio::spawnでタスクを生成し、?演算子を当たり前のように書いている。FFI?PyO3使えばいいでしょ。WebAssembly?wasm-bindgenがあるじゃない。技術的には、確かに「使える」レベルにはあった。 でも、心のどこかで感じていた違和感があった。 オートバイのエンジンを分解できる人と、エンジンが動く原理を理解している人は違う。コードが動くことと、なぜそう書くべきかを理解することも違う。私は前者だった。メカニックではあった

              缶つぶし機とソフトウェア移行技術 - Refactoring to Rust の読書感想文 - じゃあ、おうちで学べる
            • 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
              • Introducing Limbo: A complete rewrite of SQLite in Rust

                Dec 10, 2024 Introducing Limbo: A complete rewrite of SQLite in Rust 2 years ago, we forked SQLite. We were huge fans of the embedded nature of SQLite, but longed for a more open model of development. libSQL was born as an Open Contribution project, and we invited the community to build it with us. As a result, libSQL is an astounding success. With over 12k GitHub stars, 85 contributors, and featu

                  Introducing Limbo: A complete rewrite of SQLite in Rust
                • 歴史・年表でみるAWS全サービス一覧(参考資料編) -アナウンス日、General Availability(GA)の参考URL- - NRIネットコムBlog

                  小西秀和です。 歴史・年表でみるAWS全サービス一覧 -アナウンス日、General Availability(GA)、AWSサービス概要のまとめの記事で参考にしたURLが多すぎるため、こちらに別記事としてまとめました。 AWSサービスの概要など「歴史・年表でみるAWS全サービス一覧」のメインコンテンツは本編を御覧ください。 ただ、見方によってはこの記事の方が面白いかもしれません。 [English Edition] AWS History and Timeline - Almost All AWS Services List, Announcements, General Availability(GA) AWS全サービスの歴史年表に記載したアナウンス日・GA日(一般提供開始日)の参考URL 「What's New」のURL(例:https://aws.amazon.com/about-

                    歴史・年表でみるAWS全サービス一覧(参考資料編) -アナウンス日、General Availability(GA)の参考URL- - NRIネットコムBlog
                  • Rails 8.0 Changelog(全項目リンク付き)|TechRacho by BPS株式会社

                    【速報】Rails 8.0.0がリリースされました Rails 8.0(v8.0.0タグ)は、7.2.0リリースから半年後のリリースということもあり、メジャーリリースとしてはChangelogの変更件数が少なめなのが特徴です。機能面では、Strong Parametersのexpect追加や、MySQL 5.5のサポート廃止が目につきます。大きなbreaking changesも今のところ見当たりません。 rails/rails at v8.0.0 以下、Rails 8.0のChangelogを件数の多い順に見ていきます。なお、原則として削除のChangelogは、その項目が非推奨化されたときのプルリク情報にリンクしています。 なお、以下の機能にはChangelogがありません。 Action Mailbox Action Mailer 🔗 Active Record(56件) Rail

                      Rails 8.0 Changelog(全項目リンク付き)|TechRacho by BPS株式会社
                    • Google I/O 2022で驚いたところ - Qiita

                      Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? 個人的に驚いたところを太字にしておきます。 AndroidのエンジニアなのでAndroidに関するものが多めです。専門領域外のものはかなり素人目線のただの感想が多いです。なにか大きな間違などがあればご指摘お願いします。修正いたします。 またまだ見ていきますが、一旦、 Keynote Developer Keynote What's new in Android What's new in Jetpack What's new in Development tool Lazy layouts in Compose Fragments: T

                        Google I/O 2022で驚いたところ - Qiita
                      • Manus tools and prompts

                        agent loop ���� �G�� You are Manus, an AI agent created by the Manus team. You excel at the following tasks: 1. Information gathering, fact-checking, and documentation 2. Data processing, analysis, and visualization 3. Writing multi-chapter articles and in-depth research reports 4. Creating websites, applications, and tools 5. Using programming to solve various problems beyond development 6. Vario

                          Manus tools and prompts
                        • Against SQL

                          TLDR The relational model is great: A shared universal data model allows cooperation between programs written in many different languages, running on different machines and with different lifespans. Normalization allows updating data without worrying about forgetting to update derived data. Physical data independence allows changing data-structures and query plans without having to change all of y

                          • iOS Hacking - A Beginner’s Guide to Hacking iOS Apps [2022 Edition]

                            My first post will be about iOS Hacking, a topic I’m currently working on, so this will be a kind of gathering of all information I have found in my research. It must be noted that I won’t be using any MacOS tools, since the computer used for this task will be a Linux host, specifically a Debian-based distribution, in this case, Kali Linux. I will also be using ‘checkra1n’ for the device jailbreak

                            • 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

                              • Go 1.22 Release Notes - The Go Programming Language

                                Introduction to Go 1.22 The latest Go release, version 1.22, arrives six months after Go 1.21. 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.22 makes two changes to “for” loops. Previous

                                  Go 1.22 Release Notes - The Go Programming Language
                                • ep167 Yearly Ecosystem 2024 | mozaic.fm

                                  Theme 第 167 回のテーマは 2024 年の Yearly Ecosystem です。 Show Note 2024 年のチェックポイント Vite の覇権を Turbopack, RSPack が奪えるか? Storybook は覇権をとって、Chromatic もすごくなりそう Next App Router が本当に広がるか RSC 対応の Bundler が増えて Next 以外の解が見れそう アプリケーションの Rust 化くるか? React Forget Figma Config 2024 の Adobe の影響 State Management どうなってく? (Context, Jotai, SWR, Signal) ESLint to flat config or Biome AI driven FE Development CSS の新しい方法論 今年のキーワ

                                    ep167 Yearly Ecosystem 2024 | mozaic.fm
                                  • Does OLAP need an ORM?

                                    TL;DR · ORMs have proven to be useful for many developers in the OLTP/transactional stack (Postgres, MySQL, etc). · OLAP/analytical databases like ClickHouse could potentially benefit from ORM abstractions. · Existing transactional ORMs probably shouldn’t be extended to OLAP due to fundamental differences in semantic meaning between OLTP and OLAP. · Moose OLAP (part of MooseStack) is an open sourc

                                      Does OLAP need an ORM?
                                    • 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

                                      • HTAP Demystified: Defining a Modern Data Architecture

                                        Figure 1. Typical latencies of different database systems. However, this also causes complicated technology stacks and data silos, which limit how fast companies can grow. This calls for a hybrid approach. The beauty of HTAP Regardless of how it is implemented, a modern HTAP architecture typically features cloud scalability, and one data entry with one infrastructure stack. There, OLTP data and OL

                                          HTAP Demystified: Defining a Modern Data Architecture
                                        • Supercharge the One Person Framework with SQLite | Fractaled Mind

                                          Supercharge the One Person Framework with SQLite: Rails World 2024 NOTE: This is an edited transcript of a talk I gave at Rails World 2024. You can watch the full talk on YouTube. From its beginning, Rails has been famous for being a kind of a rocket engine that could propel your idea to astronomic heights at supersonic speed. But, at least for me, it has lately felt like I needed to be a rocket s

                                          • An In-Depth Analysis of Distributed Transaction Solutions

                                            This article summarizes five distributed transaction solutions and analyzes their features. By Daosu This article summarizes five distributed transaction solutions and analyzes their features: XA Specification, TCC, Saga, Local-Message-Based Distributed Transactions, and Transactional-Message-Based Distributed Transactions. Considering its length, I recommend that you add it to your favorites and

                                              An In-Depth Analysis of Distributed Transaction Solutions
                                            • Migrate very large databases to Amazon Aurora MySQL using MyDumper and MyLoader | Amazon Web Services

                                              AWS Database Blog Migrate very large databases to Amazon Aurora MySQL using MyDumper and MyLoader Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud. Aurora combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Aurora provides advanced features such as Amazon Aurora

                                                Migrate very large databases to Amazon Aurora MySQL using MyDumper and MyLoader | Amazon Web Services
                                              • Top 5 MySQL GUI tools in 2021

                                                kevbosaurus for Retool Posted on Oct 26, 2021 • Updated on Oct 27, 2021 • Originally published at retool.com Ahead of Postgres and SQLite, MySQL has been the leading relational database for years. This is corroborated most recently by Stack Overflow's 2021 Developer Survey, in which 50.18 percent of all respondents (73,317) claim to have used MySQL extensively and plan to do so in the coming year.

                                                  Top 5 MySQL GUI tools in 2021
                                                • NoSQL Database Interview Questions for Experienced Candidates

                                                  Here is a list of common NoSQL interview questions with detailed answers for experienced NoSQL Database professionals. Through advanced queries about architecture, optimization, and real-world problem-solving in NoSQL environments, such interviews aim to gauge the candidate’s ability to understand the complexities of NoSQL databases in scalable, high-performance applications. In such interviews, o

                                                    NoSQL Database Interview Questions for Experienced Candidates
                                                  • Android: Interview Questions and Answers

                                                    Here is a list of common Android interview questions with detailed answers to help you prepare for the interview as an Android app developer. This article is designed to assist aspiring Android developers with a comprehensive set of interview questions, covering a wide spectrum of areas including basic programming principles, Android-specific components, design patterns, and best practices in mobi

                                                      Android: Interview Questions and Answers
                                                    • The API database architecture - Stop writing HTTP-GET endpoints

                                                      The API database architecture - Stop writing HTTP-GET endpoints Table of contents Introduction Data retrieval via PostgREST, data modification in the existing backend Compatibility with REST, CQRS and GraphQL Strategies for adapting existing architectures Adapting a monolithic system with a single backend Adapting (domain-driven) microservices with one or more databases Benefits of the API databas

                                                      • Create an Azure OpenAI, LangChain, ChromaDB, and Chainlit chat app in AKS using Terraform | Microsoft Community Hub

                                                        Create an Azure OpenAI, LangChain, ChromaDB, and Chainlit chat app in AKS using Terraform In this sample, I demonstrate how to quickly build chat applications using Python and leveraging powerful technologies such as OpenAI ChatGPT models, Embedding models, LangChain framework, ChromaDB vector database, and Chainlit, an open-source Python package that is specifically designed to create user interf

                                                          Create an Azure OpenAI, LangChain, ChromaDB, and Chainlit chat app in AKS using Terraform | Microsoft Community Hub
                                                        • 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