[sqlite] Easy way to change a column

For SQLite is there an easy way to find out ALL other tables, queries and triggers that will be affected when performing a change to a particular column under the cursor? That would make refactoring so much easier. ___ sqlite-users mailing list

[sqlite] How to use my own python function in a SQLite WHERE clause?

I coded a module that has a ChineseDate class, which automatically parse Chinese dates characters into a python-dateutil object(which actually is a datetime.datetime object as well). I used detect_types=sqlite3.PARSE_DECLTYPES to tell the connection object to store this ChineseDate type directly

[sqlite] best practice on sqlite database schema refactoring

>From time to time, with a database already loaded with hundreds records, I need to change a column name, or move a field from one table to another table(sometimes even another database). I use python to code with my database. With python if you want to refactor your code there is a lot of tools

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

After a thorough trial I've finally got this firefox add-on to work properly. And it's great! It basically provides everything that I needed, except for one: changing foreign key constraints from the gui. Is it possible to do it from sqlite manager add-on? And more generally, when a database is

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

Linux is the only operating system. On Sep 18, 2013 5:03 AM, "Simon Slavin" wrote: > > On 18 Sep 2013, at 1:49am, niubao wrote: > > > Is there a tool that allows you to graphically change sqlite schema as > simple > > as editing a spreadsheet? > > What

[sqlite] a tool that allows you to graphically change sqlite schema

Is there a tool that allows you to graphically change sqlite schema as simple as editing a spreadsheet? For example if I wanted to change a column name from "my_driving_hours" to "driving_time", instead of writing a line of code, I can just click on that column and type in the new name, letting