查找

Pergunta
· 18 hr atrás

Why AI-Powered Games Are the Future of Social Gaming

 

Why AI-Powered Games Are the Future of Social Gaming

Remember the days when "social gaming" just meant spamming your Facebook friends for extra lives in Candy Crush? Yeah, we’ve come a long way since then.

We are currently witnessing a massive shift in how we play, creating a landscape where the line between "gamer" and "developer" is getting blurrier by the minute. Enter the AI social gaming platform—a new breed of digital hangout where Artificial Intelligence doesn’t just power the NPCs; it powers the entire creative economy.

If you’ve been watching the industry trends for 2025, you know that the static multiplayer lobbies of the past are being replaced by dynamic, user-generated worlds. But why exactly is AI taking over the social side of gaming? And more importantly, is it actually making things more fun?

Let’s dive into the logic, the tech, and the chaotic fun of this new era.

The Rise of the "Do-It-Yourself" Gamer

Here is the cold, hard truth: the biggest barrier to gaming creativity has always been the technical skill gap. You might have the best idea for a platformer since Mario, but if you don't know C# or how to rig a 3D model, that idea stays in your head.

This is where the modern AI game maker changes the script.

Tools powered by generative AI are democratizing game development in a way we haven't seen since the invention of the level editor. Instead of needing a degree in computer science, players can now use text prompts to generate assets, code snippets, and even entire game logic.

Why This Matters for Social Gaming

When you give everyone the power to create, you don't just get more games; you get communities built around creation.

  • Collaborative Building: Friends aren't just raiding dungeons together; they are building the dungeon.
  • Niche Micro-Communities: AI allows for the creation of highly specific games that wouldn't survive as AAA titles but thrive in social circles.
  • Rapid Prototyping: Trends move fast. With AI, a meme can become a playable game in a weekend, keeping the social conversation fresh and relevant.

Astrocade: The New Arcade Experience

If you want to see where this train is headed, you have to look at platforms like Astrocade. We are moving away from the "walled garden" approach of traditional consoles and toward open ecosystems where the platform is just a canvas for user imagination.

Astrocade represents the shift toward a "YouTube for Games." Just as video platforms allowed anyone to become a broadcaster, this AI social gaming platform is allowing anyone to become a game director. The focus here isn't on hyper-realistic graphics that take five years to render; it's on gameplay, novelty, and social interaction.

By leveraging AI, these platforms handle the heavy lifting—physics engines, rendering, and matchmaking—so players can focus on the fun stuff: logic, design, and sharing their creations with the world.

Spotlight: The Return of Instant Fun

Speaking of fun, one major criticism of modern gaming is that it has become too complex. Sometimes, you don't want a 40-hour cinematic experience; you want to jump in, power up, and cause some chaos. This is where games like Astroman are shining a light on what makes arcade-style gameplay so timeless.

Astroman puts you in the role of a powered character with enhanced abilities, dropped into a small open or semi-open environment where the focus is on movement, combat, and experimentation. It is designed to be fast to jump into and easy to understand, prioritizing moment-to-moment action over long cutscenes or deep lore. The game captures that "pick-up-and-play" energy that social gaming thrives on, stripping away the bloat to let players get straight to the dopamine hits.

The core gameplay typically includes super-powered movement—think running fast, jumping high, flying, or dashing—paired with combat against waves of NPCs or targets. It offers a sandbox feel where you can mess around with abilities rather than follow a strict mission structure. Whether you are clearing areas or just surviving attacks, Astroman serves as a perfect example of how modern mechanics can revive the classic arcade spirit for a new generation.

[Link to Astroman Game]

Personalization at Scale

One of the most fascinating aspects of AI in gaming is its ability to tailor the experience to the group playing it.

In the old days, a game was a static product. If you and I bought the same copy of a shooter, we played the exact same maps. Today, an AI game maker system can tweak the experience in real-time based on social data.

Dynamic Difficulty and Drama

