A database is any organized collection of data organized to provide efficient retrieval.
6
votes
2answers
50 views
How is my injection protection?
What do I need to do to prevent injections? In addition, if I have any statement/parameter errors, please tell me.
...
2
votes
2answers
51 views
Managing and searching objects using tags
I wonder
Is it appropriate to hide imported classes (collections and UserDict in this case) from Python IDE (e.g. IPython)?
Is there a more efficient algorithm/implementation?
Please feel free to ...
2
votes
1answer
62 views
Security of authentication check for a blog
I am currently making a very big blogging system for my Website where I want really neat code! So, I was wondering: is this method safe/does it have any problems with security? Yes, I'll be encrypting ...
7
votes
3answers
404 views
Are these Java MySQL connection classes and methods implementation the optimal?
I got three classes for MySQL Database access/manipulation,
First : Conector. It has got methods for connecting, disconnecting, querying and updating db.
Second : ...
2
votes
1answer
49 views
Delivery geolocations query
I have the below MySQL query that does exactly what I need. But I am sure there are better queries that do the same thing.
If you see something very ugly or bad and have any suggestions, I will be ...
2
votes
1answer
46 views
Cleaning up nested promises in Cloud function
I am writing the Cloud function for Parse whose purpose is to update my database with a provided array of data objects. The main problem are the nested promises, which doesn't look right. Any help ...
6
votes
2answers
84 views
6
votes
2answers
94 views
My database class extends MySQLi
The following is a small class I extended MySQLi with. I'm going to use this in my upcoming projects, but my main reason to do this class is learning, so I would like to submit this for your review, ...
5
votes
1answer
31 views
Separating Duplicates from Uniques
I have a MySQL table with a very large data. What I need is to find and separate duplicates from the unique rows
Let's say this is my table:
...
3
votes
1answer
85 views
Flat-file DB with CRUD
I just finished writing a flat-file DB class for PHP which supports selecting, updating, inserting and deleting.
I was wondering if there are any ways to make it faster or if I'm doing anything the ...
3
votes
1answer
55 views
Appropriate way to create object for storing data in a ListView & Profiling
I'm creating a location based reminder application in Android using proximity alerts, geocoder, Google Maps API and their Places API.
Currently there is a default ...
2
votes
2answers
88 views
3
votes
1answer
217 views
7
votes
2answers
273 views
Using keywords async/await in database queries (Windows Phone 8)
I have a local database in Windows Phone 8 app. The app includes a lot of queries to the database and I don't want bad effect on the responsiveness of UI.
For ...
6
votes
3answers
194 views
Repository pattern review, question about when dispose the Context
I have a question about the Repository pattern. This is my repository:
...
4
votes
4answers
86 views
Music list program
I need a little help with improving my first Java program. I have programmed for about a month, so my code is quite messy. The program is a "Musiclist" program, with which you can add songs, edit ...
4
votes
1answer
161 views
In-memory data cache architecture for data transfer
I am writing a cron job to manipulate and transfer remote data.
I need to cache data from a table, process it, merge with previous table, iterate the process, and eventually send the result data to ...
1
vote
1answer
94 views
Updating visiting dates of each visitor
I am still a PHP beginner. Please review/improve my PHP code and reveal errors, typos and warnings.
...
1
vote
1answer
66 views
Data table class
so this is my code and I just want to improve it, I'm a beginner so I think there are some better and short ways to do what I did here. Any Ideas?
The code:
...
1
vote
1answer
72 views
Login and User Information Requests
I am trying to improvise a piece of code. The best is to get reviews from experts, so here I am.
Can you have a look? What do you think of it? Any suggestions? This code basically connects to a ...
5
votes
1answer
273 views
A Simple Cache class
“There are only two hard things in Computer Science: cache
invalidation and naming things.” -- Phil Karlton
That being said, I created this SimpleCache class which I intend to use to cache ...
1
vote
0answers
83 views
In-memory data cache architecture
I am designing basic in-memory cache storage with thin CRUD (actually CRD) interface. The design is inspired by the Backend solutions such as Parse and StackMob.
Main requirements:
Cache consists ...
1
vote
2answers
622 views
SQL database design e-commerce
I am new to database design but am fairly familiar with SQL and its syntax. I want to create a database for an E-commerce website that will sell a single product type such as a shirt. They could be ...
4
votes
2answers
238 views
Implementation of OOP for retrieving list of objects from database
If I have a Person class that outlines the properties of a person and one of People that just contains a ...
0
votes
1answer
72 views
API request and database insert
This is a pretty big undertaking for me with my basic skills, and I was kind of flying blind. It's basic in its intent: get a bunch of case info from a helpdesk app and put it into a database. There ...
2
votes
1answer
129 views
Insert or update a user in database
The code uses SQLAlchemy Core. However, what I want to know is if writing code in this pattern is recommendable.
...
3
votes
1answer
1k views
How to use ByteBuffer properly?
I am trying to use ByteBuffer properly with BigEndian byte order format.
I have couple of fields which I am trying to put together into a single ByteBuffer before storing it in Cassandra database.
...
2
votes
1answer
575 views
Builder pattern for Codeigniter ActiveRecord queries
I am using Codeigniter and it's ActiveRecord.
I had this idea for a base class that provided a generic getter/setter for doing simple queries on a database. I have a lot of database objects that ...
4
votes
2answers
117 views
2
votes
1answer
167 views
Building a simple database in Python
I choose to use a dictionary to store the variables for fast GET and SET commands. In my code, I have saved all of the open ...
1
vote
1answer
704 views
1
vote
1answer
40 views
First Schema for Location and Countries
This is my first MYSQL schema for caching location data (co-ordinates to place names) and referencing it with a country.
I was wondering what everyones feedback was on it, did I do a good job?
...
12
votes
1answer
12k views
Very simple PHP PDO class
There are many PHP PDO classes out there, agreed. However I find they do not allow for flexibility. So I created one that helps reduce development time as little as it may be but it does the job ...
0
votes
1answer
192 views
guide me to make my code perfect
I had made some of pages and they work but I'm not sure if I coded it in best way so I want your suggestions and ideas to make my code better.
connection.php
...
1
vote
1answer
118 views
Generic DB Value Getter
I'm trying to see if there is a better way to do this when I just need one column with one row. Do not mind the lack of use of a prepared statement, I will put it in.
...
5
votes
1answer
561 views
Logfile parser for Team Fortress Classic video game
I'm currently working on a logfile parser for a pretty old videogame called Team Fortress Classic, which can be compared to Counter-Strike 1.6 and is available on Valve's Steam platform.
I started ...
3
votes
2answers
125 views
Querying a database with PHP
I'm new to PHP programming. I would love some feedback on this simple code I wrote which queries a database based on some arguments supplied by a user and returns an HTML table displaying the data.
...
1
vote
1answer
67 views
User Data Security Improvements
** Original Question From Stack Overflow **
I'm working on my site, and need help knowing what I need to do to improve the security of my login system.
If you feel so inclined, I would love some ...
2
votes
1answer
107 views
Need your opinions on my database normalization attempt [closed]
I'm working on a project with CakePHP where it will allow users to log their drug use. Be it alcohol, caffeine, or whatever else. When people add a log, they select the substance from a drop down, ...
2
votes
3answers
99 views
5
votes
1answer
566 views
Generic method for database calls
Background
Breaking from MVC, I've implemented the following architecture:
POST/GET ➤ PHP ➤ Database Calls ➤ XML ➤ XSLT ➤ HTML
All database interactions are ...
0
votes
1answer
117 views
Database “design” using Symfony2 and Doctrine2
I'm working on an application, which tracks expenses. I have users, and each user can create his categories for the expenses (like Food, Bills, Transport, Drinks, Clothes) and then create expenses - ...
3
votes
1answer
2k views
asp.net (vb.net): handling of open database connection and calling shared function from web api
I'm working on an ASP.NET project using VB.NET that uses Dapper
and the code as implemented so far runs fine with just me testing.
In the example below, Dapper calls a stored proc.
But my I am ...
4
votes
2answers
385 views
Android database access
For my simple Android application, I don't want to use an ORM. I'd like to have a db-communcation layer easy to user, to read and efficient.
This is my solution: every entity (ex: Person) as an ...
2
votes
1answer
207 views
2
votes
1answer
244 views
Keeping track of people's relationships in MySQL using a people relation table?
I am trying to track relationships among people. I came up with my own solution, but wondering if there might be another way or better way of doing this. To keep it simplified, I'll post just the bare ...
2
votes
1answer
298 views
Testing database table creation with NUnit
I'm new to using NUnit and have written a test to check for the existence of a database table. I have the below code that should check whether a new table named NewTable has been created in the ...
2
votes
1answer
55 views
ORM Entity with many similar relationships
To provide some background context, I'm implementing a web-based solution (Java, Spring, Hibernate) that allows the creation/authoring of task-centric workflow documents. Basically a workflow ...
1
vote
2answers
135 views
Make code looks more cleaner in the run method
I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around ...
3
votes
3answers
93 views
Simplify things in the run method to look cleaner
I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around ...
