Re: [sqlite] Table names length and content

[Keith Medcalf]

You get a palladium star for avoiding the most obvious source of errors (and 
wasted keystrokes) ... 

---
Theory is when you know everything but nothing works.  Practice is when 
everything works but no one knows why.  Sometimes theory and practice are 
combined:  nothing works and no one knows why.

>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Drago, William @ CSG - NARDAEAST
>Sent: Monday, 8 December, 2014 11:38
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Table names length and content
>
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of Richard Hipp
>> Sent: Monday, December 08, 2014 1:28 PM
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] Table names length and content
>>
>> On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera
>> <jic...@cinops.xerox.com
>> > wrote:
>>
>> >
>> > "Stephan Beal" wrote...
>> >
>> >  On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera <
>> >> jic...@cinops.xerox.com
>> >>
>> >>> wrote:
>> >>>
>> >>
>> >>  When creating table names, are there any constraints that one must
>> >> look
>> >>> for? ie. Length? Characters? etc.?  I quickly browse through this
>> >>> spot,
>> >>>
>> >>> https://www.sqlite.org/lang_createtable.html
>> >>>
>> >>
>> >>
>> >> https://www.sqlite.org/limits.html
>> >>
>> >> might have what you're looking for.
>> >>
>> >
>> > Hmmm... what I am looking for it is not there.  If the "string
>> length"
>> > defined there is what defines the length of the name of a table, I am
>> > in business. :-)  However, there is nothing about problematic
>> characters. ie.
>> > <>!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name.
>> >
>> >
>> Put the table name in double-quotes.
>
>Uh oh! I never use quotes when I create my tables. What are the
>implications of not quoting?
>
>-Bill
>CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
>attachments are solely for the use of the addressee and may contain
>information that is privileged or confidential. Any disclosure, use or
>distribution of the information contained herein is prohibited. In the
>event this e-mail contains technical data within the definition of the
>International Traffic in Arms Regulations or Export Administration
>Regulations, it is subject to the export control laws of the
>U.S.Government. The recipient should check this e-mail and any
>attachments for the presence of viruses as L-3 does not accept any
>liability associated with the transmission of this e-mail. If you have
>received this communication in error, please notify the sender by reply
>e-mail and immediately delete this message and any attachments.
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[jose isaias cabrera]

"Richard Hipp" wrote...


On Mon, Dec 8, 2014 at 1:36 PM, Roger Binns  wrote:


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/08/2014 10:30 AM, jose isaias cabrera wrote:
>>> Hmmm... what I am looking for it is not there.  If the "string
>>> length" defined there is what defines the length of the name of
>>> a table, I am in business. :-)  However, there is nothing about
>>> problematic characters. ie. <>!@#$%^&*()_+=-{}\|[]'";:?/.,,
>>> etc., etc. in the table name.

SQLite supports all those, as well as zero length table names, column
types and names.



But just because SQLite supports all of that does not mean that you
*should* use it.  I'm worried about what you are contemplating, Jose.  I
think you would be better off to use a short and simple lower-case ASCII
table name.


Most of the time, I use single and lowercase names.  And, I will take your 
advice and continue with such.  I was trying to do an easy hack, but, you're 
right.  It's a long story, so I will save it for another day...  Thanks all.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Drago, William @ CSG - NARDAEAST]

That's a relief. I thought I was doing something wrong.

Thanks,
--
Bill Drago
Senior Engineer
L3 Communications / Narda Microwave East
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Stephan Beal
> Sent: Monday, December 08, 2014 1:41 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Table names length and content
>
> On Mon, Dec 8, 2014 at 7:37 PM, Drago, William @ CSG - NARDAEAST <
> william.dr...@l-3com.com> wrote:
>
> > Uh oh! I never use quotes when I create my tables. What are the
> > implications of not quoting?
> >
>
> If you restrict yourself to C-style identifiers, the primary
> implication is better ease of use and readability! ;)
>
> --
> - stephan beal
> http://wanderinghorse.net/home/stephan/
> http://gplus.to/sgbeal
> "Freedom is sloppy. But since tyranny's the only guaranteed byproduct
> of those who insist on a perfect world, freedom will have to do." --
> Bigby Wolf ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Richard Hipp]

On Mon, Dec 8, 2014 at 1:36 PM, Roger Binns  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 12/08/2014 10:30 AM, jose isaias cabrera wrote:
> >>> Hmmm... what I am looking for it is not there.  If the "string
> >>> length" defined there is what defines the length of the name of
> >>> a table, I am in business. :-)  However, there is nothing about
> >>> problematic characters. ie. <>!@#$%^&*()_+=-{}\|[]'";:?/.,,
> >>> etc., etc. in the table name.
>
> SQLite supports all those, as well as zero length table names, column
> types and names.
>

But just because SQLite supports all of that does not mean that you
*should* use it.  I'm worried about what you are contemplating, Jose.  I
think you would be better off to use a short and simple lower-case ASCII
table name.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Stephan Beal]