Imagine a co-op game where the AI Director (a concept popularized by Left 4 Dead but now on steroids) analyzes the voice chat. Is the group laughing and relaxed? The AI might spawn a ridiculous, oversized boss to keep the humor going. Is the group tense and arguing? The AI might drop a rare loot box to boost morale.

This isn't sci-fi; it's the logical next step for engagement. AI allows games to "read the room," creating social moments that feel organic rather than scripted.

Solving the Toxicity Problem

We can't talk about social gaming without addressing the elephant in the room: toxicity. It is the number one reason people mute chat or leave social platforms entirely.

Human moderators can't watch every stream or read every chat log. Passive moderation tools often flag innocent banter while missing actual harassment. AI models, however, are getting frighteningly good at understanding context.

  • Contextual Moderation: AI can tell the difference between friendly trash talk among friends and genuine harassment.
  • Matchmaking 2.0: Instead of just matching players based on skill (ELO), AI algorithms are beginning to match players based on behavioral profiles. It groups helpful players with other team-oriented people, leaving the trolls to play with other trolls.

By cleaning up the social environment, AI creates a space where players actually want to interact, building trust in the platform.

Is AI Killing Human Creativity?

This is the big question everyone asks. If an AI game maker can build a level in seconds, does human effort lose its value?

Actually, the opposite is happening.

AI is raising the floor, not the ceiling. It handles the boring, repetitive tasks—generating trees, writing basic dialogue, coding collision detection—so that humans can focus on the soul of the game.

Think of it like digital photography. Photoshop didn't kill photography; it just made it easier to fix lighting. Similarly, AI tools in creating games like those found on Astrocade allow creators to focus on the "why" and "what" of the game, rather than getting bogged down in the "how."

The Logic of Community Growth

From an SEO and business perspective, the logic behind investing in an AI social gaming platform is sound.

  1. Retention: Players stay longer on platforms where they have invested time creating content.
  2. Virality: User-generated content (UGC) is inherently shareable. A funny, broken, or genius level created by a user is more likely to go viral on TikTok than a corporate trailer.
  3. Scalability: You don't need to hire 500 developers to make new maps. Your community is the development team.

Conclusion: The Next Level

The future of social gaming isn't about higher resolution textures or faster frame rates. It’s about agency. It’s about giving players the keys to the kingdom and saying, "Here is an AI game maker; show us what you can do."

Platforms that embrace this—blending the ease of Astrocade-style creation with the addictive loops of games like Astroman—are going to win the next decade. We are moving from a consumption model to a collaborative model, and frankly, it’s about time.

So, are you ready to stop just playing and start creating? The tools are there. The AI is ready. The rest is up to you.

Why AI-Powered Games Are the Future of Social Gaming

Remember the days when "social gaming" just meant spamming your Facebook friends for extra lives in Candy Crush? Yeah, we’ve come a long way since then.

We are currently witnessing a massive shift in how we play, creating a landscape where the line between "gamer" and "developer" is getting blurrier by the minute. Enter the AI social gaming platform—a new breed of digital hangout where Artificial Intelligence doesn’t just power the NPCs; it powers the entire creative economy.

If you’ve been watching the industry trends for 2025, you know that the static multiplayer lobbies of the past are being replaced by dynamic, user-generated worlds. But why exactly is AI taking over the social side of gaming? And more importantly, is it actually making things more fun?

Let’s dive into the logic, the tech, and the chaotic fun of this new era.

The Rise of the "Do-It-Yourself" Gamer

Here is the cold, hard truth: the biggest barrier to gaming creativity has always been the technical skill gap. You might have the best idea for a platformer since Mario, but if you don't know C# or how to rig a 3D model, that idea stays in your head.

This is where the modern AI game maker changes the script.

Tools powered by generative AI are democratizing game development in a way we haven't seen since the invention of the level editor. Instead of needing a degree in computer science, players can now use text prompts to generate assets, code snippets, and even entire game logic.

