Re: [Emc-users] Tool Shape

[John Thornton]

I'm working on a checkbook program and I noticed that if you use a REAL 
field and store 1.00 into it it only stores the 1 so I just use text now 
to store numbers.

JT

On 4/22/2014 10:23 AM, Gene Heskett wrote:
> What sort of contortions are required to fully recover a number stored in
> SQLite as text?  Seems like the unwary, me, could be bitten pretty easily.
>   
>
> Cheers, Gene


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Gene Heskett]

On Tuesday 22 April 2014 12:38:24 andy pugh did opine:

> On 22 April 2014 16:23, Gene Heskett  wrote:
> > What sort of contortions are required to fully recover a number stored
> > in SQLite as text?
> 
> Why would you need to?

Something in the back of my mind, possibly from a past life, tells me there 
are often rounding errors in the recovery unless it is stored as the 
fprintf %ld format.  But the memory is faint, goes back to writing an 
eclipse finder in C probably 20 years back up the log.  I think, but cannot 
prove that when using the julian calendar, the backwards math chokes and 
upchucks all over itself somewhere around may or june 4713 BC.

The original truebasic program I translated it from also suffered a similar 
fate IIRC, as was noted in the BYTE magazine article giving the truebasic 
code listing.  That is apparently the origin time of that calendar, equ to 
the unix 1/1/1970, but it doesn't do negative numbers at all well.

Possible moot for this application if enough digits are stored.  AT least a 
double double (16 or 17 digits) stored as a double float should be ok.

Cheers, Gene
-- 
"There are four boxes to be used in defense of liberty:
 soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
Genes Web page 
US V Castleman, SCOTUS, Mar 2014 is grounds for Impeaching SCOTUS

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 22 April 2014 16:23, Gene Heskett  wrote:

> What sort of contortions are required to fully recover a number stored in
> SQLite as text?

Why would you need to?

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Tuesday 22 April 2014 11:22:14 John Thornton did opine:

> With MySql you need to install LAMP and with postgresql it looks like
> you have to have a server running and create a user that can log into
> the server or something like that. Sqlite requires non of that. I've
> used MySql for web based PHP applications and Sqlite for local Python
> applications. Sqlite is far more portable IMHO than the other two. I
> don't recall having to do more than have "import sqlite3" in the header
> of my python file to use Sqlite. The only catch with Sqlite is how it
> handles numbers and I've used text fields for number entries to work
> around that.
>
> JT_

LAMP is only required  with MySQL if you are running MySQL in conjunction
with a web server and PHP.

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Gene Heskett]

On Tuesday 22 April 2014 11:22:14 John Thornton did opine:

> With MySql you need to install LAMP and with postgresql it looks like
> you have to have a server running and create a user that can log into
> the server or something like that. Sqlite requires non of that. I've
> used MySql for web based PHP applications and Sqlite for local Python
> applications. Sqlite is far more portable IMHO than the other two. I
> don't recall having to do more than have "import sqlite3" in the header
> of my python file to use Sqlite. The only catch with Sqlite is how it
> handles numbers and I've used text fields for number entries to work
> around that.
> 
> JT

What sort of contortions are required to fully recover a number stored in 
SQLite as text?  Seems like the unwary, me, could be bitten pretty easily.
 
> On 4/22/2014 4:19 AM, Mark Wendt wrote:
> > On Mon, Apr 21, 2014 at 1:47 PM, Marius Liebenberg
> > 
> > wrote:
> >> Andy
> >> Have a look at this work. Maybe a good solution.
> >> https://github.com/bitsnbytes7c8/MegatronDB
> > 
> > What's wrong with using proven, production-style databases that work
> > well large or small?  MySQL and postgresql are bullet-proof, have a
> > large user base, and great support.  And are easier to backup than
> > just about any other free database.  There are software utilities out
> > there to hot backup both MySQL and postgresql.
> > 
> > Mark
> > --
> >  Start Your Social Network Today - Download eXo Platform
> > Build your Enterprise Intranet with eXo Platform Software
> > Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> > Get Started Now And Turn Your Intranet Into A Collaboration Platform
> > http://p.sf.net/sfu/ExoPlatform
> > ___
> > Emc-users mailing list
> > Emc-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/emc-users
> 
> 
> -- Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> ___
> Emc-users mailing list
> Emc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/emc-users


Cheers, Gene
-- 
"There are four boxes to be used in defense of liberty:
 soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
