Home Blog Page 389

Revolutionizing Web Development: Namrata Hinduja’s Insights on the Future of PWAs

Transforming Web Development with Progressive Web Applications

In this article, we explore the transformative potential of Progressive Web Applications (PWAs) with insights from Namrata Hinduja, a seasoned Full Stack Developer.

The Rise of PWAs

PWAs are revolutionizing web development by combining the best of web and mobile applications. They offer a seamless user experience across various platforms, making them an attractive option for businesses and developers alike.

Core Features of PWAs

Namrata Hinduja discusses the core features of PWAs, including:

  • Offline Functionality

    – PWAs allow users to access content and perform tasks even when they are offline.

  • Fast Loading Speeds

    – PWAs load quickly, even on low-end devices, ensuring a smooth user experience.

  • Responsive Design

    – PWAs adapt to different screen sizes and devices, providing a consistent user experience across platforms.

Benefits of PWAs

PWAs offer several benefits, including:

  • Improved Engagement

    – PWAs provide a seamless user experience, leading to increased engagement and user retention.

  • Increased Conversions

    – PWAs allow users to complete tasks quickly and easily, resulting in increased conversions.

  • Reduced Development Costs

    – PWAs eliminate the need for separate mobile and web applications, reducing development costs.

Conclusion

PWAs are the future of digital experiences, offering a seamless and engaging user experience across various platforms. By leveraging the core features and benefits of PWAs, businesses can improve engagement, increase conversions, and reduce development costs.

FAQs

Q: What is a Progressive Web App?

A: A Progressive Web App is a web application that provides a native app-like experience to users, combining the best of web and mobile applications.

Q: What are the benefits of using PWAs?

A: PWAs offer improved engagement, increased conversions, and reduced development costs, making them an attractive option for businesses and developers alike.

Q: How do PWAs differ from traditional web applications?

A: PWAs differ from traditional web applications in that they provide offline functionality, fast loading speeds, and responsive design, offering a seamless user experience across various platforms.

Q: Can PWAs be used for e-commerce applications?

A: Yes, PWAs can be used for e-commerce applications, providing a seamless and engaging user experience for online shoppers.

Data Challenges in Investment Research

The Challenges Faced by Investment Research Firms

Data Coverage, Timeliness, and Quality: The Top Concerns

The increasing reliance on data-driven investment strategies has brought significant challenges to the forefront. According to a recent Bloomberg Research Survey, data coverage, timeliness, and quality issues with historical data are the chief challenges faced by research analysts, quants, and data scientists.

The Survey: Investment Research Data Trends Survey 2024

The "Investment Research Data Trends Survey 2024" was based on data collected from a series of client workshops around the globe in 2024. Bloomberg organized eight in-person events in cities across North America, EMEA, and APAC. During these events, 166 clients participated in live surveys to share their insights on key trends and challenges in investment research.

The Challenges of Data Management

The challenge of not having adequate data coverage, timeliness, and quality could be the result of several factors, including poor data management practices, inadequate data governance, and a lack of proper data validation procedures.

The Importance of Data Normalization and Wrangling

The Bloomberg survey revealed that organizations are also struggling with normalizing and wrangling data from multiple data providers and identifying which datasets to evaluate and research.

The Constraints on Data Evaluation

These very challenges likely contribute to another key finding that nearly three-quarters (72%) of respondents can only evaluate a maximum of three datasets concurrently. In addition, nearly two-thirds (65%) require at least a month to assess just one dataset. This suggests severe constraints on the ability of these investment research firms to effectively use available data.

Managing Research Data: A Growing Concern

So, how are firms planning on tackling these challenges? The survey indicates that firms are still determining the best approach to managing research data. According to the survey, 50% of respondents said they currently manage data internally using proprietary solutions, while only 8% outsource to third-party providers. This suggests a strong preference for retaining control over their data management processes.

The Preference for Cloud-Based Data Storage

With more than six in ten (62%) of respondents preferring their research data to be made available in the cloud, it shows that there is a significant shift towards scalable and easily accessible data storage options.

The Need for Flexibility in Data Delivery Channels

More than one-third (35%) also want their data to be accessible through more traditional routes including on-premise, Secure File Transfer Protocol (SFTP), and REST API. This means that while investment research firms are comfortable with having their data on the cloud, they would also prefer to have flexibility in the choice of data delivery channels.

The Future of Investment Research: A Call to Action

From in-depth conversations with our research clients, it’s clear there is a desire for new orthogonal datasets as well as a need to harness ‘AI-ready’ data. The journey from data sourcing to extracting alpha is difficult and the continuous ingestion, cleaning, modeling, and testing of data is particularly challenging.

Conclusion

In conclusion, the challenges faced by investment research firms are multifaceted and complex. The need for comprehensive and flexible data solutions is undeniable. Bloomberg’s new data products directly address key challenges revealed in its survey of investment professionals.

FAQs

Q: What are the top challenges faced by investment research firms?
A: Data coverage, timeliness, and quality issues with historical data are the chief challenges faced by research analysts, quants, and data scientists.