Why This Matters for Social Gaming

When you give everyone the power to create, you don't just get more games; you get communities built around creation.

  • Collaborative Building: Friends aren't just raiding dungeons together; they are building the dungeon.
  • Niche Micro-Communities: AI allows for the creation of highly specific games that wouldn't survive as AAA titles but thrive in social circles.
  • Rapid Prototyping: Trends move fast. With AI, a meme can become a playable game in a weekend, keeping the social conversation fresh and relevant.

Astrocade: The New Arcade Experience

If you want to see where this train is headed, you have to look at platforms like Astrocade. We are moving away from the "walled garden" approach of traditional consoles and toward open ecosystems where the platform is just a canvas for user imagination.

Astrocade represents the shift toward a "YouTube for Games." Just as video platforms allowed anyone to become a broadcaster, this AI social gaming platform is allowing anyone to become a game director. The focus here isn't on hyper-realistic graphics that take five years to render; it's on gameplay, novelty, and social interaction.

By leveraging AI, these platforms handle the heavy lifting—physics engines, rendering, and matchmaking—so players can focus on the fun stuff: logic, design, and sharing their creations with the world.

Spotlight: The Return of Instant Fun

Speaking of fun, one major criticism of modern gaming is that it has become too complex. Sometimes, you don't want a 40-hour cinematic experience; you want to jump in, power up, and cause some chaos. This is where games like Astroman are shining a light on what makes arcade-style gameplay so timeless.

Astroman puts you in the role of a powered character with enhanced abilities, dropped into a small open or semi-open environment where the focus is on movement, combat, and experimentation. It is designed to be fast to jump into and easy to understand, prioritizing moment-to-moment action over long cutscenes or deep lore. The game captures that "pick-up-and-play" energy that social gaming thrives on, stripping away the bloat to let players get straight to the dopamine hits.

The core gameplay typically includes super-powered movement—think running fast, jumping high, flying, or dashing—paired with combat against waves of NPCs or targets. It offers a sandbox feel where you can mess around with abilities rather than follow a strict mission structure. Whether you are clearing areas or just surviving attacks, Astroman serves as a perfect example of how modern mechanics can revive the classic arcade spirit for a new generation.

[Link to Astroman Game]

Personalization at Scale

One of the most fascinating aspects of AI in gaming is its ability to tailor the experience to the group playing it.

In the old days, a game was a static product. If you and I bought the same copy of a shooter, we played the exact same maps. Today, an AI game maker system can tweak the experience in real-time based on social data.

Dynamic Difficulty and Drama

Imagine a co-op game where the AI Director (a concept popularized by Left 4 Dead but now on steroids) analyzes the voice chat. Is the group laughing and relaxed? The AI might spawn a ridiculous, oversized boss to keep the humor going. Is the group tense and arguing? The AI might drop a rare loot box to boost morale.

This isn't sci-fi; it's the logical next step for engagement. AI allows games to "read the room," creating social moments that feel organic rather than scripted.

Solving the Toxicity Problem

We can't talk about social gaming without addressing the elephant in the room: toxicity. It is the number one reason people mute chat or leave social platforms entirely.

Human moderators can't watch every stream or read every chat log. Passive moderation tools often flag innocent banter while missing actual harassment. AI models, however, are getting frighteningly good at understanding context.

  • Contextual Moderation: AI can tell the difference between friendly trash talk among friends and genuine harassment.
  • Matchmaking 2.0: Instead of just matching players based on skill (ELO), AI algorithms are beginning to match players based on behavioral profiles. It groups helpful players with other team-oriented people, leaving the trolls to play with other trolls.

By cleaning up the social environment, AI creates a space where players actually want to interact, building trust in the platform.

Is AI Killing Human Creativity?

This is the big question everyone asks. If an AI game maker can build a level in seconds, does human effort lose its value?

Actually, the opposite is happening.

