查找

公告
· 十一月 14

[Video] Foreign Tables In 2025.2

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯  Foreign Tables In 2025.2 @ Ready 2025

<--break->

This presentation explains new foreign table enhancements in the 2025.2 release, focusing on improved query pushdown. The update lets entire queries, aggregates, grouping, and limits be processed by the external database instead of locally, greatly reducing data transfer and improving performance for cross-database queries.

🗣 Presenter: @Michael Golden, Principal Systems Developer, InterSystems

Enjoy watching, and subscribe for more videos! 👍

讨论 (0)1
登录或注册以继续
公告
· 十一月 14

[Webinar in Dutch] Data exchange in healthcare according to the FHIR standard with Python

Hey Community,

We're happy to invite you to a LinkedIn Live session in Dutch

🎤 Data exchange in healthcare according to the FHIR standard with Python 🎤

Event details:
📅 Date: Thursday, November 27th
🕓 Time: 1:30-2:15 PM EST

Curious how to translate data to commonly used standards like FHIR? Then join this webinar, where @Wietze Drost will demonstrate what's possible. Effective data exchange has become much easier with Python, instead of an obscure programming language invented by the software vendor. In this webinar, we'll share some examples that could work for your organization.

You'll gain insight into:

  • How to translate data to FHIR and other standards using Python.
  • How Python makes working with data for standards translation easier and more accessible.
  • How a data platform can be used for data standardization without complicated technical barriers.

👨‍🏫 Speaker@Wietze Drost, Sales Engineer at InterSystems Netherlands

>> JOIN HERE <<

讨论 (0)1
登录或注册以继续
问题
· 十一月 14

Start Your Sydney Vending Machine Empire: A Beginner's Guide to Profit, Location, and Inventory

The vending machine industry in Australia generated over $2.1 billion in revenue last year, and Sydney's share of that pie continues growing. What makes this business model particularly attractive isn't the flashy technology or passive income promises you see online—it's the fundamentals. Demographics, foot traffic patterns, and consumer behaviour create opportunities that most people walk past every single day without noticing.

Starting a vending machine business in Sydney requires understanding three core elements: where to place your machines, what products actually sell, and how to structure operations for consistent profit. The barrier to entry is relatively low compared to traditional retail, but success depends on data-driven decisions rather than gut feelings. Between 2020 and 2023, Australian vending machine operators who focused on strategic placement and inventory management saw profit margins between 20-35%, whilst those who simply "set and forget" struggled to break even.

The vending machine Sydney market has matured significantly, moving beyond soft drinks and chocolate bars into healthy snacks, technology accessories, and even fresh food options. This evolution creates openings for newcomers who understand their target market and can identify underserved locations. The question isn't whether vending machines can be profitable—it's whether you're willing to do the groundwork that separates successful operators from those who give up after six months.

Understanding the Sydney Vending Landscape

Sydney's 5.3 million residents create diverse opportunities across commercial districts, educational institutions, healthcare facilities, and transportation hubs. The Central Business District alone has over 400,000 workers moving through it daily, whilst suburbs like Parramatta, North Sydney, and Macquarie Park have emerged as secondary commercial centres with their own vending demands.

What's changed dramatically since 2020 is consumer expectations. Cashless payment systems aren't optional anymore—they're essential. Data from Worldline shows that 83% of vending machine transactions in Australian metro areas now occur via card or mobile payment. If your machines only accept coins, you're eliminating the majority of potential customers before they even look at your products.

The competitive landscape varies significantly by location type. Office buildings typically have established relationships with major operators like Selecta or Eurosnack, making entry difficult without offering something genuinely differentiated. However, smaller businesses, gyms, automotive workshops, and newer commercial developments often lack proper vending services or work with operators who haven't updated their offerings in years.

Location Strategy: Where the Money Actually Lives

Finding profitable locations requires systematic research rather than opportunistic pitches. The best operators I've analysed spend 60% of their time on site selection and relationship building, and only 40% on actual machine operations. That ratio surprises most beginners who think the machines themselves are the hard part.