Genes Web page 
US V Castleman, SCOTUS, Mar 2014 is grounds for Impeaching SCOTUS

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[kqt4at5v]

On Tue, 22 Apr 2014, Mark Wendt wrote:

> On Tue, Apr 22, 2014 at 6:36 AM, andy pugh  wrote:
>
>> On 22 April 2014 10:20, Mark Wendt  wrote:
>>
>>> Why not leave the choice up to the end user as to which database they'd
>>> prefer to use?
>>
>> This would work if the query language was 100% identical. I don't know
>> if it is.
>>
>> --
>> atp
>>
>
>
> SQL is SQL.  MySQL. postgresql and SQLite all use, "SQL."  The only
> differences between the three are in the database engine code and how it
> maintains and operates the database.
>

MySQL and PostgreSQL are heavy weight rdbm. SQLite is an embedded rdbm. 
There a many of the SQL standards and each of these rdbm attempt to adhere
to parts of one of these standards. None of them are 100% compliant. I 
work with all of these rdbm on a daily basic.

Richard


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Tue, Apr 22, 2014 at 6:36 AM, andy pugh  wrote:

> On 22 April 2014 10:20, Mark Wendt  wrote:
>
> > Why not leave the choice up to the end user as to which database they'd
> > prefer to use?
>
> This would work if the query language was 100% identical. I don't know
> if it is.
>
> --
> atp
>


SQL is SQL.  MySQL. postgresql and SQLite all use, "SQL."  The only
differences between the three are in the database engine code and how it
maintains and operates the database.

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[John Thornton]

With MySql you need to install LAMP and with postgresql it looks like 
you have to have a server running and create a user that can log into 
the server or something like that. Sqlite requires non of that. I've 
used MySql for web based PHP applications and Sqlite for local Python 
applications. Sqlite is far more portable IMHO than the other two. I 
don't recall having to do more than have "import sqlite3" in the header 
of my python file to use Sqlite. The only catch with Sqlite is how it 
handles numbers and I've used text fields for number entries to work 
around that.

JT

On 4/22/2014 4:19 AM, Mark Wendt wrote:
> On Mon, Apr 21, 2014 at 1:47 PM, Marius Liebenberg
> wrote:
>
>> Andy
>> Have a look at this work. Maybe a good solution.
>> https://github.com/bitsnbytes7c8/MegatronDB
>>
>
> What's wrong with using proven, production-style databases that work well
> large or small?  MySQL and postgresql are bullet-proof, have a large user
> base, and great support.  And are easier to backup than just about any
> other free database.  There are software utilities out there to hot backup
> both MySQL and postgresql.
>
> Mark
> --
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> ___
> Emc-users mailing list
> Emc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/emc-users


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 22 April 2014 10:20, Mark Wendt  wrote:

> Why not leave the choice up to the end user as to which database they'd
> prefer to use?

This would work if the query language was 100% identical. I don't know
if it is.

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Mon, Apr 21, 2014 at 2:02 PM, andy pugh  wrote:

>
> Possibly.
>
> The real work is in working out everywhere that tool data is used, and
> when changes get committed back to the DB.
>
> The details of the storage can be decided later (if sqlite proves to
> be not ideal).
>
> --
> atp
>

Why not leave the choice up to the end user as to which database they'd
prefer to use?

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Mon, Apr 21, 2014 at 1:47 PM, Marius Liebenberg
wrote:

> Andy
> Have a look at this work. Maybe a good solution.
> https://github.com/bitsnbytes7c8/MegatronDB
>


What's wrong with using proven, production-style databases that work well
large or small?  MySQL and postgresql are bullet-proof, have a large user
base, and great support.  And are easier to backup than just about any
other free database.  There are software utilities out there to hot backup
both MySQL and postgresql.

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 21 April 2014 18:47, Marius Liebenberg  wrote:
> Andy
> Have a look at this work. Maybe a good solution.
> https://github.com/bitsnbytes7c8/MegatronDB

Possibly.

The real work is in working out everywhere that tool data is used, and
when changes get committed back to the DB.

The details of the storage can be decided later (if sqlite proves to
be not ideal).

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Marius Liebenberg]

Andy
Have a look at this work. Maybe a good solution.
https://github.com/bitsnbytes7c8/MegatronDB

