查找

Article
· 6 hr ago 3m read

Create Foreign Tables Using SQL via JDBC

Hi everyone. Long time no see. Again, I would like to share what I am studying recently Create Foreign Tables Using SQL via JDBC.

Since I am learning about the IRIS BI at the same time, so I started with this Sample-BI docker environment

https://github.com/intersystems/Samples-BI

 

After starting the environment, login to the management portal http://localhost:52773/csp/sys/UtilHome.csp  with the user Superuser.

Switch the namespace to IRISAPP.

 

😀 We will find out that all the sample data are stored in this namespace IRISAPP. Let's find a simple table for testing the Foreign Table feature 🤣

System Explorer > SQL

 

Let's try the table HoleFoods.Outlet by Executing the following SQL query in the Execute Query tab

SELECT
ID, City, Country, Latitude, Longitude, Population, Type
FROM HoleFoods.Outlet

 

Great!!😉 there are 35 entries in this table. Let's use it.

 


Step1  -  Setup the JDBC connection

By studying the document below, InterSystems IRIS db can be connected by JDBC by the following way

Using the SQL Gateway as a JDBC Data Source

So, let's using the Namespace IRISAPP as the JDBC source database for testing, and set up a connection for it.

Add a new connection by System  > Configuration  > SQL Gateway Connections 

 

Input the following

Connection name  testjdbc
User superuser
Password {you own password}
Driver name com.intersystems.jdbc.IRISDriver
URL  jdbc:IRIS://127.0.0.1:1972/IRISAPP

Leave Class path blank in this case, because is connecting to InterSystems IRIS DB. If connecting to the 3rd party DB, remember to download the JDBC driver file (.jar) and specific the path of the drive in the Class path filed.

 

Save and Test the Connection. Connection successful should be expected. 😁

Yeah!!! we finished the 1st step.

 


Step 2 - Create Foreign Table

Now switch to another Namespace USER, which do no contain the table HoleFoods.Outlet. 😉

Here we would like to query this external table HoleFoods.Outlet by making use the feature of Foreign Table. (In InterSystems IRIS, different Namespace, can be config to point to different DB. In this example, Namespace IRISAPP and Namespace USER are pointing to different DB. As a result, we cannot query the table Namespace IRISAPP from Namespace USER directly. )

 

By studying the document below, we can directly create foreign table by SQL.😁👍

Foreign Tables

So let's go to the SQL execution page again. System Explorer > SQL

 

1. Define a Foreign Server

Now we are going to define a Foreign Server Sample.testDB by the following SQL. testjdbc is the name that we defined in the SQL Gateway JDBC connection in the pervious step.

CREATE FOREIGN SERVER Sample.testDB FOREIGN DATA WRAPPER JDBC CONNECTION 'testjdbc'

 

 

2. Define a Foreign Table

Now we are going to define a Foreign Table demo.outlet, which is pointing to the table HoleFoods.Outlet through the JDBC gateway

 

CREATE FOREIGN TABLE demo.outlet SERVER Sample.testDB TABLE 'HoleFoods.Outlet'

Let's check the result from the table list

Yeah!!!!  A Foreign Table demo.outlet is created. Oooo the schema is read and created automatically btw😂Happy happy.

 


Finally, test the Foreign Table by running the following SQL

SELECT * FROM demo.outlet

 

 

35 Outlets are returned!!! Yeah!! We made it.🤣

 


Only for your reference

Dropping the Foreign Table demo.outlet 

DROP FOREIGN TABLE demo.outlet

 

 

Dropping the  Foreign Server Sample.testDB 

DROP FOREIGN SERVER Sample.testDB CASCADE

 

That's all I want to share!!! Thanks for reading😘

Discussion (0)1
Log in or sign up to continue
Article
· 10 hr ago 3m read

Jupyter Notebook から InterSystems ObjectScript を動かしてみよう!

開発者の皆さん、こんにちは。

先日の 第3回InterSystemsJapan開発者コミュニティミートアップでは、Google Colab を使ったワークショップを実施しました。
その際、解説を読みながら、その場でコードを実行できる Jupyter Notebook の良さを改めて実感しました。

  • 「このメソッド、どう使うんだっけ…?」
  • 「処理の途中で変数の中身を確認したい…」
  • 「現場で実行するルーチンと作業手順を一緒に残しておきたい…」

