Friday, April 8, 2011

Where can I find a SQLite code editor with schema intellisense?

Is there a SQL editor that supports SQLite databases and also features schema intellisense?

I can't seem to find anything out there.

From stackoverflow
  • 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)
    AngryHacker : Has a bit of a redrawing problem on Windows 2000, but on the whole probably the best of the bunch.
  • Have you tried SQLite Administrator? It's not bad at all and it's free :).

    AngryHacker : 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

0 comments:

Post a Comment