On 2014-04-21 17:37, andy pugh wrote:
> On 21 April 2014 11:33, Marius Liebenberg  wrote:
>> Whats wrong with a file based tool table. It is easier for the layman to
>> maintain offline as well.
> A simple flat file has to make assumptions about what data can be
> stored. Specifically it would have to make assumptions about how many
> offsets each tool was allowed to have, for example.
>
> The relational database approach allows one tool to have many offsets,
> one pocket to contain many tools (and, conversely. one tool to appear
> in many pockets) and so on.
>
> In most cases it will look exactly the same in tooledit (or whatever
> replaces tooledit). But if Kirk wanted to add a nose-radius tag to the
> geometry table, he can easily do that without breaking anything else.
>

-- 

Regards /Groete

Marius D. Liebenberg
+27 82 698 3251
+27 12 743 6064
QQ 1767394877


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Marius Liebenberg]

I understand now. I have to agree with you that the SQlite option will 
be the least resource intensive thing to use.
I used to use a file based RDBS a long time ago that was very easy to 
implement with a very small footprint, but I cannot seem to find any 
reference to it anywhere.


On 2014-04-21 17:37, andy pugh wrote:
> On 21 April 2014 11:33, Marius Liebenberg  wrote:
>> Whats wrong with a file based tool table. It is easier for the layman to
>> maintain offline as well.
> A simple flat file has to make assumptions about what data can be
> stored. Specifically it would have to make assumptions about how many
> offsets each tool was allowed to have, for example.
>
> The relational database approach allows one tool to have many offsets,
> one pocket to contain many tools (and, conversely. one tool to appear
> in many pockets) and so on.
>
> In most cases it will look exactly the same in tooledit (or whatever
> replaces tooledit). But if Kirk wanted to add a nose-radius tag to the
> geometry table, he can easily do that without breaking anything else.
>

-- 

Regards /Groete

Marius D. Liebenberg
+27 82 698 3251
+27 12 743 6064
QQ 1767394877


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 21 April 2014 11:33, Marius Liebenberg  wrote:
> Whats wrong with a file based tool table. It is easier for the layman to
> maintain offline as well.

A simple flat file has to make assumptions about what data can be
stored. Specifically it would have to make assumptions about how many
offsets each tool was allowed to have, for example.

The relational database approach allows one tool to have many offsets,
one pocket to contain many tools (and, conversely. one tool to appear
in many pockets) and so on.

In most cases it will look exactly the same in tooledit (or whatever
replaces tooledit). But if Kirk wanted to add a nose-radius tag to the
geometry table, he can easily do that without breaking anything else.

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Marius Liebenberg]

Whats wrong with a file based tool table. It is easier for the layman to 
maintain offline as well.

On 2014-04-21 11:37, andy pugh wrote:
> On 21 April 2014 10:10, Mark Wendt  wrote:
>
>> Ugh.  Stay away from SQLite.  That's a one-user, build it in your home
>> directory, terribly slow, resource hog.  MySQL or PostgreSQL are much
>> better databases.  You can optimize them much easier and better,
> It's a tool table. Just how big and busy do you anticipate it getting?
>

-- 

Regards /Groete

Marius D. Liebenberg
+27 82 698 3251
+27 12 743 6064
QQ 1767394877


--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Mon, Apr 21, 2014 at 5:52 AM, andy pugh  wrote:

> On 21 April 2014 10:43, Mark Wendt  wrote:
>
> >> It's a tool table. Just how big and busy do you anticipate it getting?
>
> > It depends.  For somebody like me, not very big, but for somebody like
> > Stuart, I imagine it might grow a bit.
>
> I imagine even MPM only have hundreds of tools and a couple of tool
> changes per minute.
>
> If there turns out to be a real problem then the back-end could
> change, but it seems good to avoid dependencies where possible.
>
> --
> atp
>


It didn't take long for the SQLite database to cause problems on the server
we were running it on, overhead wise.  What dependencies would you have
with MySQL that you wouldn't have with SQLite?

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 21 April 2014 10:43, Mark Wendt  wrote:

>> It's a tool table. Just how big and busy do you anticipate it getting?

> It depends.  For somebody like me, not very big, but for somebody like
> Stuart, I imagine it might grow a bit.

I imagine even MPM only have hundreds of tools and a couple of tool
changes per minute.

If there turns out to be a real problem then the back-end could
change, but it seems good to avoid dependencies where possible.

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Mon, Apr 21, 2014 at 5:37 AM, andy pugh  wrote:

