- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Anyone use any automated SQL generation tools (outside of Access)?
Posted on 1/12/17 at 11:52 am
Posted on 1/12/17 at 11:52 am
I am working on a large hobby project in Java with an accompanying database to support my application transactions. My SQL skills are a little light, particularly when it comes to dealing with joining tables and such...Anyone have success with automated development tools that help with this? I could use Access to get around this but then my application will not support true client server...
This is probably more of a stack overflow question but thought I'd try here too.
This is probably more of a stack overflow question but thought I'd try here too.
3
Posted on 1/12/17 at 1:09 pm to Tigerdev
Any tool you use is likely going to write inefficient SQL.
I recommended it in the 400 million records thread, but give Pentaho a shot.
I recommended it in the 400 million records thread, but give Pentaho a shot.
Posted on 1/12/17 at 1:49 pm to Tigerdev
Yes, but you add to the complexity of your app. Object Relational Mapping (ORM) tools abstract you from the actual SQL, but as posted, can build inefficient SQL code.
Posted on 1/12/17 at 2:18 pm to Brisketeer
Thanks gents. I'll look into it. I am trying to integrate the outputs of a commercial web application and a game support tool on Steam. Both are XML based so I need to be able to parse, map and ingest XML files into my tables and may have to convert them to a uniformed schema...so minimizing the SQL complexity could be critical given that the transformation could be non-trivial...
Posted on 1/13/17 at 7:41 am to Tigerdev
Pentaho has built in XML parsing.
Posted on 1/14/17 at 12:31 pm to Tigerdev
Sounds like you need to utilize Hibernate.
You can always fine tune for performance after with a sqlanalyzer tool if you find something is laggy.
ETA... Didn't read the full thread... ^^what he said.
You can always fine tune for performance after with a sqlanalyzer tool if you find something is laggy.
ETA... Didn't read the full thread... ^^what he said.
This post was edited on 1/14/17 at 12:32 pm
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News