Q: What is the preferred approach to managing research data?
A: 50% of respondents said they currently manage data internally using proprietary solutions, while only 8% outsource to third-party providers.

Q: What is the preferred data storage option?
A: More than six in ten (62%) of respondents prefer their research data to be made available in the cloud.

Q: What is the need for flexibility in data delivery channels?
A: More than one-third (35%) want their data to be accessible through more traditional routes including on-premise, Secure File Transfer Protocol (SFTP), and REST API.

Evaluating GenMol as a Generalist Foundation Model for Molecular Generation

0

Traditional Computational Drug Discovery Relies Almost Exclusively on Highly Task-Specific Computational Models for Hit Identification and Lead Optimization

Adapting these specialized models to new tasks requires substantial time, computational power, and expertise—challenges that grow when researchers simultaneously work across multiple targets or properties.

The Rise of Generalist Models

While specialized models remain widely used, the rise of generalist models has ignited the hope that these versatile frameworks can acquire a useful amount of chemical intuition, tackling diverse drug discovery tasks and uncovering solutions and patterns that specialized models often overlook.

Introducing SAFE-GPT

The recently introduced SAFE-GPT model represented a paradigm shift in AI-driven molecular generation by introducing a chemically intuitive framework aligned with how medicinal chemists approach molecule design. By using the Sequential Attachment-based Fragment Embedding (SAFE) representation, SAFE-GPT addressed critical limitations in earlier molecular generation models to fully capture the flexibility and modularity of molecular structures. This enabled SAFE-GPT to outperform SMILES-based generative models, graph neural networks, and early fragment-based models for a variety of drug discovery-related tasks.

The Limitations of SAFE-GPT

While SAFE-GPT was transformative in its time, it has notable limitations to its efficiency, scalability, and adaptability for diverse drug discovery tasks.

Comparing SAFE-GPT and GenMol for Drug Discovery Tasks

GenMol, a recently introduced model, presents a new approach to molecular generation, addressing some of the limitations of SAFE-GPT. This article compares the strengths and weaknesses of each model, highlighting their importance for drug discovery.

SAFE Overview

The choice of molecular representation is critically important for the accuracy, efficiency, and versatility of computational models in molecular design and must align with user chemical intuition to become widely adopted.

Example GenMol Inference Code

The GenMol NIM microservice and its companion notebooks simplify inference requests by enabling you to input varying SAFE or SMILES and mask strings, with de novo generation requiring only a pure mask and the desired molecule count:

Comparing SAFE-GPT and GenMol for Drug Discovery Tasks

GenMol and SAFE-GPT represent two distinct approaches to AI-driven molecular generation, each with unique strengths and limitations (Table 1).

Feature GenMol SAFE-GPT
Decoding Parallel (non-autoregressive) Sequential (autoregressive)
Task versatility Broad Requires task-specific adaptation
Efficiency Scalable and efficient Computationally intensive
Diversity-quality trade-off High balance Moderate

Molecular Generation and Exploration of Chemical Space

SAFE-GPT uses a GPT architecture with sequential, autoregressive decoding, generating molecules fragment-by-fragment. SAFE-GPT, combined with the fragment order-insensitive nature of the SAFE representation, can be applied to de novo and fragment-constrained generation of molecules.

Computational Efficiency

SAFE-GPT’s sequential generation and reliance on reinforcement learning objectives make it computationally intensive, particularly for large-scale or high-throughput scenarios.

Conclusion

The importance of these molecular generation models goes beyond just how molecular generation is done. It also explains why it needs to be reimagined.

Frequently Asked Questions

Q: What is the difference between SAFE-GPT and GenMol?

A: SAFE-GPT is a general-purpose AI model for molecular generation, while GenMol is a more specialized model designed for goal-directed lead optimization and hit generation.

Q: What are the strengths and weaknesses of SAFE-GPT and GenMol?

A: SAFE-GPT excels in motif extension and scaffold generation with strict fragment constraints, while GenMol is better suited for more flexible, goal-directed lead optimization and hit generation. Both models have their own unique strengths and weaknesses.

Q: How does GenMol improve upon SAFE-GPT?

A: GenMol improves upon SAFE-GPT by offering enhanced computational efficiency, adaptability, and task versatility, making it a more suitable choice for diverse drug discovery applications.

Q: Can I use GenMol for hit generation and lead optimization?

A: Yes, GenMol is designed for goal-directed lead optimization and hit generation, making it an excellent choice for these tasks.

Q: Can I use GenMol for motif extension and scaffold generation?

A: While GenMol can be used for these tasks, it is not as well-suited as SAFE-GPT, which excels in these areas with strict fragment constraints.

Q: How can I get started with GenMol?

A: You can start by testing GenMol as an NVIDIA NIM or exploring code examples on GitHub to learn more about using GenMol for goal-directed hit optimization, lead optimization, and more.

Q: How does GenMol compare to other molecular generation models?

