How Developers Are Syncing Multiple Xero Organisations Into a Single Database

·1 views

Accountants and developers managing multiple Xero organisations face a recurring challenge: Xero's API is designed around one organisation at a time, requiring separate logins and exports for each client. The platform's architecture uses unique tenant IDs per organisation, meaning every API call must specify which organisation it targets, making multi-org consolidation difficult by default. A practical workaround involves storing all organisations' data in a single PostgreSQL database, using a composite primary key of (id, tenant_id) so records from different organisations never collide. A dedicated xero_organisations table can store metadata such as trading names and currencies, replacing opaque GUIDs with readable client identifiers in consolidated queries. This approach replaces manual spreadsheet merges with straightforward SQL filtering and grouping across all connected organisations.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

ShortSingh Skips Meme Monday in Observance of US Labor Day

DEV Community announced a pause on its regular Meme Monday feature this week. The break was taken in observance of Labor Day, a public holiday in the United States. Labor Day is celebrated annually on the first Monday of September. The community acknowledged the holiday with a brief, lighthearted note rather than its usual meme content.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Releases 11 Free Browser-Based Tools to Help Homelab Operators Plan and Debug

A developer has published a suite of eleven free tools at peira.dev/tools designed to answer practical questions that homelab setup guides typically leave unanswered, such as hardware sizing, backup validity, and failure recovery. The tools include a sizing calculator, node failure simulator, 3-2-1 backup planner, overlay network diagnostic, and a power-loss shutdown sequencer, among others. Seven of the eleven tools function fully offline once loaded, and four optionally integrate with a user-supplied AI language model for log triage, Compose file review, command explanation, and troubleshooting. Users can describe their lab once through a shared profile, which is stored only in the browser with no account, server, or external sync involved. A Markdown export feature allows the profile to be transferred across devices manually.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Three Common PHP-FPM Failures and How to Diagnose Them Without Guesswork

Most PHP-FPM outages on production servers trace back to three root causes: OOM kills from oversized worker pools, gradual OPcache exhaustion, and misconfigured per-worker memory assumptions. When the OOM killer terminates a PHP-FPM worker mid-request, the application log stays silent and Nginx records a connection reset error, making the cause easy to miss. OPcache degradation is subtler — response times climb slowly through the day as cache fills and script recompilation increases, then reset overnight when PHP-FPM restarts. A key diagnostic pitfall is checking OPcache status from the CLI, which reads a separate cache instance and reveals nothing about the live FPM pool. Distinguishing a configuration problem from a genuine capacity problem determines whether the fix is a config tweak or a more expensive infrastructure upgrade.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Three-Gate Method Helps Developers Decide When to Use Local vs Remote AI Models

A workflow published on DEV Community proposes that developers measure three key factors before sending any AI prompt to a remote model: network reachability, presence of sensitive data in the text, and a stopwatch comparison of local versus remote processing time. The approach argues that guessing which option is faster wastes battery and compute resources, and that instinct should be replaced with simple, repeatable measurement. Secret credentials embedded in prompts are treated as a hard stop, meaning no remote call should proceed until the text is clean regardless of cost or speed. A sample Python script, intended as a labeled example rather than a finished product, demonstrates how to check connectivity, scan for secret residue, and time a stub completion locally. The article was prepared as part of outreach for MonkeyCode, which offers free model access, though the workflow is described as valid independent of any specific vendor or service.

0 comments Read more at DEV Community