Square root in SQLite studio

sqlite

SQLite studio does not support square root function, so I have defined it in function editor as

proc SqrtA {num} {  set ans [expr {sqrt($num)}] return $ans }

with function nameSqrtA and one input argument, lang. tcl but when I am using it in query editor, I am not getting the square root.

For example I had tried for:

select SqrtA(9);

Can anyone please help me, in how to include square root function in SQLite studio?

Best Answer

You should not define a Tcl procedure inside body of SQL function. Instead use only following line as function implementation (and nothing more):

expr {sqrt([lindex $argv 0])}

If you define a proc inside function definition you will be creating a new Tcl procedure each time you call the SQL function, which makes no sense, especially when you don't call that procedure in the end.

Anyway, stick to the simple implementation as mentioned above. That should do the work.

Related Solutions

Limits of SQLite

Check out https://stackoverflow.com/q/784173/27310 to get an idea of how big SQLite databases can get in theory without performance problems. However, I'd suggest that you use a good database abstraction layer so you don't have to worry about the underlying database at all. That way, once you hit SQLite's working limits, you can switch over to a non-embedded RDBMS without much work.

Create database with multiple columns using SQLite in Android Studio

Your issue appears to be in your SQL syntax, you missed multiple commas:

                String.format("CREATE TABLE %s (" +
                    "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                    "%s TEXT" + ", %s LONGITUDE, " + "%s LATITUDE)",
                    TaskContract.POI_NAMES, TaskContract.Columns.POI,
                    TaskContract.LONGITUDES, TaskContract.Columns.LONGITUDE,
                    TaskContract.LATITUDES, TaskContract.Columns.LATITUDE);

You also appear to have more strings in the parameters than you have replacement keys for. This may or may not also be part of your issue.

Best Answer

Related Solutions

Limits of SQLite

Create database with multiple columns using SQLite in Android Studio

Related Question