I am using SQLite.
我正在使用SQLite。
When I execute a query, I get error messages such as "error near select" or "error near ','". I wish it would give me a line number or statement number.
当我执行查询时,我收到错误消息,例如“选择错误”或“附近错误”,“”。我希望它会给我一个行号或声明号。
After loading a trigger and encountering an error either in syntax or at run-time, I must go back to my editor and make changes. Then I have to execute a drop trigger command before reloading the trigger.
加载触发器并在语法或运行时遇到错误后,我必须返回编辑器进行更改。然后我必须在重新加载触发器之前执行drop trigger命令。
Is there a good SQLite browser or command line tool that provides more information than the one I am using?
有没有一个好的SQLite浏览器或命令行工具提供比我使用的更多的信息?
Setting aside the implementation differences, would it make more sense for me to switch to mySQL?
抛开实现差异,切换到mySQL会更有意义吗?
1 个解决方案
#1
2
Using a different browser for SQLite wouldn't make that much of a difference since it would use the same library. Switching to MySQL in my experience is not a trade up in terms of error messaging, it's about the same or worse in my opinion. PostgreSQL, however (again in my experience), has much better error messaging, although it can at times be just as cryptic as MySQL or SQLite.
使用不同的SQLite浏览器不会产生太大的区别,因为它会使用相同的库。根据我的经验切换到MySQL并不是在错误消息方面的交易,在我看来它大致相同或更差。然而,PostgreSQL(再次根据我的经验)有更好的错误消息,尽管它有时可能像MySQL或SQLite一样神秘。
#1
2
Using a different browser for SQLite wouldn't make that much of a difference since it would use the same library. Switching to MySQL in my experience is not a trade up in terms of error messaging, it's about the same or worse in my opinion. PostgreSQL, however (again in my experience), has much better error messaging, although it can at times be just as cryptic as MySQL or SQLite.
使用不同的SQLite浏览器不会产生太大的区别,因为它会使用相同的库。根据我的经验切换到MySQL并不是在错误消息方面的交易,在我看来它大致相同或更差。然而,PostgreSQL(再次根据我的经验)有更好的错误消息,尽管它有时可能像MySQL或SQLite一样神秘。