AI is raising the floor, not the ceiling. It handles the boring, repetitive tasks—generating trees, writing basic dialogue, coding collision detection—so that humans can focus on the soul of the game.

Think of it like digital photography. Photoshop didn't kill photography; it just made it easier to fix lighting. Similarly, AI tools in creating games like those found on Astrocade allow creators to focus on the "why" and "what" of the game, rather than getting bogged down in the "how."

The Logic of Community Growth

From an SEO and business perspective, the logic behind investing in an AI social gaming platform is sound.

  1. Retention: Players stay longer on platforms where they have invested time creating content.
  2. Virality: User-generated content (UGC) is inherently shareable. A funny, broken, or genius level created by a user is more likely to go viral on TikTok than a corporate trailer.
  3. Scalability: You don't need to hire 500 developers to make new maps. Your community is the development team.

Conclusion: The Next Level

The future of social gaming isn't about higher resolution textures or faster frame rates. It’s about agency. It’s about giving players the keys to the kingdom and saying, "Here is an AI game maker; show us what you can do."

Platforms that embrace this—blending the ease of Astrocade-style creation with the addictive loops of games like Astroman—are going to win the next decade. We are moving from a consumption model to a collaborative model, and frankly, it’s about time.

So, are you ready to stop just playing and start creating? The tools are there. The AI is ready. The rest is up to you.

Why AI-Powered Games Are the Future of Social Gaming

Remember the days when "social gaming" just meant spamming your Facebook friends for extra lives in Candy Crush? Yeah, we’ve come a long way since then.

We are currently witnessing a massive shift in how we play, creating a landscape where the line between "gamer" and "developer" is getting blurrier by the minute. Enter the AI social gaming platform—a new breed of digital hangout where Artificial Intelligence doesn’t just power the NPCs; it powers the entire creative economy.

If you’ve been watching the industry trends for 2025, you know that the static multiplayer lobbies of the past are being replaced by dynamic, user-generated worlds. But why exactly is AI taking over the social side of gaming? And more importantly, is it actually making things more fun?

Let’s dive into the logic, the tech, and the chaotic fun of this new era.

The Rise of the "Do-It-Yourself" Gamer

Here is the cold, hard truth: the biggest barrier to gaming creativity has always been the technical skill gap. You might have the best idea for a platformer since Mario, but if you don't know C# or how to rig a 3D model, that idea stays in your head.

This is where the modern AI game maker changes the script.

Tools powered by generative AI are democratizing game development in a way we haven't seen since the invention of the level editor. Instead of needing a degree in computer science, players can now use text prompts to generate assets, code snippets, and even entire game logic.

Why This Matters for Social Gaming

When you give everyone the power to create, you don't just get more games; you get communities built around creation.

  • Collaborative Building: Friends aren't just raiding dungeons together; they are building the dungeon.
  • Niche Micro-Communities: AI allows for the creation of highly specific games that wouldn't survive as AAA titles but thrive in social circles.
  • Rapid Prototyping: Trends move fast. With AI, a meme can become a playable game in a weekend, keeping the social conversation fresh and relevant.

Astrocade: The New Arcade Experience

If you want to see where this train is headed, you have to look at platforms like Astrocade. We are moving away from the "walled garden" approach of traditional consoles and toward open ecosystems where the platform is just a canvas for user imagination.

Astrocade represents the shift toward a "YouTube for Games." Just as video platforms allowed anyone to become a broadcaster, this AI social gaming platform is allowing anyone to become a game director. The focus here isn't on hyper-realistic graphics that take five years to render; it's on gameplay, novelty, and social interaction.

By leveraging AI, these platforms handle the heavy lifting—physics engines, rendering, and matchmaking—so players can focus on the fun stuff: logic, design, and sharing their creations with the world.

Spotlight: The Return of Instant Fun

Speaking of fun, one major criticism of modern gaming is that it has become too complex. Sometimes, you don't want a 40-hour cinematic experience; you want to jump in, power up, and cause some chaos. This is where games like Astroman are shining a light on what makes arcade-style gameplay so timeless.