Start by mapping high-traffic areas within your target radius. For most new operators, staying within 30-45 minutes of your home base makes sense initially. You'll need to service machines regularly, and travel time directly impacts your hourly profit. Calculate potential locations based on these criteria:

Daily foot traffic: Minimum 100-150 people passing your machine location. Less traffic means longer time to break even on your initial investment.

Dwell time: How long do people spend in this location? A busy corridor where people walk quickly needs different products than a break room where workers spend 15-20 minutes.

Demographics: Age, income level, and lifestyle factors determine what sells. A machine in a CrossFit gym needs entirely different inventory than one in an accounting firm's office.

Competition: Existing vending services or nearby cafés and convenience stores affect your sales. Sometimes competition validates demand; other times it saturates the market.

Manufacturing facilities, warehouses, and trade businesses represent underserved opportunities in Sydney's outer suburbs. These locations often have 50-200 workers with limited food options nearby, creating captive audiences for well-stocked machines. The challenge is that approaching these businesses requires persistence—decision-makers are busy, and vending isn't their priority.

Educational institutions offer volume but come with specific challenges. Universities and TAFEs have established contracts with major operators, but private colleges, training centres, and tutoring facilities often welcome smaller operators. Schools require additional compliance around healthy food policies, which varies by state but in NSW focuses on limiting sugary drinks and high-sodium snacks.

The Financial Reality: Initial Investment and Operating Costs

Let's address the numbers directly because too many guides gloss over the actual costs involved. A new commercial-grade vending machine with cashless payment capability costs between $4,500-$8,000 depending on capacity and features. Refurbished machines run $2,500-$4,000 but may require repairs and lack modern payment systems.

Your first machine represents just the beginning of startup costs:

Initial inventory fills typically cost $200-$400 depending on machine size and product selection. Business registration, insurance, and necessary permits add another $800-$1,500. A reliable vehicle for restocking and servicing is essential—factor in either existing vehicle costs or acquisition if needed.

Most operators should budget $8,000-$12,000 for their first machine when accounting for all startup requirements. Some finance options exist through equipment suppliers, but interest rates vary significantly, and leasing arrangements often favour the lessor more than the operator.

The break-even timeline depends entirely on location quality and product selection. A well-placed machine in a high-traffic location can generate $400-$800 in monthly revenue. After accounting for inventory costs (typically 35-45% of revenue), location commissions (10-25%), and operational expenses, net profit per machine averages $150-$350 monthly in good locations.

That means breaking even on your initial investment takes 24-48 months for a single machine. The business model becomes profitable when you scale to 5-10 machines, spreading operational efficiency across multiple revenue streams. This is why successful operators focus intensely on securing multiple quality locations before expanding their machine count.

Inventory Management: What Actually Sells

Product selection makes or breaks profitability. The days of just stocking Coca-Cola, Mars Bars, and potato chips are over. Consumer preferences have shifted dramatically towards healthier options, functional beverages, and protein-rich snacks.

Data from my analysis of successful Sydney operators shows these categories performing consistently:

Protein bars and balls now outsell traditional chocolate bars in many locations, particularly gyms and office environments. Brands like Bounce, Carman's, and Macro Mike resonate with health-conscious consumers. These products also have better profit margins—purchasing wholesale through suppliers like JJ Richards or Biopak yields 50-60% margins compared to 35-40% on traditional confectionery.

Ready-to-drink coffee and energy drinks remain strong sellers, but the brands matter. V and Mother perform well in trade and warehouse environments, whilst cold brew coffee and kombucha sell better in corporate offices. Understanding your specific location's demographic determines the right mix.

Healthy snacks including nuts, dried fruit, and baked chips have grown from niche products to mainstream staples. The challenge is balancing shelf life with freshness—some healthier options expire faster than traditional snacks, requiring more frequent restocking.

Don't overlook basic necessities. Pain relievers, feminine hygiene products, phone chargers, and earbuds sell consistently in office environments and educational settings. These items carry higher margins and differentiate your machine from competitors focused solely on food and beverages.

