====== Frequently Asked Questions ======

===== General =====

=== What is CodeDB? ===

CodeDB is a macOS desktop application that combines a code editor with a relational database. It lets you store code files, define relationships between them, tag and annotate them with properties, and query everything with SQL.

=== Where is my data stored? ===

CodeDB stores all data in a SQLite database at:

''~/Library/Application Support/CodeDB/relationcode.db''

Your files, relations, tags, properties, and Smart Views are all stored in this single database file.

=== Can I back up my data? ===

Yes. You can copy the database file directly, or use the Query Console to export data as JSON or CSV.

=== What file types does CodeDB support? ===

CodeDB supports syntax highlighting for 20+ languages including JavaScript, TypeScript, Python, Rust, Go, Java, Swift, HTML, CSS, JSON, Markdown, SQL, Shell, PHP, Ruby, C/C++, XML, YAML, and more. CSV and TSV files get a dedicated table viewer.

===== Files & Editing =====

=== Is there a file size limit? ===

Files up to 50 MB can be imported. This is generous enough to handle large CSV/TSV datasets.

=== Are changes saved automatically? ===

Yes. File edits are automatically saved to the database as you type.

=== Can I import an existing project? ===

Yes. Use the folder import button (📂) to import an entire directory. CodeDB will recursively import all supported files while preserving the folder structure.

===== CSV/TSV =====

=== How do I open a CSV file in table view? ===

Just open the file. CodeDB automatically renders CSV and TSV files as tables. Use the toolbar buttons to switch between Table, Raw, and Edit modes.

=== Can CodeDB handle large CSV files? ===

Yes. The CSV viewer uses virtual scrolling, so files with 100,000+ rows render smoothly. Only visible rows are added to the DOM at any time.

=== Can I edit CSV data in the table view? ===

Not directly in the table. Switch to Edit mode, modify the raw text, and switch back to Table mode. The table will reflect your changes.

===== Relations & Queries =====

=== What SQL dialect does CodeDB use? ===

CodeDB uses SQLite. All standard SQLite SQL syntax is supported in the Query Console.

=== Can I export query results? ===

Yes. Query results can be exported as JSON, CSV, or Mermaid diagram syntax.

===== Support =====

=== How do I get help? ===

Contact us at [[codedb@mccanalytics.com|codedb@mccanalytics.com]] or visit [[https://mccanalytics.com|mccanalytics.com]].