Skip to main content

Databases

Boltic Tables SDK is your complete toolkit for database operations. It transforms complex database interactions into simple, readable JavaScript functions, allowing you to focus on building great applications rather than wrestling with API complexities.

Core Capabilities​

  • 🗃️ Table Management - Create, configure, and organize your database structure
  • 📋 Column Operations - Define data types, constraints, and relationships
  • 📝 Record Handling - Insert, update, delete, and query your data efficiently
  • 🔍 Advanced Querying - Filter, sort, and paginate with powerful query builders
  • 🗣️ SQL Operations - Execute raw SQL queries and convert natural language to SQL
  • 🔒 Type Safety - Full TypeScript support with auto-completion and error prevention

Supported Data Types​

Boltic Tables supports a comprehensive range of data types for any application:

Basic Types​

  • Text - Short text fields (names, titles, descriptions)
  • Long Text - Rich content, articles, detailed descriptions
  • Number - Integers and decimals with formatting options
  • Currency - Monetary values with currency symbols and formatting

Advanced Types​

  • Date & Time - Timestamps, dates, and time ranges
  • Checkbox - Boolean values with custom labels
  • Single Select - Dropdown with predefined options
  • Multi Select - Multiple choice selections
  • Email - Email addresses with validation
  • URL - Web links with validation
  • Phone - International phone numbers

Special Types​

  • JSON - Complex structured data and objects
  • Vector - AI embeddings and machine learning features
  • Auto Number - Sequential IDs and counters
  • Formula - Calculated fields based on other columns

Ready to transform your data management experience? Let's build something amazing together! 🚀