Astroman puts you in the role of a powered character with enhanced abilities, dropped into a small open or semi-open environment where the focus is on movement, combat, and experimentation. It is designed to be fast to jump into and easy to understand, prioritizing moment-to-moment action over long cutscenes or deep lore. The game captures that "pick-up-and-play" energy that social gaming thrives on, stripping away the bloat to let players get straight to the dopamine hits.

The core gameplay typically includes super-powered movement—think running fast, jumping high, flying, or dashing—paired with combat against waves of NPCs or targets. It offers a sandbox feel where you can mess around with abilities rather than follow a strict mission structure. Whether you are clearing areas or just surviving attacks, Astroman serves as a perfect example of how modern mechanics can revive the classic arcade spirit for a new generation.

[Link to Astroman Game]

Personalization at Scale

One of the most fascinating aspects of AI in gaming is its ability to tailor the experience to the group playing it.

In the old days, a game was a static product. If you and I bought the same copy of a shooter, we played the exact same maps. Today, an AI game maker system can tweak the experience in real-time based on social data.

Dynamic Difficulty and Drama

Imagine a co-op game where the AI Director (a concept popularized by Left 4 Dead but now on steroids) analyzes the voice chat. Is the group laughing and relaxed? The AI might spawn a ridiculous, oversized boss to keep the humor going. Is the group tense and arguing? The AI might drop a rare loot box to boost morale.

This isn't sci-fi; it's the logical next step for engagement. AI allows games to "read the room," creating social moments that feel organic rather than scripted.

Solving the Toxicity Problem

We can't talk about social gaming without addressing the elephant in the room: toxicity. It is the number one reason people mute chat or leave social platforms entirely.

Human moderators can't watch every stream or read every chat log. Passive moderation tools often flag innocent banter while missing actual harassment. AI models, however, are getting frighteningly good at understanding context.

  • Contextual Moderation: AI can tell the difference between friendly trash talk among friends and genuine harassment.
  • Matchmaking 2.0: Instead of just matching players based on skill (ELO), AI algorithms are beginning to match players based on behavioral profiles. It groups helpful players with other team-oriented people, leaving the trolls to play with other trolls.

By cleaning up the social environment, AI creates a space where players actually want to interact, building trust in the platform.

Is AI Killing Human Creativity?

This is the big question everyone asks. If an AI game maker can build a level in seconds, does human effort lose its value?

Actually, the opposite is happening.

AI is raising the floor, not the ceiling. It handles the boring, repetitive tasks—generating trees, writing basic dialogue, coding collision detection—so that humans can focus on the soul of the game.

Think of it like digital photography. Photoshop didn't kill photography; it just made it easier to fix lighting. Similarly, AI tools in creating games like those found on Astrocade allow creators to focus on the "why" and "what" of the game, rather than getting bogged down in the "how."

The Logic of Community Growth

From an SEO and business perspective, the logic behind investing in an AI social gaming platform is sound.

  1. Retention: Players stay longer on platforms where they have invested time creating content.
  2. Virality: User-generated content (UGC) is inherently shareable. A funny, broken, or genius level created by a user is more likely to go viral on TikTok than a corporate trailer.
  3. Scalability: You don't need to hire 500 developers to make new maps. Your community is the development team.

Conclusion: The Next Level

The future of social gaming isn't about higher resolution textures or faster frame rates. It’s about agency. It’s about giving players the keys to the kingdom and saying, "Here is an AI game maker; show us what you can do."

Platforms that embrace this—blending the ease of Astrocade-style creation with the addictive loops of games like Astroman—are going to win the next decade. We are moving from a consumption model to a collaborative model, and frankly, it’s about time.

So, are you ready to stop just playing and start creating? The tools are there. The AI is ready. The rest is up to you.

Why AI-Powered Games Are the Future of Social Gaming