> On 21 April 2014 10:10, Mark Wendt  wrote:
>
> > Ugh.  Stay away from SQLite.  That's a one-user, build it in your home
> > directory, terribly slow, resource hog.  MySQL or PostgreSQL are much
> > better databases.  You can optimize them much easier and better,
>
> It's a tool table. Just how big and busy do you anticipate it getting?
>
> --
> atp
> If you can't fix it, you don't own it.
> http://www.ifixit.com/Manifestomc-users
>

It depends.  For somebody like me, not very big, but for somebody like
Stuart, I imagine it might grow a bit.

You might also find the overhead from the SQLite database hogging machine
resources.  It did on the one server I installed it on before I realized
what a lousy database it was.  It may interfere with the machine controller
if it gets too busy.

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 21 April 2014 10:10, Mark Wendt  wrote:

> Ugh.  Stay away from SQLite.  That's a one-user, build it in your home
> directory, terribly slow, resource hog.  MySQL or PostgreSQL are much
> better databases.  You can optimize them much easier and better,

It's a tool table. Just how big and busy do you anticipate it getting?

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Mark Wendt]

On Mon, Apr 21, 2014 at 4:32 AM, andy pugh  wrote:

> On 21 April 2014 03:30, Kirk Wallace  wrote:
>
> >> I did start on making the tool table a lot cleverer. It would be a
> >> database (which means that you can actually add any data fields you
> >> like for your own purposes, LinuxCNC will just ignore things it
> >> doesn't know how to use)
> >
> > Redis maybe?
>
> SQLite, actually.
>
> http://wiki.linuxcnc.org/cgi-bin/wiki.pl?ToolDatabase
>
> --
> atp
> If you can't fix it, you don't own it.
> http://www.ifixit.com/Manifesto
>


Ugh.  Stay away from SQLite.  That's a one-user, build it in your home
directory, terribly slow, resource hog.  MySQL or PostgreSQL are much
better databases.  You can optimize them much easier and better, and you
won't take the performance hits like you will with SQLite if the database
gets a little busy.  A lot less overhead for the size in the latter
databases.

Mark
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 21 April 2014 03:30, Kirk Wallace  wrote:

>> I did start on making the tool table a lot cleverer. It would be a
>> database (which means that you can actually add any data fields you
>> like for your own purposes, LinuxCNC will just ignore things it
>> doesn't know how to use)
>
> Redis maybe?

SQLite, actually.

http://wiki.linuxcnc.org/cgi-bin/wiki.pl?ToolDatabase

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Kirk Wallace]

On 04/20/2014 03:48 PM, andy pugh wrote:
> On 20 April 2014 17:28, Pete Matos  wrote:
>> Yeah I know the Haas has the diameter column as well as wear column for the
>> TLO.   I am quite surprised that LinuxCNC does not have these most simple
>> items let alone radius and shape comp.
>
> The CNC controller doesn't know enough about the material shape to be
> able to do anything sensible with (for example) ball-nose radius.
> Which isn't to say that the information couldn't live in the tool table.

I want to use an end mill corner radius with a conversational facing 
routine. We are pulling the tool diameter from the table and having the 
operator enter in the full depth diameter (tool dia - 2*corner radius). 
I added to the tool comment field 'CR=x.xxx' and search for the CR= to 
get the value (not exactly true but effectively the same). This way the 
tool information I need comes from the table and can be reused.

> The current tool-table has a fixed size. It can currently handle 56
> tools. If you added nose radius for milling tools then it would hold
> 50 tools (at a guess).
>
> I did start on making the tool table a lot cleverer. It would be a
> database (which means that you can actually add any data fields you
> like for your own purposes, LinuxCNC will just ignore things it
> doesn't know how to use)

Redis maybe?

> I eventually ended up with a scheme where all the machines in a
> factory could share a tool database, and each machine would know what
> tools were available to it. I think that is the way to go. I kind-of
> stalled with waiting to see what happened to NML. There was a preview
> branch that I made, but there was no apparent interest in it.

I suspect there won't be any interest until it becomes the next greatest 
thing.


-- 
Kirk Wallace
http://www.wallacecompany.com/machine_shop/
http://www.wallacecompany.com/E45/

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Kirk Wallace]

On 04/20/2014 12:54 PM, Pete Matos wrote:
> Good luck man.  I would love to see wear columns for each of the two mill
> related offsets length and diameter.  Similar to the Haas and many other
> controls where you just input the base number into the length and diameter

A soon to be released lathe might have wear offsets, but I have no idea 
if it is similar to Haas. Daniel Rogge would be the one to talk to.
https://www.tormach.com/blog/tormach-lathe-update-winter-2014/
http://sourceforge.net/p/emc/feature-requests/103/

-- 
Kirk Wallace
http://www.wallacecompany.com/machine_shop/
http://www.wallacecompany.com/E45/

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Ralph Stirling]