こうした課題は、Notebook 形式にするだけで驚くほど解決します。
サンプルコードのすぐ横に解説を置けるので、迷う時間が減り、そのまま作業ドキュメントにもできます。
ObjectScript でも同じことができれば、学習にも現場作業にもとても便利ですよね。


ObjectScript を Notebook から実行したい…でも...

実は以前、開発者コミュニティに Jupyter Notebooks に ObjectScript を追加する方法https://jp.community.intersystems.com/node/521496)といった記事が紹介されていました。「これは便利そう!」と思い GitHub リポジトリ(https://github.com/Vekkby/objectsriptkernel)を試してみたものの、バージョンが古く、そのままでは動作しませんでした。

そこで、動作するように修正版を作成し、使い方もまとめました!

「ObjectScript を Notebook で動かしてみたい」
「学習環境やデモ環境を簡単につくりたい」

そんな方はぜひお試しください!


使い方(セットアップ手順)

とてもシンプルです。
以下の手順どおりに進めるだけで、Jupyter Notebook 上で ObjectScript を実行できる環境が立ち上がります。

1. 仮想環境の準備(WSL 2 / Docker)

Docker コンテナを利用するため、Windows の場合は以下の記事などを参考に WSL2 + Dockerのインストールを行ってください。

https://qiita.com/hiroakikka/items/b7a63383fb8cb989e722
https://qiita.com/haveAbook/items/0d0ae20a19214f65e7cd

(すでに Docker が動く方はこのまま次へ進めます。)

2. リポジトリをクローン

Ubuntuターミナルを起動し、修正版を GitHub から取得します。

git clone https://github.com/miniclub/objectscriptkernel

3. docker-compose で Notebook 環境を起動

docker-compose up -d --build 

数十秒ほどで、ObjectScript が使える Jupyter Notebook が起動します。

4. Notebook にアクセス

ブラウザで以下を開くだけです

👉 http://localhost:8888

Jupyter Notebook の画面が表示され、
ObjectScript カーネルを選べば、すぐにコードを実行できます。


おわりに

Notebook 上で ObjectScript を動かせると、学習・検証・現場作業のすべてが一段と効率的になります。
ぜひ試していただき、フィードバックや改善案などお寄せいただけると嬉しいです。

Discussion (0)1
Log in or sign up to continue
Announcement
· 13 hr ago

開発者コミュニティが10周年を迎えました!

開発者の皆さん、こんにちは!

2025年12月7日、InterSystems開発者コミュニティ(US)は10周年を迎えました!🥳🎉

この10年間、学び、コラボレーション、問題解決、そして InterSystems の技術の進化を共に歩んできたことを称えたいと思います。設立当初から参加していただいた方も、最近参加された方も、これまでの貢献、ご質問、アイデア、そしてサポートに感謝いたします。この節目は、皆様のものです! 皆様のおかげで、このコミュニティは今日のような形に築き上げられました。心から感謝いたします!

記念すべき一環として、特別なアニバーサリービデオへのご参加をお願いしました。そして、素晴らしい内容が投稿されました!お時間を割いていただき、お祝いの言葉や思い出、温かいお言葉を共有してくださった皆様、本当にありがとうございました。

これからの10年間もイノベーションとコラボレーションを続けていきましょう!🔥

追伸:日本のFAQチームも参加してみました。一瞬ですが登場します。ぜひ探してみてください!


この後の投稿もどうぞお楽しみに。これはほんの始まりに過ぎません。さらなる記念日のハイライトやサプライズが近日中に登場します!

Discussion (0)1
Log in or sign up to continue
Question
· 14 hr ago

Massive Fan Excitement Builds as Labubu Canada Reveals Secret Figures

The anticipation surrounding Labubu Canada has reached extraordinary levels as fans eagerly await the newly revealed secret figures, sparking a massive wave of excitement across collector communities nationwide.  Labubu
 With each cryptic teaser shared online, speculation grows and collectors rush to decode potential clues hinting at character origins, color variants, or exclusive accessories. This rising buzz reflects the brand’s growing influence in Canada’s designer toy culture. Fans are sharing predictions, preparing wish lists, and planning early purchases to avoid missing out. As demand grows, it’s clear these secret figures will shape upcoming trends and intensify competition among dedicated Labubu enthusiasts.

Secret Figure Teasers Trigger Frenzy Among Canadian Collectors

