I have a PHP file that contains a lot of "if" and "else" statements that determine what content a user sees (let's called this a block). I constantly have to modify this file (let's call it output.php), but it's a bit cumbersome with just a text editor. What I want to do is use a simple web interface to modify output.php. I was thinking...
I need to understand and clarify some T-SQL stored procedures that contain important business logic. Does anyone know of any tools, tips, tricks, or hints that can be used for unit testing so I can refactor this sql without breaking it? ...
I'm new to MVC. You have been warned... I have User model that can return a MySQL result resource to a controller. The controller passes the MySQL resource over to the view to display. Is it acceptable to print the query results in the view, using a database result fetching function? <?php while($row = some_fetching_function($database_...
Details: C# 2.0, SQL Server 2005 I have recently relinquished the idea that I would be able to get NHibernate working with my project. It would have worked great if I had started with it, but now it just can't adapt to my application. Which is in all honesty probably more an issue with my application that it is NHibernate. Regardless...
Hello there, I was wondering if there is a (c++ or D) serialisation library that also provides technics to locate a certain object (which was saved to disk) based to certain criterias like a certain attribute combination. I know about sqlite and mySQL and so own, but I search for an alternative. Because those databases are not bound to...
I have an existing database containing some pictures in blob fields. For a web application I have to display them. What's the best way to do that, considering stress on the server and maintenance and coding efforts. I can think of the following: "Cache" the blobs to external files and send the files to the browser. Read them from di...
This question is meant to serve as a list of databases and their configurations that the major web-sites use and would be a great reference for anyone thinking of scaling their web-site to the size of Twitter, Facebook or even Google. Please keep your answers to a minimum and be sure to cite any sources used. EDIT: Also, please bold b...
I'm learning Ruby on Rails and doing the contactlist thing, 20 minute blog and so on, but I am concerned about using RoR with existing non-MySQL databases. I know RoR can communicate with non-MySQL; in fact, I am using jRuby on Rails so I can use JDBC. My question is how RoR works with existing database. Do I lose all the benefit of u...
I want to use the DbProvider class to construct a generic DAL component. This will be convenient when switching between different database providers. On a machine with Oracle 2.2 installed the Oracle provider ODP.NET is not listed when trying to list up all the database providers available on the machine. DataTable dtable = DbProvid...
If I change a field in a Django model, how can I synchronize it with the database tables? Do I need to do it manually on the database or is there a tool that does helps with the process? ...
I have, I believe followed the set up instructions correctly for connecting paypal to my script.I have a game that is set up to let users buy credits. Right now I have to add the paypal info directly into the database. I get the transaction email, both me and the user confirming the purchase. But it will not show up in my database.Can so...
I am working on a simple invoicing and accounting applications, but I am totally lost on how to represent accounting-transactions(journal-entries) in a database. Using a separate debit and credit column in the database seems like one way, but most of the Open Source Accounting I have seen use a single amount column. This I assume simplif...
While looking at ways to improve processes for an in-house analytics team, the "Correlation database" approach used by i-lluminate came up. Documentation and real-world stories on the platform seem to be scarce, and I was just wondering if people out there had any first-hand experience with it? the following are requirements of partic...
Hi I have table with column in ms Access Cost Repair Maintainance Wear Fuel i want this rows as Repair Maintainace Wear Fuel as separate column as shown above ...
I've got these columns [in a single table]: partnumber bin description store manufacturer I need to output the store and manufacturer as rows for each partnumber, bin, description column. ...
I have a Hibernate domain class (let's say PetOwner) with a one to many relationship with another class(Pets) [PetOwner (1)---------(*) Pet] Due to a drastic change required to improve the performance I had to change the fetchtype of the getPets() method in PetOwner class to be lazy. So the current mapping looks as follows @OneToMan...
I am trying to reduce fragmentation in all of the indexes for a database running on SQL Server 2005. Currently I am trying to use ALTER INDEX in conjunction with sp_MSforeachtable, to apply it to all of the indexes for all of the tables: sp_MSforeachtable "ALTER INDEX ALL ON ? REBUILD;" But for some reason this doesn’t always seem to ...
I have a domain object in Grails that needs to store a set of key/value pairs for each instance. There should never be more then about 10 pairs. The users of the application have to be able to edit these key/value pairs. Right now I'm looking at storing the data in a HashMap for each instance of the domain class. While I think this will ...
How do I stop thinking every query in terms of cursors, procedures and functions and start using SQL as it should be? Do we make the transition to thinking in SQL just by practise or is there any magic to learning the set based query language? What did you do to make the transition? ...
Hi, I created the SQLite database the following way: private static final String DATABASE_CREATE = "create table " + DATABASE_TABLE_SETTINGS + " (" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NAME + " INTEGER UNIQUE not null, " + VALUE + " TEXT not null);" + "create table " + DATABASE_TABLE_RECORDINGS + " (" + KEY_ID + " ...