One thing I've always thought would be super useful
would be for the control to be able to share tool table
info with the CAM software.  You set up your tools on
the machine (possibly using probing), and export that
information to your CAM, and you never have to worry
about getting a tool wrong in your CAM configuration
and crashing.  Unfortunately, LinuxCNC control software
is light years ahead of open-source CAM software.  It
still could be useful to make a script that grabs the LinuxCNC
tool table and formats it correctly for closed-source CAM
packages.

-- Ralph

From: andy pugh [bodge...@gmail.com]
Sent: Sunday, April 20, 2014 3:48 PM
To: Enhanced Machine Controller (EMC)
Subject: Re: [Emc-users] Tool Shape

On 20 April 2014 17:28, Pete Matos  wrote:
> Yeah I know the Haas has the diameter column as well as wear column for the
> TLO.   I am quite surprised that LinuxCNC does not have these most simple
> items let alone radius and shape comp.

The CNC controller doesn't know enough about the material shape to be
able to do anything sensible with (for example) ball-nose radius.
Which isn't to say that the information couldn't live in the tool table.

The current tool-table has a fixed size. It can currently handle 56
tools. If you added nose radius for milling tools then it would hold
50 tools (at a guess).

I did start on making the tool table a lot cleverer. It would be a
database (which means that you can actually add any data fields you
like for your own purposes, LinuxCNC will just ignore things it
doesn't know how to use)

I eventually ended up with a scheme where all the machines in a
factory could share a tool database, and each machine would know what
tools were available to it. I think that is the way to go. I kind-of
stalled with waiting to see what happened to NML. There was a preview
branch that I made, but there was no apparent interest in it.

--
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[andy pugh]

On 20 April 2014 17:28, Pete Matos  wrote:
> Yeah I know the Haas has the diameter column as well as wear column for the
> TLO.   I am quite surprised that LinuxCNC does not have these most simple
> items let alone radius and shape comp.

The CNC controller doesn't know enough about the material shape to be
able to do anything sensible with (for example) ball-nose radius.
Which isn't to say that the information couldn't live in the tool table.

The current tool-table has a fixed size. It can currently handle 56
tools. If you added nose radius for milling tools then it would hold
50 tools (at a guess).

I did start on making the tool table a lot cleverer. It would be a
database (which means that you can actually add any data fields you
like for your own purposes, LinuxCNC will just ignore things it
doesn't know how to use)

I eventually ended up with a scheme where all the machines in a
factory could share a tool database, and each machine would know what
tools were available to it. I think that is the way to go. I kind-of
stalled with waiting to see what happened to NML. There was a preview
branch that I made, but there was no apparent interest in it.

-- 
atp
If you can't fix it, you don't own it.
http://www.ifixit.com/Manifesto

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Pete Matos]

Good luck man.  I would love to see wear columns for each of the two mill
related offsets length and diameter.  Similar to the Haas and many other
controls where you just input the base number into the length and diameter
columns and then input any adjustments you make at the control into the
wear columns for the diameter and length. This in the case of the Haas
control would be say -.0002 or whatever and this is calculated in the
control for you.  It is nice to be able to use this to creep up on
dimensions and not have to change the main diameters or length offsets
which may work for other things in  other parts.  It is a real nice and
seemingly simple feature.  Peace


Pete



On Sun, Apr 20, 2014 at 3:33 PM, Kirk Wallace
wrote:

> On 04/20/2014 09:28 AM, Pete Matos wrote:
> > Yeah I know the Haas has the diameter column as well as wear column for
> the
> > TLO.   I am quite surprised that LinuxCNC does not have these most simple
> > items let alone radius and shape comp.
>
>
> http://linuxcnc.org/docs/html/gcode/tool_compensation.html#_tool_table_format
>
> Thinking about it some more, I think I could just steal the lathe front,
> back and orientation cells for corner radius, v angle and full depth
> diameter. I'll have to give it try.
>
> --
> Kirk Wallace
> http://www.wallacecompany.com/machine_shop/
> http://www.wallacecompany.com/E45/
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Emc-users mailing list
> Emc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/emc-users
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Kirk Wallace]