Labubu Canada’s strategically crafted teasers have created an immediate frenzy as collectors activate dedicated fan pages, engage in heated discussions, and search for hints hidden within each image. These teasers are intentionally mysterious, revealing just enough to ignite curiosity without offering clear confirmations. Fans across Canada have begun forming theories about possible collaborations or storyline expansions connected to the figures. This wave of speculation highlights how deeply the community engages with every Labubu release. As excitement spreads through social platforms and private groups, it becomes obvious that the teasers have successfully amplified nationwide anticipation for the soon-to-launch secret figures.

Fans Prepare for Fast Sellouts as Demand Surges Dramatically

With Labubu Canada’s secret figures rapidly gaining attention, fans expect an extremely swift sellout as demand grows dramatically across major cities. The collector market has seen similar patterns with previous releases, but the hype surrounding these mystery additions appears even more intense. Buyers are setting alarms, coordinating group purchases, and saving preferred payment methods to secure quicker checkouts. Discussions highlight concerns about limited stock, long queues, and potential resellers increasing competition. Given the elevated excitement, enthusiasts are preparing earlier than ever to avoid missing their preferred pieces. This heightened readiness underscores the overwhelming popularity of the upcoming figures.

Online Communities Buzz with Theories About Hidden Character Designs

Online communities have transformed into bustling hubs of speculation as fans dissect every rumor related to the hidden character designs. Dedicated groups on various platforms carefully analyze blurred images, leaked silhouettes, and color palettes to predict the final versions. Some collectors believe the figures may introduce fresh themes, while others think they might revive previously beloved styles. Theories span from mythical inspirations to futuristic aesthetics, inviting lively debates. These online discussions highlight the dynamic creativity within the Labubu fandom. Each theory adds excitement, encouraging more fans to participate. This collective anticipation fuels momentum ahead of the official reveal.

Sneak Peeks Suggest Unique Themes Fans Have Never Seen Before

Early sneak peeks released by Labubu Canada suggest these secret figures may introduce unique themes never previously explored in the lineup. The cryptic visuals reveal unfamiliar shapes and artistic elements that differ from traditional Labubu silhouettes, sparking heightened curiosity. Collectors speculate about new storylines or alternate universes connected to the designs. These fresh artistic directions could significantly impact future releases, opening doors to bolder concepts. Fans are especially intrigued by the mysterious details that hint at premium textures and intricate sculpting. This anticipation reflects how groundbreaking these new themes might be, making the upcoming release exceptionally meaningful.

Exclusive Drops Expected to Elevate Labubu Canada’s Market Position

The arrival of secret figures is expected to strengthen Labubu Canada’s position in the competitive designer toy market, particularly due to the exclusivity attached to these drops. Limited-edition releases typically inspire significant engagement, but the secrecy surrounding this set amplifies anticipation even further. Fans believe the rarity will increase future value, attracting both seasoned collectors and new buyers. Retail partners anticipate high traffic during launch, while online stores prepare for heavy demand. Industry observers predict these exclusives may redefine Labubu Canada’s brand identity by showcasing bold craftsmanship. Ultimately, this release could elevate the company’s standing across Canada’s collector landscape.

Collectors Anticipate Innovative Packaging and Premium Presentation

Collectors are eagerly anticipating innovative packaging and premium presentation for the upcoming secret figures, as Labubu Canada is known for elevating visual experience through creative box art and collectible inserts. Many believe the new release will include hidden symbols or storytelling elements embedded within the packaging, enhancing its appeal beyond the figure itself. This attention to detail consistently attracts collectors who appreciate thoughtful design. Speculation suggests that limited holographic seals or numbered certificates may accompany the figures, boosting their overall desirability. As excitement grows, fans acknowledge packaging as a crucial part of the ownership experience rather than a simple protective layer.

Influencers Help Spread Excitement as Reveal Date Approaches

Influencers across the Canadian toy community are playing a key role in amplifying excitement as the reveal date draws closer, sharing reactions, predictions, and teaser analyses with their audiences. Their posts generate widespread engagement, introducing Labubu’s secret figures to thousands of potential new fans. As influencers highlight the artistry, exclusivity, and mystery behind the upcoming launch, anticipation accelerates even further. Many followers are now preparing to participate in release day events after discovering the hype through influencer content. This growing exposure demonstrates how social media personalities strongly shape collector enthusiasm and contribute to the expanding popularity of Labubu Canada.