Remember the days when "social gaming" just meant spamming your Facebook friends for extra lives in Candy Crush? Yeah, we’ve come a long way since then.

We are currently witnessing a massive shift in how we play, creating a landscape where the line between "gamer" and "developer" is getting blurrier by the minute. Enter the AI social gaming platform—a new breed of digital hangout where Artificial Intelligence doesn’t just power the NPCs; it powers the entire creative economy.

If you’ve been watching the industry trends for 2025, you know that the static multiplayer lobbies of the past are being replaced by dynamic, user-generated worlds. But why exactly is AI taking over the social side of gaming? And more importantly, is it actually making things more fun?

Let’s dive into the logic, the tech, and the chaotic fun of this new era.

The Rise of the "Do-It-Yourself" Gamer

Here is the cold, hard truth: the biggest barrier to gaming creativity has always been the technical skill gap. You might have the best idea for a platformer since Mario, but if you don't know C# or how to rig a 3D model, that idea stays in your head.

This is where the modern AI game maker changes the script.

Tools powered by generative AI are democratizing game development in a way we haven't seen since the invention of the level editor. Instead of needing a degree in computer science, players can now use text prompts to generate assets, code snippets, and even entire game logic.

Why This Matters for Social Gaming

When you give everyone the power to create, you don't just get more games; you get communities built around creation.

  • Collaborative Building: Friends aren't just raiding dungeons together; they are building the dungeon.
  • Niche Micro-Communities: AI allows for the creation of highly specific games that wouldn't survive as AAA titles but thrive in social circles.
  • Rapid Prototyping: Trends move fast. With AI, a meme can become a playable game in a weekend, keeping the social conversation fresh and relevant.

Astrocade: The New Arcade Experience

If you want to see where this train is headed, you have to look at platforms like Astrocade. We are moving away from the "walled garden" approach of traditional consoles and toward open ecosystems where the platform is just a canvas for user imagination.

Astrocade represents the shift toward a "YouTube for Games." Just as video platforms allowed anyone to become a broadcaster, this AI social gaming platform is allowing anyone to become a game director. The focus here isn't on hyper-realistic graphics that take five years to render; it's on gameplay, novelty, and social interaction.

By leveraging AI, these platforms handle the heavy lifting—physics engines, rendering, and matchmaking—so players can focus on the fun stuff: logic, design, and sharing their creations with the world.

Spotlight: The Return of Instant Fun

Speaking of fun, one major criticism of modern gaming is that it has become too complex. Sometimes, you don't want a 40-hour cinematic experience; you want to jump in, power up, and cause some chaos. This is where games like Astroman are shining a light on what makes arcade-style gameplay so timeless.

Astroman puts you in the role of a powered character with enhanced abilities, dropped into a small open or semi-open environment where the focus is on movement, combat, and experimentation. It is designed to be fast to jump into and easy to understand, prioritizing moment-to-moment action over long cutscenes or deep lore. The game captures that "pick-up-and-play" energy that social gaming thrives on, stripping away the bloat to let players get straight to the dopamine hits.

The core gameplay typically includes super-powered movement—think running fast, jumping high, flying, or dashing—paired with combat against waves of NPCs or targets. It offers a sandbox feel where you can mess around with abilities rather than follow a strict mission structure. Whether you are clearing areas or just surviving attacks, Astroman serves as a perfect example of how modern mechanics can revive the classic arcade spirit for a new generation.

[Link to Astroman Game]

Personalization at Scale

One of the most fascinating aspects of AI in gaming is its ability to tailor the experience to the group playing it.

In the old days, a game was a static product. If you and I bought the same copy of a shooter, we played the exact same maps. Today, an AI game maker system can tweak the experience in real-time based on social data.

Dynamic Difficulty and Drama

Imagine a co-op game where the AI Director (a concept popularized by Left 4 Dead but now on steroids) analyzes the voice chat. Is the group laughing and relaxed? The AI might spawn a ridiculous, oversized boss to keep the humor going. Is the group tense and arguing? The AI might drop a rare loot box to boost morale.

