Creating an sqlite db outside of B4A

[Ricky D]

What tools are available to create sqlite databases I can put in my app?

I've tried creating one from the firefox sqlite manager add on but B4A wouldn't read it.

Any ideas?

regards, Ricky

 

[NJDude]

You can try SQLite Studio

 

[Ricky D]

have you used it?

I am wondering if it works with b4a?

regards, Ricky

 

[NJDude]

Yes, I use it all the time, I create a DB and then add it to my B4A project.

 

[Ricky D]

Key field though?

I can't set a field to be the key for the table

How do you do that?

regards, Ricky

 

[NJDude]

Click on "Create Index" on the icon menu.

If that app is not of your liking, you could try SQLiteExpert is not free but it has a trial version and way better than SQLite Studio.

 

[Ricky D]

I can't afford to buy more software so this will have to do

but how do I create the field manually and what format would it be?

regards, Ricky

 

[NJDude]

If you create a DB from scratch, you will see all the settings available, is not difficult.

 

[Inman]

I use SQLite Database Browser to create db on Windows and then bundle it with the Android apps. The database it creates is 100% compatible with B4A. You can create tables and add data manually or you can import from CSV files as well. It also has an option to test SQL queries and see the data that gets returned which is convenient as you can fine tune the queries and use it on B4A instead of doing trial and error on B4A itself.

And the best part - it is free

 

[NJDude]

Inman, the version you posted is the "old" version of SQLiteStudio.

 

[Ricky D]

ok...

Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

 

[Inman]

Inman, the version you posted is the "old" version of SQLiteStudio.

Really? Never knew it. I downloaded it 2 years back for another project and never had to look for another app (or even an update) as it fit all my needs.

 

[NJDude]

Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

Look at the screen shot, you have to click on the [...] button and then enter the data type.

 

[Ricky D]

Even setting the type to boolean didn't work

I created a simple table :

Shifts
TableID Int Primary Key Not Null
IsLocked boolean

then when I run this sql in the Execute Sql pane on sql studio

Insert Into Shifts (TableID,IsLocked) Values (1,true)

it threw an error

changing it to

Insert Into Shifts (TableID,IsLocked) Values (1,1)

worked

So I'll store them as Int with false=0 and true=1

cheers, Ricky

 

[Kiffi]

my favourite is TkSQLite.

Greetings ... Kiffi

 

[warwound]

I created a simple table :

Shifts
TableID Int Primary Key Not Null
IsLocked boolean

then when I run this sql in the Execute Sql pane on sql studio

Insert Into Shifts (TableID,IsLocked) Values (1,true)

it threw an error

changing it to

Insert Into Shifts (TableID,IsLocked) Values (1,1)

worked

So I'll store them as Int with false=0 and true=1

cheers, Ricky

That behaviour sounds like the way MySQL handles Boolean data type.

MySQL does in theory have a Boolean data type but:

These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true

That's a quote from MySQL :: MySQL 5.0 Reference Manual :: 10.1.1 Numeric Type Overview.

Use an Integer data type in SQLite and you'll have no problems.

Martin.

 

[Ricky D]

that's it

:icon_clap:

Thanks for showing me that. I've implemented it as ints and is working just fine.

cheers, Ricky

 

[stefanoa]

SQLite Expert Personal (freeware)
SQLite Expert - A powerful administration tool for your SQLite databases

 

[mjtaryan]

Back to my original problem.

It doesn't have boolean.

How do you handle booleans in android sqlite?

:BangHead:

regards, Ricky

I don't know whether you got an answer to your question, but I was just reading some SQLite documentation and came across just the info you need.


SQLite, first of all, does not employ datatypes in the more common fashion. And second, with reference to your question, implements Boolean as an integer with 0 = False and 1 = True. For more details go to SQLite.org and search for "Boolean". Hope this helps.

 

[alienhunter]

I am using this one
:sign0163:
works like a charm ...for everything

WampServer,
a Windows web development environment.

WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin allows you to manage easily your databases.


WampServer, the web development platform on Windows - Apache, MySQL, PHP