Retailers Prepare for Heavy Traffic and Record-Breaking Release Day

Retailers across Canada are bracing for heavy traffic as predictions indicate the release day for the secret figures may reach record-breaking levels. Past launches have already shown strong turnouts, but early signals suggest this event could surpass expectations. Stores are enhancing checkout systems, organizing staff, and implementing crowd-control strategies to manage anticipated rushes. Online platforms are increasing server capacity to handle sudden spikes in orders. Retailers expect lengthy queues and immediate sellouts, mirroring the rising national excitement. This preparation underscores the significant impact Labubu Canada continues to have on the collectible toy industry with each highly anticipated release.

Secret Figures Poised to Redefine Future Labubu Collecting Trends

The arrival of Labubu Canada’s secret figures is poised to  Labubu Doll
influence future collecting trends by introducing bold concepts and generating renewed enthusiasm within the community. Fans believe this release could inspire expanded character lines, unique collaborations, and advanced sculpting styles that push creative boundaries. As collectors prepare to secure these mysterious pieces, interest grows in understanding how they will fit within broader Labubu lore. This heightened curiosity encourages continued engagement and long-term passion for the brand. The impact of these secret figures will likely resonate throughout future collections, shaping the direction of Canada’s designer toy culture for years ahead.

Discussion (0)1
Log in or sign up to continue
Article
· 18 hr ago 6m read

Smart Interior Design Strategies for Effective Classic Space Planning

Organizing a space creatively and beautifully matters a lot! Whether it’s a compact apartment or open plan office, interior design plays a vital role. It evolves the entire look of a space. To achieve the best interior, you need to choose a reliable interior company such as Jazeera Furnish. We offer everything that modernize your space whether it’s a sofa, rug or any other home or office furniture.

In this article you will explore foundational principles of layout and space planning, and show how a thoughtful approach. Let Jazeera Furnish helps you in both homes and commercial projects.

Understand Purpose & Function First  

The beginning of any project requires successful layout. It all starts with What will this space be used for? Who uses it? How often? Designers emphasise beginning with function.

For Examples:

  • A residential living room might serve as lounge, work­zone, and TV area.
  • A retail showroom might have display, circulation, cashier and perhaps lounge zones.
  • A café or coworking floor needs clear paths, gathering zones and “quiet” zones.

Analyse the Space: Dimensions, Circulation & Context

Analyzing the physical space whether it’s a home or workspace its size, form, access points, windows, columns, ceiling height, utilities (sockets/vents), and even the way natural light enters comes next after determining the purpose.

Ask:

  • Are there any structural limitations?
  • Where are the windows and doors that influence where furniture is placed?
  • Which circulatory pathways arecommon?
  • Are there any architectural elements like the fireplace, windows, or view that should be emphasized?

Tip: Using masking tape or chalk on the floor, map out circulation paths before placing major furniture. This helps you visualize how people will move throughout the space.

Zoning: DefineFunctional Areas

Zoning contributes to usefulness and clarity in both residential and business settings. The process of dividing a room (or open-plan space) into discrete functional areas, such as a living, dining, and working zone, is known as zoning.

Residential example: In a loft-style apartment you might have:

  • Lounge zone: seating, coffee table.
  • Dining zone: table & chairs.
  • Work/hobby zone: desk, shelving.

These zones can overlap visually yet must be distinctin function.

Commercial example: In an office you might define:

  • Reception/visitor zone.
  • Open desk zone.
  • Collaboration zone.
  • Breakout/socialzone.

Designers’ approach (Jazeera Furnish style): Usefurniture arrangement, rugs, lighting changes or even partial screens/plantingsto differentiate zones rather than full walls. This keeps openness butpreserves function.

Flow & Circulation: How People Move

After zones have been established, pay attention tohow people move between them. A layout is ineffective if it requires fallingover a coffee table to get from the front door to the lounge. Easy movement isa sign of good flow.

Key rules:

  • Remove any furniture or impediments from the main paths.
  • Steer clear of placing big objects in the "line of traffic."
  • Arrange chairs and other components to facilitate easy mobility (e.g., facing entry or view).
  • Instead of requiring all traffic to go through a single corridor in larger areas, build sub-paths.

Scale & Proportion: Furniture Must Fit the Space

When it comes to furniture design, choosing the right size is often the biggest challenge. In a room with a large sofa, it dominates and makes it difficult to move around. In a room with a small sofa, it appears empty. In other words, this is the principle of scale and proportion.