This isn't sci-fi; it's the logical next step for engagement. AI allows games to "read the room," creating social moments that feel organic rather than scripted.

Solving the Toxicity Problem

We can't talk about social gaming without addressing the elephant in the room: toxicity. It is the number one reason people mute chat or leave social platforms entirely.

Human moderators can't watch every stream or read every chat log. Passive moderation tools often flag innocent banter while missing actual harassment. AI models, however, are getting frighteningly good at understanding context.

  • Contextual Moderation: AI can tell the difference between friendly trash talk among friends and genuine harassment.
  • Matchmaking 2.0: Instead of just matching players based on skill (ELO), AI algorithms are beginning to match players based on behavioral profiles. It groups helpful players with other team-oriented people, leaving the trolls to play with other trolls.

By cleaning up the social environment, AI creates a space where players actually want to interact, building trust in the platform.

Is AI Killing Human Creativity?

This is the big question everyone asks. If an AI game maker can build a level in seconds, does human effort lose its value?

Actually, the opposite is happening.

AI is raising the floor, not the ceiling. It handles the boring, repetitive tasks—generating trees, writing basic dialogue, coding collision detection—so that humans can focus on the soul of the game.

Think of it like digital photography. Photoshop didn't kill photography; it just made it easier to fix lighting. Similarly, AI tools in creating games like those found on Astrocade allow creators to focus on the "why" and "what" of the game, rather than getting bogged down in the "how."

The Logic of Community Growth

From an SEO and business perspective, the logic behind investing in an AI social gaming platform is sound.

  1. Retention: Players stay longer on platforms where they have invested time creating content.
  2. Virality: User-generated content (UGC) is inherently shareable. A funny, broken, or genius level created by a user is more likely to go viral on TikTok than a corporate trailer.
  3. Scalability: You don't need to hire 500 developers to make new maps. Your community is the development team.

Conclusion: The Next Level

The future of social gaming isn't about higher resolution textures or faster frame rates. It’s about agency. It’s about giving players the keys to the kingdom and saying, "Here is an AI game maker; show us what you can do."

Platforms that embrace this—blending the ease of Astrocade-style creation with the addictive loops of games like Astroman—are going to win the next decade. We are moving from a consumption model to a collaborative model, and frankly, it’s about time.

So, are you ready to stop just playing and start creating? The tools are there. The AI is ready. The rest is up to you.

Discussão (0)1
Entre ou crie uma conta para continuar
Pergunta
· 18 hr atrás

Import deepsee(.dfi) files via IPM

Hello Community,

What is the correct way to import and compile .dfi files when using zpm load? Do .dfi files need to be defined in module.xml?

I have code that imports the .dfi file successfully; however, when I run
zpm "load /home/irisowner/dev/ -v"

I get the message: Unknown file type. Skipping file: .pivot.DFI

    zpm "install isc-dev"
    do ##class(dev.code).workdir(dir)
    do ##class(dev.code).import("*.DFI")

Thank you!

6 novos comentários
Discussão (6)5
Entre ou crie uma conta para continuar
Artigo
· Dez. 15 3min de leitura

Crear tablas externas usando SQL a través de JDBC

Hola a todos. De nuevo, me gustaría compartir lo que estoy estudiando recientemente: crear tablas externas usando SQL a través de JDBC.

Como estoy aprendiendo sobre IRIS BI al mismo tiempo, empecé con este entorno docker de Sample-BI.

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

 

Después de iniciar el entorno, iniciad sesión en el portal de administración en http://localhost:52773/csp/sys/UtilHome.csp con el usuario Superuser.

Cambiad el namespace a IRISAPP.

 

😀 Veremos que todos los datos de ejemplo están almacenados en este namespace IRISAPP. Busquemos una tabla sencilla para probar la función de Foreign Table 🤣

System Explorer > SQL

 

