ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Goal Determine whether GoLand’s ‘Limit page size’ setting reliably bounds result sets when using different JDBC drivers in recent versions. Context GoLand 2023.3 and 2024.2 expose a ‘Limit page size’ option under Settings > Database > Data Editor and Viewer. The IDE uses this value to request a limited block of rows from the server and then paginates c
Goal Confirm that a recovered PostgreSQL database contains the same data as the original production instance while respecting Scalingo’s documented backup behavior. Constraints & Uncertainty Backups are logical dumps with retention governed by the add‑on tier, not user‑configurable. Documentation states restoration is performed by downloading a dump and
My operating system is Linux. I am going to connect Superset to PostgreSQL. PostgreSQL port is open and its value is 5432. PostgreSQL is also running and not closed. Unfortunately, after a day of research on the Internet, I could not solve the problem and it gives the following error: The port is closed. Database port: command: lsof -i TCP:5432 python3 13127
I want to create an enum column in a Supabase table. Supabase uses Postgres under the hood, so I understand that technically it is possible if I do it manually using SQL. But is there any way I can do it via the frontend in an easier manner?
I'm trying to view the raw data from the AACT Database in pgAdmin 4. I'm on a Mac computer. When I just try to view the first 100 rows from the 'complete_oncology' table, I get the below error: ERROR: permission denied for schema public LINE 1: SELECT * FROM public.complete_oncology ^ SQL state: 42501 Character: 15 Do I have insufficient permissions? If yes,
Goal Ensure that the combined database connection pools used by GitLab Rails/Puma, Sidekiq workers, and Workhorse never exceed the PostgreSQL server’s max_connections limit, preventing intermittent connection pool exhaustion under load. Constraints and uncertainty Each component exposes its own pool setting: gitlab_rails['db_pool'] , sidekiq['db_pool'] , and
Railway utilizes a proxy-based architecture to abstract database connections through internal network layers. While this facilitates seamless deployments, intermittent connection pool exhaustion can occur when the application-side maximum pool size exceeds the limits imposed by the proxy or the database plan. There is a documented uncertainty regarding how t
The Racket db library throws a 'db:connection-closed' exception when a connection is lost during a transaction. The documentation does not specify how retrying such a write should be handled, leaving the developer to decide whether to re‑execute the statement. Re‑execution can result in duplicate rows because the library provides no built‑in duplicate‑write
Magento Schema Change Safety The goal is to determine the native safety mechanisms for database schema modifications within Magento. Constraints and Uncertainty Standard Magento behavior does not provide an automatic rollback for arbitrary schema changes. What specific transactional boundaries are supported by Magento's migration framework across different s
Asked · 26 Sept 2023, 11:24 UTC
answered · 29 Sept 2023, 11:24 UTC
goland
scalingo
postgresql
supabase
gitlab
railway
racket
magento