Inventory tracking should be systematic from day one. Spreadsheets work initially, but as you scale beyond three machines, dedicated vending management software like Cantaloupe or VendSoft becomes essential. These platforms track sales by product, time of day, and location, providing data that informs purchasing decisions rather than relying on assumptions.

Regulatory Considerations and Compliance

Operating vending machines in Sydney requires navigating several regulatory requirements that vary by location type and product category. Food safety regulations under NSW Food Authority guidelines apply to any machine dispensing food or beverages. This means temperature monitoring for refrigerated machines, regular cleaning schedules, and proper food handling procedures.

Public liability insurance isn't optional—it's essential. Coverage should be minimum $10 million to protect against potential claims from product issues or machine-related injuries. Annual premiums typically run $400-$800 depending on your machine count and locations.

Business structure matters more than most realise. Operating as a sole trader simplifies setup but exposes personal assets to business liabilities. Most experienced operators recommend establishing a proprietary limited company once you exceed two machines, providing legal separation and potential tax advantages.

Local council regulations vary significantly across Sydney. Some areas require permits for machines in public spaces, whilst private property placements typically only need property owner approval. Always verify local requirements before installing equipment.

Building Relationships and Securing Locations

The single biggest challenge new operators face isn't buying machines or stocking inventory—it's convincing property managers and business owners to give them space. Your success rate on cold approaches will be low initially, perhaps 1-2% of contacts resulting in machine placements. This improves with experience and references, but expect rejection as part of the process.

Your pitch should focus on solving problems rather than selling services. Business owners care about employee satisfaction, additional amenity offerings, and sometimes supplemental revenue through commission arrangements. They don't care about your business goals or passive income dreams.

Effective approaches include:

Offering trial periods where you install a machine for 60-90 days with no commitment, allowing the location to evaluate value without risk. Providing references from existing locations builds credibility faster than any sales pitch. Being responsive and reliable with servicing creates trust—if a machine runs out of products or malfunctions, you need to address it promptly.

Commission structures typically range from 10-25% of gross sales depending on location quality and exclusivity arrangements. High-traffic locations with limited alternatives command higher commissions. Some operators prefer paying flat monthly fees instead, which provides cost certainty but may be less attractive to property owners.

Scaling Your Operation

Once you've successfully operated 2-3 machines for six months, you'll understand whether this business suits your work style and goals. Scaling to 10-15 machines represents the next phase, where operational systems become critical.

Route efficiency determines profitability at scale. Group machines geographically to minimize travel time between servicing stops. Most operators can efficiently manage 8-12 machines within a 30km radius, visiting each location weekly or bi-weekly depending on sales volume.

Hiring help becomes necessary beyond 15-20 machines. Some operators bring on partners to share workload and investment. Others hire casual workers for restocking runs, maintaining control over location relationships and financial management themselves.

Technology investment pays dividends at this stage. Telemetry systems that monitor inventory levels, sales data, and machine malfunctions remotely allow you to optimize routes and identify issues before customers report them. These systems cost $100-$200 per machine annually but save countless hours of inefficient servicing.

The Reality Check

This isn't passive income regardless of what internet gurus promise. Successful vending machine operations require consistent work, strategic thinking, and customer service. You'll deal with jammed machines, upset customers, difficult property managers, and inventory that doesn't sell as expected.

However, the business offers genuine scalability for operators who master the fundamentals. Starting small, learning systematically, and expanding deliberately creates sustainable operations that generate meaningful income. The Sydney market has room for well-run operations that focus on service quality and understanding their customers.

Your success won't come from finding a "secret" location or magic product mix. It'll come from consistent execution, data-driven decisions, and building relationships that create long-term partnerships rather than transactional arrangements. That's not exciting or glamorous, but it's what actually works in this industry.

讨论 (0)1
登录或注册以继续
讨论
· 十一月 14

Proposal: Creating an Open Source Support Foundation for the InterSystems Ecosystem

Over the past several years, the InterSystems Developer Community has accumulated more than 1,000 open-source projects. Many of them serve as examples and learning materials — but a significant number have become useful tools, libraries, integrations, and real-world components used in production.