A: GenMol outperforms SMILES-based generative models, graph neural networks, and early fragment-based models for diverse drug discovery-related tasks, making it a valuable addition to the field.

Q: Can I use GenMol for large-scale or high-throughput scenarios?

A: Yes, GenMol is designed to be scalable and efficient, making it suitable for large-scale or high-throughput scenarios.

Frequently Asked Questions

 

Tech Goals: An Update and 2025 Outlook

Article Rewritten

Introduction
In an article from last January, I listed what I did in 2023 regarding my websites and some goals for 2024. People liked that for some reason, so I am repeating the experience. Does doing the same this year count as a tradition?

2024 Accomplishments
The most important thing I did was move from being 50% retired to 85% retired. Getting up when you want is awesome.

All in all, my progress on last year’s tech goals was postponed due to the emergence of Drupal Starshot/CMS. But, I love the idea of the project and where it is going. In fact, it was launched today. And I am willing to wait on its stability regarding goals 1 and 2. So, not much on the Drupal front in 2024.

2025 Goals
All of this year’s work will occur March or later, till then I have to work on house projects while the weather here in Florida is tolerable. And of course, I will continue to publish Symfony Station and Battalion content on a weekly basis.

1. Convert Symfony Station to Drupal CMS
As soon as automatic updates work with it, I will start on moving Symfony Station to Drupal CMS. I am taking the Drupal CMS workshop at this year’s Florida Drupal camp to get a head start. I may or may not wait for Experience Builder to come out in a Drupal CMS update later in 2025.

2. Experiment with Mobile Atom Media
As I said, my Mobile Atom Media site is a Gutenberg Drupal one and Drupal Gutenberg is still in the beta stage. So, I will continue experimenting with it.

3. Customize the Theme for Mobile Atom Code
In my article, Building a Simple Grav CMS Theme with Twig, PHP, and CSS, I shared what I learned in preparation for this goal. It’s the part of my business where I still have a few clients, so I will take this fairly seriously.

4. Move Symfony Station’s "The Payload" Newsletter to Ghost?
Matt Mullenweg decided to become a c^nt in 2024 (even though he is in the right with his feud with WP Engine). That and my 85% retired status with only one WordPress-based client remaining has soured me on WordPress. Plus, it doesn’t align with my long-term goal other than the Gutenberg editor.

5. Move Battalion away from WordPress?
On a similar note, I may move Battalion away from WordPress. This is more likely a 2026 goal. But, we will see. If so, I would prefer using Sulu CMS. Which will require me being a half-ass Symfony developer. And I’m only about 25% along that journey.

Wrapping it up
Like last year, a good chunk of my time will continue to be used learning Portuguese as I am still in the process of getting a permanent visa from Portugal. I am also polishing my French for Symfony-related reasons. But as mentioned earlier, the disposal of my real estate assets has opened more time for these website goals. I hope to accomplish more in 2025. And I also dream of being fully retired by 2026 when I can get really get ambitious. Learning as many new things as you want (along with naps) is one of the major benefits of retirement.

FAQs
Q: What are your goals for 2025?
A: Convert Symfony Station to Drupal CMS, experiment with Mobile Atom Media, customize the theme for Mobile Atom Code, move Symfony Station’s "The Payload" Newsletter to Ghost, and move Battalion away from WordPress.

Q: Why are you moving away from WordPress?
A: I’m not entirely satisfied with WordPress’s integration with the Fediverse and its beta stage, and I’m looking for a more stable platform.

Q: What’s your plan for Battalion after moving it away from WordPress?
A: I’m considering using Sulu CMS, which will require me to develop my skills as a half-ass Symfony developer.

IBM Powers Personalized Fan Engagement at Wimbledon with Generative AI

0

For two weeks in July, the All England Lawn Tennis Club (AELTC) hosts Wimbledon, the most prestigious tournament in the sport. IBM has been partnering with the Club for more than three decades, enhancing coverage of The Championships and engaging fans with rich data-driven insights. This year, some of the most compelling stories of the tournament will be told with the help of IBM watsonx, the enterprise-ready generative AI platform.

How watsonx keeps Wimbledon fans up to date

The new Catch Me Up feature, available in the Wimbledon app and website, provides AI-generated summaries for every singles player—describing what happened in their last match and the challenges they face in their next one. Users can personalize their Catch Me Up list by adding their favorite players. If matches are live or video highlights are available, Catch Me Up provides relevant links.

Along with showing app users the match results of their favorite players, the Catch Me Up feature factors in recency, geolocation, and rankings to present additional relevant content. It also generates a summary card, capturing major storylines, highlights, and previews of upcoming matches.

Behind-the-scenes benefits

The Catch Me Up feature saves the Wimbledon editorial team hours of time and frees them up to write more stories and manage higher-value tasks. Behind the scenes, the process begins by collecting a huge volume of data from player rankings and momentum to games and sets played. This structured and unstructured data is managed by IBM watsonx.data, a data store built on an open lakehouse architecture that enables flexible, scalable access by applications across the Club’s hybrid cloud servers.