On Mon, Dec 8, 2014 at 7:37 PM, Drago, William @ CSG - NARDAEAST <
william.dr...@l-3com.com> wrote:

> Uh oh! I never use quotes when I create my tables. What are the
> implications of not quoting?
>

If you restrict yourself to C-style identifiers, the primary implication is
better ease of use and readability! ;)

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Stephan Beal]

On Mon, Dec 8, 2014 at 7:36 PM, Roger Binns  wrote:

> SQLite supports all those, as well as zero length table names, column
> types and names.
>
>
> sqlite> create table " <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc., etc. in
> the table name"("" "");
>

To whichl add: sqlite allows it. Your fellow colleagues, on the other hand,
will hopefully not let such things through code review ;).


(Empty strings? Really?)

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Drago, William @ CSG - NARDAEAST]

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Richard Hipp
> Sent: Monday, December 08, 2014 1:28 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Table names length and content
>
> On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera
> <jic...@cinops.xerox.com
> > wrote:
>
> >
> > "Stephan Beal" wrote...
> >
> >  On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera <
> >> jic...@cinops.xerox.com
> >>
> >>> wrote:
> >>>
> >>
> >>  When creating table names, are there any constraints that one must
> >> look
> >>> for? ie. Length? Characters? etc.?  I quickly browse through this
> >>> spot,
> >>>
> >>> https://www.sqlite.org/lang_createtable.html
> >>>
> >>
> >>
> >> https://www.sqlite.org/limits.html
> >>
> >> might have what you're looking for.
> >>
> >
> > Hmmm... what I am looking for it is not there.  If the "string
> length"
> > defined there is what defines the length of the name of a table, I am
> > in business. :-)  However, there is nothing about problematic
> characters. ie.
> > <>!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name.
> >
> >
> Put the table name in double-quotes.

Uh oh! I never use quotes when I create my tables. What are the implications of 
not quoting?

-Bill
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/08/2014 10:30 AM, jose isaias cabrera wrote:
>>> Hmmm... what I am looking for it is not there.  If the "string
>>> length" defined there is what defines the length of the name of
>>> a table, I am in business. :-)  However, there is nothing about
>>> problematic characters. ie. <>!@#$%^&*()_+=-{}\|[]'";:?/.,,
>>> etc., etc. in the table name.

SQLite supports all those, as well as zero length table names, column
types and names.


sqlite> create table " <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc., etc. in
the table name"("" "");

sqlite> .header on

sqlite> pragma table_info(" <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc.,
etc. in the table name");

cid|name|type|notnull|dflt_value|pk
0|||0||0

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSF764ACgkQmOOfHg372QRorQCcDbpSsjwclDLcKAiRQlFOC73M
Sc8AnirtIkzx1v/5LWrAc1VYAGJ53MnS
=bj14
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[jose isaias cabrera]

"Richard Hipp" wrote...

On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera 
!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name.



Put the table name in double-quotes.  If the table name contains a
double-quote mark (ascii 0x22) then double it.  The name of the table
cannot start with "sqlite" but otherwise, there are no other restrictions
that I recall.


Thanks, Dr. Hipp.  That is what I was looking for.  I will let you know if 
something does not work.


josé 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Richard Hipp]

On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera  wrote:

>
> "Stephan Beal" wrote...
>
>  On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera <
>> jic...@cinops.xerox.com
>>
>>> wrote:
>>>
>>
>>  When creating table names, are there any constraints that one must look
>>> for? ie. Length? Characters? etc.?  I quickly browse through this spot,
>>>
>>> https://www.sqlite.org/lang_createtable.html
>>>
>>
>>
>> https://www.sqlite.org/limits.html
>>
>> might have what you're looking for.
>>
>
> Hmmm... what I am looking for it is not there.  If the "string length"
> defined there is what defines the length of the name of a table, I am in
> business. :-)  However, there is nothing about problematic characters. ie.
> <>!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name.
>
>
Put the table name in double-quotes.  If the table name contains a
double-quote mark (ascii 0x22) then double it.  The name of the table
cannot start with "sqlite" but otherwise, there are no other restrictions
that I recall.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[jose isaias cabrera]

"Stephan Beal" wrote...

On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera 
!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name.


Thoughts?  Thanks.

josé 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table names length and content

[Stephan Beal]

On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera  wrote:

> When creating table names, are there any constraints that one must look
> for? ie. Length? Characters? etc.?  I quickly browse through this spot,
>
> https://www.sqlite.org/lang_createtable.html


https://www.sqlite.org/limits.html

might have what you're looking for.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Table names length and content

[jose isaias cabrera]

Greetings!

When creating table names, are there any constraints that one must look for? 
ie. Length? Characters? etc.?  I quickly browse through this spot,


https://www.sqlite.org/lang_createtable.html

but could not find any information regarding this.  Would someone please 
bring light for this subject for me?  Thanks.


josé 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users