On 04/20/2014 09:28 AM, Pete Matos wrote:
> Yeah I know the Haas has the diameter column as well as wear column for the
> TLO.   I am quite surprised that LinuxCNC does not have these most simple
> items let alone radius and shape comp.

http://linuxcnc.org/docs/html/gcode/tool_compensation.html#_tool_table_format

Thinking about it some more, I think I could just steal the lathe front, 
back and orientation cells for corner radius, v angle and full depth 
diameter. I'll have to give it try.

-- 
Kirk Wallace
http://www.wallacecompany.com/machine_shop/
http://www.wallacecompany.com/E45/

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[dave]

Kirk, 
Take a look at the tool description(s) available in APT. 
If necessary just download the whole package. The guys did a really good
job of html docs. :-)

How you adapt that to something else I have no idea. ;-)

Dave


On Sun, 2014-04-20 at 08:31 -0700, Kirk Wallace wrote:
> It would be interesting to know if there are any examples of controllers 
> with mill tool tables that include tool shape. The lathe has tip radius, 
> plus front, back angles and orientation. I would like to have end mill 
> corner radius or v angle and full depth diameter. I'm wondering if there 
> is precedent for this. Currently, I have to enter this data into a 
> g-code generator each time I run the app. For lathe, everything I need 
> is available from the tool table.



--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Pete Matos]

Yeah I know the Haas has the diameter column as well as wear column for the
TLO.   I am quite surprised that LinuxCNC does not have these most simple
items let alone radius and shape comp.


Pete



On Sun, Apr 20, 2014 at 12:02 PM, Ralph Stirling <
ralph.stirl...@wallawalla.edu> wrote:

> The control on our Haas TM-1 mill has a diameter
> column on the tool offset table.  I think this is used
> by the control only for automatic cutter compensation.
>
> -- Ralph
> 
> From: Kirk Wallace [kwall...@wallacecompany.com]
> Sent: Sunday, April 20, 2014 8:31 AM
> To: Enhanced Machine Controller (EMC)
> Subject: [Emc-users] Tool Shape
>
> It would be interesting to know if there are any examples of controllers
> with mill tool tables that include tool shape. The lathe has tip radius,
> plus front, back angles and orientation. I would like to have end mill
> corner radius or v angle and full depth diameter. I'm wondering if there
> is precedent for this. Currently, I have to enter this data into a
> g-code generator each time I run the app. For lathe, everything I need
> is available from the tool table.
> --
> Kirk Wallace
> http://www.wallacecompany.com/machine_shop/
> http://www.wallacecompany.com/E45/
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Emc-users mailing list
> Emc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/emc-users
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Emc-users mailing list
> Emc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/emc-users
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

Re: [Emc-users] Tool Shape

[Ralph Stirling]

The control on our Haas TM-1 mill has a diameter
column on the tool offset table.  I think this is used
by the control only for automatic cutter compensation.

-- Ralph

From: Kirk Wallace [kwall...@wallacecompany.com]
Sent: Sunday, April 20, 2014 8:31 AM
To: Enhanced Machine Controller (EMC)
Subject: [Emc-users] Tool Shape

It would be interesting to know if there are any examples of controllers
with mill tool tables that include tool shape. The lathe has tip radius,
plus front, back angles and orientation. I would like to have end mill
corner radius or v angle and full depth diameter. I'm wondering if there
is precedent for this. Currently, I have to enter this data into a
g-code generator each time I run the app. For lathe, everything I need
is available from the tool table.
--
Kirk Wallace
http://www.wallacecompany.com/machine_shop/
http://www.wallacecompany.com/E45/

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users

[Emc-users] Tool Shape

[Kirk Wallace]

It would be interesting to know if there are any examples of controllers 
with mill tool tables that include tool shape. The lathe has tip radius, 
plus front, back angles and orientation. I would like to have end mill 
corner radius or v angle and full depth diameter. I'm wondering if there 
is precedent for this. Currently, I have to enter this data into a 
g-code generator each time I run the app. For lathe, everything I need 
is available from the tool table.
-- 
Kirk Wallace
http://www.wallacecompany.com/machine_shop/
http://www.wallacecompany.com/E45/

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Emc-users mailing list
Emc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/emc-users