To generate the Catch Me Up summaries, the team uses a powerful, open-source large language model (LLM) called IBM Granite, which was trained on thoroughly reviewed, fully transparent, enterprise-grade data. The model boasts 13 billion parameters and is optimized for dialogue use cases such as virtual agents or chatbots. Using IBM watsonx.ai — a next-generation studio for building and training generative AI models for business use cases — the model was tuned with trusted Wimbledon data, and trained to generate stories in Wimbledon’s unique editorial style and tone of voice. The entire workflow is managed and monitored using IBM watsonx.governance to deliver reliable, integrated performance.

Enhancing fan-favorite features through ongoing collaboration

Wimbledon stays at the forefront of sporting event technology through its collaboration with IBM Consulting. Each year, teams from IBM and the AELTC collaborate and co-create (using the IBM Garage methodology) to bring the beauty and excitement of the tournament to life for millions of fans all over the world.

A shining example is the IBM SlamTracker. “SlamTracker has been where you get your scores and stats for almost 20 years,” says Sidell. “Over the last 18 months, we’ve been working with Wimbledon to create a new SlamTracker experience. We’re showcasing generative AI capabilities on top of it—some of the snippets you see as part of the player cards will now also live within SlamTracker, with three bullet points for match previews and recaps, generated by watsonx.”

This year, Wimbledon’s implementation will also enhance SlamTracker with new forms of head-to-head data including past matchup information, and improved server-receiver visualizations.

An enterprise-wide technology roadmap

What’s next on the technology roadmap? “This year, we’re doing a proof-of-concept with multimodal AI models—that is, a variety of computer vision models that understand both videos and images—so we can translate that into text,” says Sidell. “Our goal is to capture more of what happens between each point, during changeovers, and between play to create more contextual narratives around the players.” So perhaps next year, watsonx will help describe injury timeouts, weather delays, and other play interruptions such as interactions with umpires, ball girls and ball boys, and activity in the Royal Box.

The collaboration between IBM Consulting and the Wimbledon teams extends beyond the fan-facing digital platform, into enterprise-wide transformation. “Some of Wimbledon’s sustainability leads saw a demo of the IBM Envizi platform, showing how it could improve the monitoring and reporting of their carbon emissions and energy consumption data,” says Sidell. “That led to us implementing an instance of Envizi for the AELTC to monitor the tournament this year.” As the sole grand slam tournament played on natural grass, it seems only fitting that Wimbledon should stay ahead of the curve on environmental concerns.

Conclusion:
The collaboration between IBM and Wimbledon has resulted in a more engaging and informative experience for fans, while also providing valuable insights and time-saving benefits for the editorial team. The use of IBM watsonx has enabled the creation of AI-generated summaries, improved the SlamTracker experience, and laid the groundwork for future innovations.

FAQs:

Q: What is IBM watsonx?
A: IBM watsonx is an enterprise-ready generative AI platform that enables the creation of AI-generated summaries, stories, and narratives.

Q: What is the Catch Me Up feature?
A: The Catch Me Up feature is an AI-generated summary for every singles player, describing what happened in their last match and the challenges they face in their next one.

Q: What is the IBM SlamTracker?
A: The IBM SlamTracker is a fan-favorite feature that provides scores and stats for the tournament. This year, it will be enhanced with new forms of head-to-head data and improved server-receiver visualizations.

Q: What is the future roadmap for IBM and Wimbledon?
A: The future roadmap includes the development of multimodal AI models that can understand both videos and images, and the implementation of the IBM Envizi platform for monitoring and reporting of carbon emissions and energy consumption data.

US to Lose AI Arms Race Without Fossil Fuels

Unlock the White House Watch newsletter for free

Your guide to what the 2024 US election means for Washington and the world

US Secretary of the Interior nominee warns of "electricity crisis" and "AI arms race"

Donald Trump’s pick for secretary of the interior, Doug Burgum, has warned that the US will lose the "AI arms race" to China unless it boosts electricity generation from fossil fuels and stabilizes its power grid.

Electricity crisis and roadblocks

Burgum, a billionaire businessman and former governor of North Dakota, told US senators that the country has an "electricity crisis" due to weaknesses in the grid and "roadblocks" stopping companies from building fossil fuel plants that can supply round-the-clock power.

The sun doesn’t always shine and the wind doesn’t always blow

He added that the balance is "out of whack" and that the Trump administration would allocate more public land to drilling for oil and slash tax breaks favoring renewable energy companies that produce "intermittent and unreliable power".

Demand for electricity on the rise

Demand for electricity is growing at unprecedented rates in the US, driven by soaring demand from data centers for artificial intelligence processing, which the Department of Energy predicts will triple in the next three years.

Losing the AI arms race to China

"This is a big deal," Burgum said. "We need to have baseload power to make sure our computers keep running. Without baseload, we’re going to lose the AI arms race to China, and if we lose the AI arms race to China, that’s got direct impacts on our national security."

