• Hi Guest Just in case you were not aware I wanted to highlight that you can now get a free 7 day trial of Horseracebase here.
    We have a lot of members who are existing users of Horseracebase so help is always available if needed, as well as dedicated section of the fourm here.
    Best Wishes
    AR

Any Geeks, Software Developers here ?

*tom* said:
proformracing said:
We'll probably upgrade Profrom to SQL 2012 express later this year, for new installs at any rate.

Depends on testing to see if it speeds up database access significantly enough to warrant a upgrade.
Click to expand...

If it ain't broke etc,etc.
Click to expand...
I disagree. Every upgrade of SQL Server I've used since v6 has seen major improvements in speed as well as functionality.

This is a real industrial heavy-duty database designed for holding and processing the vast volumes of data that are being seen more frequently nowadays, (unlike v6 lol), and they are up against stiff competition. I've never been a huge fan of MS but with this one (and Excel) they got it right in my opinion.
 
Any advice on whether I install 32 or 64 bit or both?
I seem to remember there being issues with 64 bit ODBC and Acess?
 
I don't use Access with it, so assuming your machine is 64 bit it might be best to install both. Try using the 64 bit one first of course because it will give you better performance, but if there are issues with Access you'll have the 32bit version to fall back on.
 
jalfrezi said:
The Developer's Edition for £50 is fully featured, so includes SSIS (SQL Server Integration Services), which allows you to easily build, by dragging and dropping contols, import routines and save them as packages that can be executed ad hoc or scheduled.

This is how I run daily data imports of .csv files into my SQL DB.
Click to expand...

Ok so I have eventually upgraded SQL 2008 R2 to 2012, despite the installation assistent telling me I could upgrade it kept failing! I then realised I was trying to upgrade 2008 32 bit to 2012 64 bit!

I am sure this will make me sound very daft, but how do I access SSIS?

EDIT

OK I think because I have done an upgrade it hasn't included the SSIS?
Trying a new 64 bit installation now
 
Code: 
http://msdn.microsoft.com/en-us/library/bb500469.aspx

Have a read of that page. I think you're right, maybe if you don't already have SSIS you'll need to do an installation.

SQL Server 2008 installs a version of Visual Studio 2008, which is where you'll find SSIS. I assume 2012 will do the same, but can't be sure.
 
It took bloody ages but the 64bit version has finally finished installing and I know have SSIS!
Haven't had a good chance to play yet and need to check that I haven't broken anything else.
Back tomorrow.
 
Kevin,

Given the number of us using the various flavours of SQL now (more than a handful), I think your earlier suggestion of a dedicated forum would be very useful. There's clearly a lot of information that we can share to accelerate the learning process. It would also allows those who are not interested in it to give the forum a clean swerve. What do you think?

Ray
 
H Ray,

I was thinking more of a seperate section on here rather than a completely different forum.
I will set up a Programming Section and move this thread there and setup a few different areas within it as well.

I think we should keep it in the 'open' rather than hide it away, anyone disagree?
 
Yes, a separate section is what I meant. And I think it would be a good idea to keep it open. Might tempt others to get involved.

Ray
 
I find SQLite to be superb, although it doesn't like parallel queries so much.

You can use it for .Net, php, Java, Actionscript, python etc etc. Its very fast and lightweight and its just all stored in 1 file that you can rename, save, email to people. It might sound a bit lazy of me but it's better that the mess of having MySQL installed on your system. We use MySQL for server databases but all our software's SQLite and its works well.

SQLite Browser lets you view, insert etc. and you can even have the tables load into Excel.

Anyway, that just my 2 pence worth - nice to see a Geek section on a forum. +1 for the dedicated section for it.

Nige
Stakesoft
 
stakesoft said:
I find SQLite to be superb, although it doesn't like parallel queries so much.

You can use it for .Net, php, Java, Actionscript, python etc etc. Its very fast and lightweight and its just all stored in 1 file that you can rename, save, email to people. It might sound a bit lazy of me but it's better that the mess of having MySQL installed on your system. We use MySQL for server databases but all our software's SQLite and its works well.

SQLite Browser lets you view, insert etc. and you can even have the tables load into Excel.

Anyway, that just my 2 pence worth - nice to see a Geek section on a forum. +1 for the dedicated section for it.

Nige
Stakesoft
Click to expand...

Fully with you there mate. SQLite have always been my first choice for any app that needs a database.
It is just bloody easy to setup and get going.
 
I started out with dBase III then IV - coding in xBase. Then tried Access (yuck), Interbase and settled on Sybase SQL Anywhere for a long time... coding in C++ and Python.
Then decided it was time to upgrade as my (then) 7~8 year old setup was showing its age. Tried MySQL and Firebird but settled on PostgreSQL. I also use SQLite. It is a lovely piece of work. Does have a few quirky (to my mind) ways of doing some things though (the so-called 'type affinity' and no native numeric / decimal types)

Regarding the discussion on the actual database design, normalise it as much as possible. You can always create another temporary table (or tables) with a result set of a date range to test and or run systems or whatever (eg import into excel?). Learn SQL. The basic CREATE TABLE, INSERT & SELECT syntax isn't rocket science once you get your head around how to join tables.



http://www.sqlite.org/faq.html#q3

(3) SQLite lets me insert a string into a database column of type integer!

This is a feature, not a bug. SQLite uses dynamic typing. It does not enforce data type constraints. Any data can be inserted into any column. You can put arbitrary length strings into integer columns, floating point numbers in boolean columns, or dates in character columns. The datatype you assign to a column in the CREATE TABLE command does not restrict what data can be put into that column. Every column is able to hold an arbitrary length string. (There is one exception: Columns of type INTEGER PRIMARY KEY may only hold a 64-bit signed integer. An error will result if you try to put anything other than an integer into an INTEGER PRIMARY KEY column.)

But SQLite does use the declared type of a column as a hint that you prefer values in that format. So, for example, if a column is of type INTEGER and you try to insert a string into that column, SQLite will attempt to convert the string into an integer. If it can, it inserts the integer instead. If not, it inserts the string. This feature is called type affinity.
 
hi
i have a virus checking prog that keeps showing cookies SQLITE.file has a malware/adware/virus
i delete it and all is ok, if i start firefox and close it all is ok, it is onlywhen i start browsing the web again.
any ideas why this would happen or is it a false report

mcbee
 
Apparently this is a tracing cookie from Firefox themselves to retrieve information about you.

There are several sources online discussing the options regarding this cookie but I will leave it to you to investigate your own course of action.
 
You must log in or register to reply here.
Back
Top