Probemos la tabla HoleFoods.Outlet ejecutando la siguiente consulta SQL en la pestaña Execute Query.

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

 

Genial!! 😉 Hay 35 registros en esta tabla. Usemos esta.

 


Paso 1 - Configurar la conexión JDBC

Estudiando el siguiente documento, la base de datos InterSystems IRIS puede conectarse por JDBC de la siguiente manera:

Using the SQL Gateway as a JDBC Data Source

Así que usemos el namespace IRISAPP como la base de datos origen JDBC para las pruebas y configuremos una conexión para ello.

Añadid una nueva conexión en System > Configuration > SQL Gateway Connections

 

Introducid lo siguiente:

Connection name  testjdbc
User superuser
Password {vuestra propia contraseña}
Driver name com.intersystems.jdbc.IRISDriver
URL  jdbc:IRIS://127.0.0.1:1972/IRISAPP

Dejad Class path en blanco en este caso, porque estáis conectando a la base de datos InterSystems IRIS. Si os conectáis a una base de datos de terceros, recordad descargar el archivo del controlador JDBC (.jar) y especificar la ruta del controlador en el campo Class path.

Guardad y probad la conexión. Debería conectarse correctamente. 😁

¡Sí! 🎉 Hemos terminado el primer paso.

 


Paso 2 - Crear la Foreign Table

Ahora cambiad al namespace USER, que no contiene la tabla HoleFoods.Outlet. 😉

Aquí queremos consultar esta tabla externa HoleFoods.Outlet utilizando la función de Foreign Table. (En InterSystems IRIS, distintos namespaces pueden configurarse para apuntar a bases de datos diferentes. En este ejemplo, el namespace IRISAPP y el namespace USER apuntan a bases de datos distintas. Como resultado, no podemos consultar la tabla del namespace IRISAPP directamente desde el namespace USER).

 

Estudiando el siguiente documento, podemos crear directamente una foreign table mediante SQL. 😁👍

Foreign Tables

Así que volvamos a la página de ejecución SQL: System Explorer > SQL

 

1. Definir un Foreign Server

Ahora vamos a definir un Foreign Server llamado Sample.testDB con el siguiente SQL. testjdbc es el nombre que definimos en la conexión JDBC del SQL Gateway en el paso anterior.

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

 

 

2. Definir una Foreign Table

Ahora vamos a definir una Foreign Table llamada demo.outlet, que apunta a la tabla HoleFoods.Outlet a través del gateway JDBC.

 

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

Comprobemos el resultado en la lista de tablas.

¡Sí! 🎉 Se ha creado la Foreign Table demo.outlet. Oooh, y el esquema se ha leído y creado automáticamente 😂 Qué alegría.

 


Finalmente, probad la Foreign Table ejecutando el siguiente SQL

SELECT * FROM demo.outlet

 

 

¡Se devuelven 35 Outlets! ¡Sí! Lo conseguimos. 🤣

 


Solo para vuestra referencia:

Eliminar la Foreign Table demo.outlet

DROP FOREIGN TABLE demo.outlet

 

 

Eliminar el Foreign Server Sample.testDB

DROP FOREIGN SERVER Sample.testDB CASCADE

 

¡Eso es todo lo que quería compartir! ¡Gracias por leer! 😘

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Dez. 15

Limpeza das configurações do VS Code

Olá, Comunidade! Com o fim de mais um ano incrível, gostaria de avisar sobre uma mudança que está por vir na extensão vscode-objectscript. Para reduzir o tamanho da extensão, simplificar a manutenção e melhorar a usabilidade, a InterSystems planeja remover algumas configurações pouco utilizadas. Nossos dados indicam que menos de 2% dos usuários alteram essas configurações em relação aos valores padrão. No entanto, antes de finalizar a remoção, gostaria de dar aos usuários dessas configurações a oportunidade de explicar por que elas não deveriam ser removidas.

Discussão (0)1
Entre ou crie uma conta para continuar