National Energy Council

If confirmed as Trump’s "energy tsar", Burgum will have sweeping powers to push through the president-elect’s vision to "drill, baby, drill".

Executive order on AI infrastructure

On Tuesday, President Joe Biden signed an executive order to open up federal land for AI infrastructure, with the proviso that power would be drawn from clean electricity sources. This is part of the Democratic leader’s effort to curb emissions and counter climate change.

Carbon capture storage and fossil fuels

Burgum suggested that new technologies such as carbon capture storage could eliminate the emissions produced by fossil fuels. However, there are questions around the commercial and technical feasibility of the technology.

Restricting fossil fuel production

He stated that restricting US fossil fuel production would not produce any environmental benefit, as less scrupulous governments would fill the supply gap.

Conclusion

The debate surrounding the role of fossil fuels in the US energy mix is a complex one, with passionate arguments on both sides. While some argue that fossil fuels are necessary to ensure a stable energy supply, others claim that their production and use are detrimental to the environment.

FAQs

Q: What is the "AI arms race"?
A: The "AI arms race" refers to the competition between the US and other countries, particularly China, to develop and deploy artificial intelligence technology.

Q: What is baseload power?
A: Baseload power refers to a consistent and reliable source of electricity, often generated by fossil fuels, to ensure a stable energy supply.

Q: What is carbon capture storage?
A: Carbon capture storage is a technology that captures carbon dioxide emissions from power plants and other industrial sources, storing them underground to prevent them from entering the atmosphere.

Continued Pretraining of State-of-the-Art LLMs for Sovereign AI and Regulated Industries with iGenius and NVIDIA DGX Cloud

0

Challenges and Best Practices for Building Large Language Models

In recent years, large language models (LLMs) have achieved extraordinary progress in areas such as reasoning, code generation, machine translation, and summarization. However, despite their advanced capabilities, foundation models have limitations when it comes to domain-specific expertise such as finance or healthcare or capturing cultural and language nuances beyond English.

Overcoming Limitations

Overcoming those limitations can be achieved with further development using continued pretraining (CPT), instruction fine-tuning, and retrieval-augmented generation (RAG). This requires high-quality, domain-specific datasets, a robust AI platform (software and hardware stack), and advanced AI expertise.

iGenius and Colosseum 355B

iGenius, an Italian technology company specializing in artificial intelligence for enterprises operating in highly regulated sectors, such as financial services and public administration, aimed to develop a state-of-the-art foundational LLM within a tight timeline. They faced challenges in accessing large-scale GPU clusters (thousands of GPUs) and securing support for highly scalable training frameworks.

Collaboration with NVIDIA

During this engagement, iGenius developed the Colosseum 355B LLM, designed and developed for highly regulated environments, which provides businesses with confidence in the accuracy of the model output and security, knowing none of their information or IP is ever compromised. iGenius chose to collaborate with NVIDIA to accelerate their LLM development for Colosseum 355B.

DGX Cloud Environment

Improving LLM reasoning capabilities requires a robust, distributed hardware and software solution, where accelerated compute, networking, storage, and libraries must seamlessly work together. Any bottleneck in the system can significantly slow or even stop the entire training process. NVIDIA DGX SuperPOD negates the risk and complexity of this by providing a fully optimized solution that is designed, built, and validated by NVIDIA before handing over a ready-to-go system to their customers.

CPT and Alignment

iGenius used large-scale CPT and alignment on specific domains to build Colosseum 355B, a foundational LLM developed using NVIDIA DGX Cloud infrastructure and NVIDIA AI Enterprise software with NVIDIA NeMo Framework. They reduced computational costs and improved efficiency through CPT in FP8 precision.

Challenges and Best Practices

As training scales, minor issues become critical. Running the Colosseum 355B training job on 3K GPUs can take 15–20 minutes just to load the checkpoint, which consumes 5 TB of memory footprint. A storage system performing well with multiple small jobs across thousands of GPUs may struggle when a single workload requires all GPUs to read and write checkpoints simultaneously, causing delays and potential timeouts.

Best Practices

Here are some best practices and lessons learned when running LLM training at scale:

  • Explore the basics at a reduced scale
  • Monitor effectively and track at scale
  • Explore the basics at reduced scale
  • Progressive scaling is key
  • Small debug model: Exploring large-scale training configurations is highly challenging
  • End-to-end process testing
  • Robust checkpointing
  • Expansions from minimal to large-scale distribution
  • Dataset testing
  • Monitor effectively and track at scale
  • Accurate experiment tracking
  • Infrastructure observability
  • Predefined tests

Conclusion

By using large-scale CPT and alignment on specific domains, iGenius built Colosseum 355B, a foundational LLM developed using NVIDIA DGX Cloud infrastructure and NVIDIA AI Enterprise software with NVIDIA NeMo Framework. iGenius reduced computational costs and improved efficiency through CPT in FP8 precision.

FAQs

