justint - Developer IT

Is there any NoSQL that is ACID compliant?

- by JustinT

Is there any NoSQL that is ACID compliant? (Or is that even possible with NoSQL given it's just a bunch of loosely coupled key-value pairs.)

T-SQL While Loop and concatenation

I have a SQL query that is supposed to pull out a record and concat each to a string, then output that string. The important part of the query is below. DECLARE @counter int; SET @counter = 1; DECLARE @tempID varchar(50); SET @tempID = ''; DECLARE @tempCat varchar(255); SET @tempCat = ''; DECLARE @tempCatString varchar(5000); SET @tempCatString = ''; WHILE @counter <= @tempCount BEGIN SET @tempID = ( SELECT [Val] FROM #vals WHERE [ID] = @counter); SET @tempCat = (SELECT [Description] FROM [Categories] WHERE [ID] = @tempID); print @tempCat; SET @tempCatString = @tempCatString + '<br/>' + @tempCat; SET @counter = @counter + 1; END When the script runs, @tempCatString outputs as null while @tempCat always outputs correctly. Is there some reason that concatenation won't work inside a While loop? That seems wrong, since incrementing @counter works perfectly. So is there something else I'm missing?

Read the article

PHP 6.0 - Roadmap?

- by JustinT

With the recent announcement that PHP 6 development has been halted, I'm confused as to what the PHP 5.x and 6.x road map includes. The current version of PHP is 5.3.2. There were quite a few significant features to come in PHP 6.0, such as: APC include for automatic bytecode caching Unicode support etc.. Question: What is the new road map of PHP given 6.0 has been canceled? What major features will be available next and in what release?

Read the article

Why use NoSQL over Materialized Views?

- by JustinT

There has been a lot of talk recently about NoSQL. The #1 reason why I hear people use NoSQL is because they start to de-normalize their DBMS data so much so, to increase performance, that they end up with just one table with all of their data within that single table. With Materialized Views however, you can keep your data normalized, yet have it stored as a single table view for the same reasons why you'd use NoSQL. As such, why would someone use NoSQL over Materialized Views?

Developer IT