Forums intermittently going down?

CharlesM charlesm at gmail.com
Wed Sep 26 02:54:35 UTC 2018


On Wednesday, 26 September 2018 at 02:42:15 UTC, Vladimir 
Panteleev wrote:
> On Wednesday, 26 September 2018 at 02:28:27 UTC, CharlesM wrote:
>> If you're using SQLite you don't need to specify the size of 
>> the columns, for what I gather it's useless for this DB.
>
> Yep, this is mostly descriptive. Types in column declarations 
> have mostly the same effect.
>
>> And if I'm not mistaken it usually preferable to use TEXT for 
>> strings.
>
> In SQLite? How so?

I don't remember where I read, but it's because the type 
affinity, in fact in the and it doesn't matter because VARCHAR 
will be TEXT in the end: https://www.sqlite.org/datatype3.html

So at least you save space in your script. :)

I'm a bit rusty with SQLite, but I was on a project a year ago, 
and I had this big table and trying with/without NULL, I got a 
better performance without it.

By the way I found this: https://blog.paddlefish.net/?p=885


More information about the Digitalmars-d mailing list