Q: What are the limitations of foundation models?
A: Foundation models have limitations when it comes to domain-specific expertise such as finance or healthcare or capturing cultural and language nuances beyond English.

Q: How can these limitations be overcome?
A: These limitations can be overcome with further development using continued pretraining (CPT), instruction fine-tuning, and retrieval-augmented generation (RAG).

Q: What is Colosseum 355B?
A: Colosseum 355B is a foundational LLM developed by iGenius using NVIDIA DGX Cloud infrastructure and NVIDIA AI Enterprise software with NVIDIA NeMo Framework.

Q: What are the best practices for running LLM training at scale?
A: The best practices include exploring the basics at a reduced scale, monitoring effectively and tracking at scale, exploring the basics at reduced scale, progressive scaling, and more.

Chat Notification Schema Design

Creating a Schema for a Chat Application

Basic Tables for a Chat Application

1. Users

  • Purpose: To store user details.
  • Table Name: users
  • Columns:
    • id (UUID): Primary key.
    • name (VARCHAR(255)): User’s display name.
    • email (VARCHAR(255)): Unique email address.
    • phone_number (VARCHAR(15)): Unique phone number.
    • profile_url (TEXT): Link to the user’s profile picture.
    • created_at (TIMESTAMP): When the user was created.
    • updated_at (TIMESTAMP): Last update time.

2. Chat Groups

  • Purpose: To manage chat groups.
  • Table Name: chat_groups
  • Columns:
    • id (UUID): Primary key.
    • name (VARCHAR(255)): Group name.
    • description (TEXT): Optional group description.
    • created_at (TIMESTAMP): When the group was created.
    • updated_at (TIMESTAMP): Last update time.

3. Chat Group Members

  • Purpose: To associate users with chat groups.
  • Table Name: chat_group_members
  • Columns:
    • id (UUID): Primary key.
    • group_id (UUID): Foreign key to chat_groups.
    • user_id (UUID): Foreign key to users.
    • role (ENUM): Role in the group (e.g., Admin).
    • is_active (BOOLEAN): Active status in the group.
    • joined_at (TIMESTAMP): When the user joined the group.

4. Chat Messages

  • Purpose: To store messages in chat groups.
  • Table Name: chat_messages
  • Columns:
    • id (UUID): Primary key.
    • group_id (UUID): Foreign key to chat_groups.
    • sender_id (UUID): Foreign key to users.
    • message (TEXT): Content of the message.
    • is_edited (BOOLEAN): Whether the message was edited.
    • is_system (BOOLEAN): True for system messages.
    • created_at (TIMESTAMP): When the message was sent.

5. Message Reactions

  • Purpose: To track reactions to messages (likes, hearts, etc.).
  • Table Name: message_reactions
  • Columns:
    • id (UUID): Primary key.
    • message_id (UUID): Foreign key to chat_messages.
    • user_id (UUID): Foreign key to users.
    • reaction_type (VARCHAR(50)): Type of reaction (e.g., LIKE, HEART).
    • created_at (TIMESTAMP): When the reaction was made.

6. Attachments

  • Purpose: To store media or files attached to messages.
  • Table Name: message_attachments
  • Columns:
    • id (UUID): Primary key.
    • message_id (UUID): Foreign key to chat_messages.
    • file_url (TEXT): Location of the attachment.
    • file_type (VARCHAR(50)): Type of file (e.g., IMAGE, VIDEO).
    • created_at (TIMESTAMP): When the attachment was uploaded.

7. Notifications

  • Purpose: To manage notifications related to chat or other events.
  • Table Name: notifications
  • Columns:
    • id (UUID): Primary key.
    • status (ENUM): Notification status (e.g., SEEN, UNSEEN).
    • message (TEXT): Content of the notification.
    • device_id (UUID): Related device ID, if applicable.
    • is_visible_to_admin (BOOLEAN): Visibility to admin users.
    • admin_visible_status (ENUM): Admin-specific visibility status.
    • category (ENUM): Notification category (e.g., ALERT, GENERAL).
    • type (ENUM): Type of notification.
    • sos_alert_type (ENUM): SOS alert type, if applicable.
    • metadata (VARCHAR(255)): Additional metadata about the notification.
    • raised_by_id (UUID): User who raised the notification.
    • user_id (UUID): Target user of the notification.
    • created_at (TIMESTAMP): When the notification was created.

8. User Devices

  • Purpose: To manage devices associated with users for notifications.
  • Table Name: user_devices
  • Columns:
    • id (UUID): Primary key.
    • user_id (UUID): Foreign key to users.
    • token (VARCHAR(255)): Unique device token.
    • device_type (ENUM): Type of device (e.g., MOBILE, WEB).
    • arn (VARCHAR(255)): Amazon Resource Name for notifications.

Suggestions and Feedback

This schema is designed with a balance of simplicity and functionality in mind. However, every project has its unique requirements, and I’d love to hear your thoughts:

  • Would you add any additional fields for a better user experience?
  • How would you optimize this schema for high-traffic applications?
  • Are there any common edge cases you’ve encountered in chat applications that this schema doesn’t address?