Tips:

  • Take measurements of the doors, circulation clearances, and room size.
  • Choose pieces of furniture that allow for breathing room around them; unless absolutely must, avoid pushing everything flush with the walls.
  • Group furniture in larger areas so it does not seem lost in the room; stay away from overly huge pieces in smaller areas.

Pro tip for modern living: To create walking space behind and to soften the room's impression, place furniture 10–20 cm apart from the walls.

Functional Furniture Placement

As soon as zones and circulation have been sorted out, place your key pieces of furniture in the functional areas. Jazeera Furnish thinks this way:

Courses in Architecture

  • The purpose of group seating for conversation is to encourage interaction; for example, place chairs facing one another or a sofa close to a coffee table. Keep all seats away from walls.
  • Allow for flexibility by using furniture that is movable or modular so that the arrangement can change as needed. This is particularly crucial in commercial or multipurpose household settings
  • Make sure that windows, doors, and artwork do not obstruct views from the seating areas.
  • Furniture arrangement needs to work with circulation and provide access to storage. Clean flow is maintained with built-ins, ottomans, and hidden storage beneath benches.

Storage, Clutter & Vertical Planning

Despite the best layout, clutter or inadequate storagecan undermine it. Storage is seamlessly integrated into the design of smartspaces.

Important strategies:

  • Utilize vertical space to free up floor space with built-ins, wall-mounted cabinets, and tall shelves.
  • Incorporate storage into your zones. For instance, a media console with drawers may be used in a living area, while a shelving wall could be used in a home office.
  • Maintain "negative space": Spaces devoid of furnishings or decorations are crucial because they give the body and eye a chance to relax.
  • Benches with lids, ottomans, and under-bed drawers are excellent examples of hidden storage for modern living.

Jazeera Furnish tip: Whenever feasible, use furniture with many uses, particularly in small homes or adaptable business spaces.

Lighting, Natural Light & Ambience

Light is equally as important to layout as walls and furnishings. Zones, function, and atmosphere are all supported by a thoughtful lighting design.

Key points:

  • Employ the following light layers: accent (highlighting characteristics), task (reading, work), and ambient (general).
  • Consider natural light by positioning furniture close to windows and preventing obstructions of light pathways.
  • Utilize lighting to create distinct zones: the lounge should have softer lighting, while the work area should have a brighter task light.
  • Lighting, in particular, helps define atmosphere and purpose in commercial environments (e.g., café vs. workplace).
  • For contemporary living, let natural light guide the design; place work and seating areas next to windows whenever feasible; and make sure artificial lighting enhances each area's purpose.

Jazeera Furnish tip: Whenever feasible, use furniture with many uses, particularly in small homes or adaptable business spaces.

Detail the Aesthetics: Harmony, Visual Balance & Finishing Touches

Layout is driven by function and completed by aesthetics. Visual balance, color schemes, textures, and style are all used in good design to create rooms that are welcoming rather than merely functional.

Consider:

  • materials and colors that complement the purpose of each zone (e.g., energizing tones for work zones; relaxing neutrals for rest zones).
  • Use patterns and textures to provide depth without being overbearing.
  • Visual balance: symmetry or purposeful asymmetry aids in preventing furniture and décor from piling up on one side of the space.
  • Accent pieces and focal points include striking furniture, lighting fixtures, and artwork.
  • Designers frequently use the "rule of three" which states that things should be grouped in threes to achieve visual harmony.

Note for modern living: Function should come first, not style. A beautiful room that is difficult to live in does not work. Jazeera Furnish highlights the maxim, "Live healthy, feel good, look good."

Residential vs Commercial - Two Worlds, Many Shared Principles

Although residential and commercial projects have different demands, many layout principles apply to both. As the best interior fit-out company in Dubai, Jazeera Furnish's approach to blending each?

Comfort, personalization, multipurpose areas (such as a guest room that doubles as a home office), adaptability for family changes, and the storage of personal possessions are frequently given top priority in residential spaces. Scale, comfort, flow, and visual serenity are essential.

Higher trafficcapacity, brand identification, user experience design (for customers, staff,and guests), flexible lease or function changes, and frequently modularity areall requirements for commercial buildings. Workflows must support the businessmodel, and zones may comprise public, semi-public, and private areas.

Discussion (0)1
Log in or sign up to continue