Is there a SQL editor that supports SQLite databases and also features schema intellisense?
I can't seem to find anything out there.
+1
A:
You should try RazorSQL. They have a SQLite SQL Editor.
From their page:
- SQL syntax highlighting
- SQL function lookup
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
Geoffrey Chetwood
2009-02-23 23:59:09
Has a bit of a redrawing problem on Windows 2000, but on the whole probably the best of the bunch.
AngryHacker
2009-02-24 00:46:08
+1
A:
Have you tried SQLite Administrator? It's not bad at all and it's free :).
gcores
2009-02-24 00:14:56
I like it. The downside: has no preferences screen. How does one tell it to have the intellisense come up automatically instead of having to press Ctrl+Space
AngryHacker
2009-02-24 00:46:57