Let’s make this a collaborative discussion to create something great! Feel free to share your insights.

Conclusion

Creating a schema for a chat application requires careful thought to ensure scalability, clarity, and functionality. This article provides a comprehensive overview of the basic tables required for a chat application, including users, chat groups, chat messages, message reactions, attachments, notifications, and user devices. By using this schema as a starting point, you can create a robust and scalable chat application that meets the needs of your users.

FAQs

Q: What is the purpose of the chat_groups table?
A: The chat_groups table is used to manage chat groups, including their name, description, and creation time.

Q: How do you associate users with chat groups?
A: Users are associated with chat groups through the chat_group_members table, which contains foreign keys to both the users and chat_groups tables.

Q: What is the purpose of the message_reactions table?
A: The message_reactions table is used to track reactions to messages, including the type of reaction and the user who made it.

Q: How do you manage notifications in the chat application?
A: Notifications are managed through the notifications table, which contains information about the notification, including its status, message, and target user.

The Best Typography of the 1940s

0

The Typography of the 1940s: A Decade of Contrast

01. Ne-Po

Ne-Po (which stands for Negative-Positive) was a dual-system design of positive and negative blocks that can be combined to form letters, patterns, and decorative borders. The NE series features negative-space lettering, while the PO series focuses on positive, line-based forms. And its adaptability as a modular type made it a popular choice for experimental typography in the 1940s.

Simon Manchipp, co-founder of SomeOne, describes it as: "A modular marvel of negative and positive interplay. Born in the early 1930s from the German foundry Brüder Butter – later rebranded as Schriftguss – this typeface wasn’t just letters; it was a system. A concept. A blueprint for endless creativity. The Negative series: 17 meticulously crafted modules forming letters in the void. The Positive series: a gang requiring just 15. Together, they weren’t just type, they were tools. For borders, for patterns, for pushing the boundaries of visual communication."

02. Futura

The brainchild of Paul Renner, Futura is a geometric sans-serif typeface initially released in 1927. By the 1940s, it had firmly established itself as a hallmark of Modernist typography, blending the clean lines and geometric precision of the Bauhaus aesthetic with practical usability.

Harry Sandhu, senior creative director at Jung von Matt London, notes: "For the 1940s, Futura stands out. Its clean geometry wasn’t just Modernist; it was a declaration. In a world craving order amidst chaos, Futura became the face of progress. From propaganda to publishing, it didn’t just sit on the page, it led the conversation."

03. Garamond

Named after 16th-century French engraver Claude Garamond, Garamond is a timeless serif typeface that saw renewed popularity in the 1940s, particularly for books and printed materials. Its graceful, humanist forms and balanced proportions make it one of the most readable and elegant typefaces in history.

04. Brush Script

Created by Robert E. Smith in 1942, Brush Script is a handwritten script typeface that mimics the look of handwritten calligraphy. Its flowing, expressive forms and connected letters create a sense of informality and elegance. For this reason, Brush Script is widely used for invitations, logos, and other applications where a handwritten aesthetic is desired.

Wayne, a designer, shares a couple of examples: "Butlin’s, the holiday resort, famously adopted Brush Script as a cornerstone of its visual identity in the mid-20th century. Its cheerful and approachable aesthetic perfectly aligned with the brand’s promise of fun family holidays. More recently, Kärcher, the German cleaning equipment brand, incorporated Brush Script in product labeling for a retro-inspired line, showing the font’s enduring charm across decades and industries."

05. Trade Gothic

Trade Gothic is a sans-serif designed in 1948 by Jackson Burke. Like many gothic fonts of the 19th and early 20th centuries, it’s more irregular than many other sans-serifs that came later, such as Helvetica and Univers. This variety makes it a good choice for those looking for a more characterful effect.

Ryan Spence, senior creative at Born Ugly, notes: "This font embodies the industrious spirit of its era. Its large x-height and humanist traits reflect clarity and craftsmanship, essential for its original use in 1940s newspaper typesetting."

06. Highway Gothic

Highway Gothic, more formally known as the FHWA Series fonts, is a sans-serif font developed by the US Federal Highway Administration (FHWA). "First published in the FHWA’s Standard Alphabets for Traffic Control Devices in 1948 and later updated in 2000, the series is used for road signage in the States and many other countries," says Rose Stewart, design director at The Frameworks.

07. Lydian

Lydian is a calligraphic humanist sans-serif designed by Warren Chappell for American Type Founders in 1938. It was most famously used for the end credits on the TV show Friends. But as Peter Gaskell, design project lead at Dalziel & Pow notes, it was in the 1940s that it first made its mark.

Conclusion

The typography of the 1940s reflects the decade’s dramatic contrasts – global conflict, post-war reconstruction, and the rise of Modernist ideals. These iconic typefaces continue to influence contemporary visual culture, offering lessons in design principles and adaptability that remain relevant today.