Some of these projects are mine, and like many community developers, I’ve seen the same recurring problem:

  • It’s easy to create an open-source project.
  • It’s hard to maintain, support, and develop it sustainably — especially without funding.

Writing code is one thing.
Supporting it for years, keeping up with new IRIS versions, building CI pipelines, writing documentation, fixing issues, reviewing PRs — all of this demands both time and motivation, and the biggest motivator is often financial support.

This is not a new challenge.
The global open-source world has faced this for decades and has developed various models to support OSS ecosystems.

I believe it’s time for the InterSystems community to start a discussion about adopting a similar model.


🎯 The Opportunity for InterSystems and Its Community

InterSystems technologies power mission-critical systems in healthcare, finance, government, logistics, and more. The developer ecosystem around IRIS continues to grow, and open-source tools play a significant role:

  • ORMs and connectors
  • CI/CD integrations
  • SQL and interoperability tooling
  • Development frameworks
  • Custom VSCode extensions
  • Integration adapters
  • Testing utilities
  • Community SDKs
  • Example apps evolving into real libraries

Many of these tools are widely used but maintained by individuals in their spare time.
This limits their long-term stability and slows down ecosystem innovation.

InterSystems and its customers benefit greatly from these projects — but there is no central way to fund them or support their maintainers.


🏛 Proposal: Establish an Open Source Foundation for InterSystems-Related Projects

Similar to foundations in other ecosystems, we could create an independent or semi-independent structure that would:

1. Collect Funding

  • Donations from companies using InterSystems technologies
  • Contributions from InterSystems itself
  • Sponsorships from partners
  • Community donations

2. Allocate Funding

  • Small grants for library maintenance
  • Bounties for features and bug fixes
  • Program-based funding (e.g., “Strategic Libraries Program”)
  • Long-term sponsorship for critical OSS projects

3. Provide Organizational and Technical Governance

  • Assistance with licensing, documentation, and governance
  • Shared CI infrastructure
  • Security audits
  • Help with onboarding additional maintainers

4. Promote High-Quality OSS Projects

  • A curated list of “Supported Community Libraries”
  • Recognition programs
  • Best practices and standards for development

5. Increase Engagement from InterSystems Customers

  • Many enterprise users rely on community tools
  • Funding these tools benefits everyone in the ecosystem

This would bring structure, sustainability, and motivation to developers who invest time in building tools that help the entire InterSystems world move forward.


📊 How Other Ecosystems Solve This Problem (Short Comparison)

Foundation / Model What They Support How They Fund It Applicability to InterSystems
Apache Software Foundation Hundreds of large projects (Hadoop, Spark, Kafka) Corporate sponsors, donations Strong governance example, but very heavyweight
Python Software Foundation (PSF) Python tools, packaging, events Memberships, corporate sponsors Great model for language-centric ecosystems
Linux Foundation Kernel, CNCF, Kubernetes, etc. Corporate funding, governing boards Too large-scale, but offers good structural inspiration
OpenJS Foundation Node.js, JS tooling Corporate members Example of supporting developer tools & libraries
Rust Foundation Language, tooling, compiler Corporate supporters, grants Modern, transparent, focused — a good reference
OpenCollective / GitHub Sponsors Individual or small OSS projects Direct crowdfunding Could be a starting point for InterSystems projects

Most of these ecosystems recognized early that OSS maintainers need support — not just enthusiasm.

InterSystems could take inspiration from these models to build something proportional to the size and needs of its own ecosystem.


🤝 Call for Community Discussion

This is not a final solution — it is a proposal to start a broader conversation.

Questions for the community:

  • Would an InterSystems OSS Foundation be beneficial?
  • What role should InterSystems officially play?
  • How can customers contribute?
  • Which projects deserve priority funding?
  • Should this be an official foundation or a community-driven initiative?
  • Should we start with a simple OpenCollective group as a pilot?

I believe this conversation is important for the long-term health and growth of the InterSystems developer ecosystem.

7 条新评论
讨论 (7)4
登录或注册以继续