FAQs

Q: What was the most popular font of the 1940s?
A: Futura, designed by Paul Renner, was a hallmark of Modernist typography, blending clean lines and geometric precision with practical usability.

Q: Which font was used for road signage in the 1940s and 2000s?
A: Highway Gothic, developed by the US Federal Highway Administration (FHWA), was used for road signage in the United States and many other countries.

Q: What is the origin of the Lydian font?
A: Lydian is a calligraphic humanist sans-serif designed by Warren Chappell for American Type Founders in 1938, later used for the end credits on the TV show Friends.

White House National Security Adviser Reflects on China Policy

0

Trade Agreements and Global Partnerships: A New Era of Cooperation and Competition

Government-to-Government Agreements for Effective Security and Transparency

“That to me, I think, has a practical answer, which is government-to-government agreements that emplace effective security safeguards and transparency around the hardware, the model weights and the know-how, and that’s what we have worked through in our M.O.U. [memorandum of understanding] with the U.A.E., and I believe that is a sustainable model for having a strong technology partnership with that country, as well as other countries, that gives the U.S. a series of both economic and strategic advantages, where the alternative is to have them go into the Chinese technology orbit, which we do not want.”

Asian Nations’ Expectations in Trade Agreements

On the kinds of trade agreements that Asian nations want:

“What countries are looking for, in my view, has become increasingly bespoke. It’s not just about a kind of broad market access. It’s the particular needs of a country thinking about its economic model for the future. And so the economic dialogues we were having with these countries and the attractiveness of the United States is about a lot more than just: Can we lower barriers to market access?”

Bespoke Trade Agreements: Examples from Japan and Indonesia

“So let me give you some examples. With Japan, they really wanted the critical minerals M.O.U. so that they had a route into the benefits of the I.R.A. [Inflation Reduction Act]. That was kind of their number one ask, much more important to them than some broader-based trade deal. With Indonesia, it’s quite similar. That’s what Indonesia is looking for. Fundamentally, they want to work out a high-standards, critical minerals agreement so that there can be a flow of Indonesian nickel into American electric-vehicle manufacturing, batteries and so forth with other countries.”

Workers and Industries in Trade Agreements

On Whether American Workers and Industries Benefited from Earlier Free-Trade Agreements

“So where did workers fit into that? Now you could say, well, workers fit into that. They’re going to get lower-cost goods, and that’s good for them and, to a certain extent, that’s right, so I’m not averse to free trade. But it has to have some element of a theory for how the U.S. industrial base, the capacity to build here, is sustained, and that’s why I actually think things like the I.R.A. [Inflation Reduction Act] and a critical minerals agreement with Japan are a more rational way to think about free trade going forward.”

Lessons from Meetings with Xi and Wang

The View on China’s Approach

“The single biggest thing that jumps out at me comes out of the meeting with Xi — and it was reinforced in the meeting that President Biden had with Xi, and very much in the meetings with Wang Yi as well, but punctuated — which is my view that when we came into office, the Chinese view was: If you are going to compete with us, then we will not cooperate with you, and we will not have lines of communication. You can’t have it both ways. You have to choose. And we’ve just stuck with our theory, which is managed competition: We’re going to compete, we’re going to compete vigorously, but that doesn’t mean that we shouldn’t find areas to work together where it’s in our mutual interest at the same time that we’re competing. And, in order to compete responsibly, we have to have communication at all levels, including sustaining military-to-military communication.”

Evolution of the U.S.-China Relationship

“As we leave, the P.R.C. [People’s Republic of China] has, at least for the time being, adopted, not in the way they talk, but in the way the relationship is conducted, managed competition. We have found areas to work together: on counternarcotics, A.I., nuclear risk and climate. We have sustained communication, including military-to-military communication, and we are competing, obviously competing vigorously, and yet still the relationship has an element of stability so that we’re not presently on the brink of a downward spiral. That is a significant evolution over four years for how the relationship is managed on both sides, and it is consistent with our theory of management of the relationship that the P.R.C. has now mirrored.”

Conclusion

In conclusion, the U.S. approach to trade agreements has evolved to prioritize government-to-government agreements, bespoke agreements tailored to the needs of individual countries, and the importance of sustaining communication and cooperation with partners. This approach acknowledges the complexity of global trade and the need for a more nuanced understanding of the benefits and risks involved.

FAQs

Q: What is the significance of government-to-government agreements in trade?

A: Government-to-government agreements provide a framework for effective security safeguards and transparency around the hardware, model weights, and know-how, which is essential for building strong technology partnerships.

Q: What do Asian nations look for in trade agreements?

A: Asian nations are looking for bespoke agreements that address their specific economic needs and goals, rather than just broad market access.

Q: How do you see the U.S.-China relationship evolving?

A: The U.S.-China relationship has evolved from a situation where China believed that if the U.S. wanted to compete, it would not cooperate and would not have lines of communication, to one where China has adopted managed competition, and the U.S. has found areas to work together while still competing vigorously.